I have limited experience in Access and have just begun working in the 2007 version. My experience is all self taught and on-line with MS Office training. ...

From within the report_detail event, how can I tell if I'm processing the last record for the report?

Hi I´m really stuck - and can´t see what i´m doing wrong. I have 3 tables - Customer Details (Customer ID is the PK) containing address etc. Unit...

I need a formula to flag a datefield when I enter a date. If the date is blank leave flag for date field blank. -- Kofi

When I'm creating a table, I'd like to make the Primary Key an autonumber that is the date and time the record is added ie. yymmddhhmmss I don't want this...

I want to build an expression in my table so that when I type a particular City name, the zip code of that city will automaticall fill-in in the "zip code"...

When I set up a field in a table as an OLE object so that I can have pictures of employees on a form, I get this error: "A problem occurred while Microsoft...

How do I validate duplciate values in a text field in a table. I have a field that cannot have duplicate records entered by the same dealer name. Do I use...

I have a text field in a table. I want to validate new records so no text entry can be entered more than once. The name of the text field is Will it work to...

I have a field with a data type of OLE Object. When I insert a bmp file, the field displays "Package" therefore I cannot view the picture in a form. ...

I am building up an address database, where I will need to add data frequntly. The database is built up in a number of tables and I wonder what is the right...

I'm working on a very basic database design for entering data from a survey. I am used to working with numeric data in the analysis stage. How do I define a...

I am working on a database to record inwards and outwards mail and work in progress for my workplace. The database has been in existance for a couple of years...

We have been using a product called Access Autopilot for the past year, but have been having some problems for several months. We have not been able to get a...

I need to change the look-up field in a form to "LimitToList" to "No", but I keep getting the message: "Microsoft Office Access can't set the Limit to List...

Hello I am looking to found inventory system that work with barcode. Do you know any example file that I can see ? Thank you

eg 'Customer Details' form in 'Northwind 20071' has two linked pages, 'General' & 'Orders'. How do I ceate that design? I have tried the Insert Page control...

Hi I am quite new to Access but I am desperate to learn as much as I can as fast as I can. I am currently working on automating an annual leave process at...

Anyone have a sample that saves signatures as images?

Greetings I am creating an application which is rather typical in it's need for customers and orders. I have a table for Customers one for Orders and one for...