In this case, I need to have 6 characters to identify a produt code. Not 5, not 7, but 6. In the table design I already set the field size to 6 maximum. ...

Hi, I am trying to create an access database that has historical data and new data is imported in monthly. I need it to be able to check each time if it's a...

I have an option group of 6 outside the frame there are 3 Cmd boxes ie, print, preview, close. I simply wish to preselect an option and Then click either say...

I have my main database and have been asked to add additional functionality. What is needed is to create courses, with dates, times, fees, and...

I have an old database with a form to set report criteria. It works fine in Access 2002 and 97. I have recently upgraded to Access 2003 and the macro...

Where is the SetValue Action in Access 2007? When I try to create a macro the action is absent. Is there a way around this? -- Thanks, Chuck

I have a database created in Access 2000 which uses a setvalue function in a macro to set the value of a date selected in a form and is then referred to in a...

I have a client record that when I push the events button I want a Events Form to open up and automatically set the ClientID# so they can start entering...

My company is currently starting to use Access Databases to collect information from various parts of the business, some related to each other such as...

Hi everyone I use Access 2003 and have seen several sample databases which have at least one table with multiple keys. I understand that there can be only...

Hi, I am been trying to think of a way out on this situation but I can not clearly see one. Can anyone help? I have tblOrder and tblOrderDetails along with a...

My daughter is setting up a small business with a friend - they will work from different locations but will need to share a database which I am going to...

I am using Access 2003 I created a database for a PM Program that sometimes requires more than one person to use the program at the same time. Is there a way...

I created a database and it works great as a stand alone application. When I put it on our company LAN only one person at a time can have it open, how can I...

HI I have created a database to record responses to a survey. This database will occasionally need to be accessed and potentially updated via a form...

In outlook 2003 a user has 4 other users' calendars which she monitors (beside her own calendar). However when she attempts to open one of these shared...

I'm anticipating something like this: PERSONS PersonID Person fields... REQUESTS RequestID RequestDescription RequestType

Please can anybody tell me if there is a way of seeing who is locking a shared database other than decyphering the .ldb file?

I need to update the table for a shared database. However there are lots of employees that share this database & although I've requested everyone to be out...

I have an application where it is impractical to have each individual user have their own copy of the front end. What drawbacks are there to having a separate...