My Acces 2003 database is used simultaneously by several people, but it is not split. Could this be the reason for Error 3709 which happens when a user is ...

Access/VBA newbie here and I have the following situation: A research facility mixes elements(LotID), processes them, evaluates the end product and then uses...

I have a table with all our Sales contractors. It has names and their IdCode. Also, there's a Sales Order table where all their sales will be entered. On...

I work for a Regional Utility , am creating a data base of labretory results, there is a large number of repeative entries ie: analysis results,sample...

Hi folks, My laptop is set to go into hybernation/standby mode if I there has been no activity for a set period of time. To "wake" the computer, I have to...

Hello. Just came across some stunning discovery, my database of customer complaints seems to be working fine, BUT when I open access file and enter 1st...

Hi, I have been given a project that was done by an intern who no longer works at my company. In his database design, he put the master table in a...

I have a field with NUMBER datatype, SINGLE field size, Fixed format and 0 Decimals. When I enter the value 100317090407 the number rewrites itself as...

My PC will not access our office Network. If you try and access it, it says that the Shortcut is unavailable. All the cables are plugged in and it was working...

There seems to be a substantial number of people using a switchboard in their databases and I have never bothered. I simply use a form with buttons for...

I create ms access database. In field level i get problem in date/time field when i enter any date manually it accepted, if i delete it display this message...

I would like to see the date from the timeline table (propertyavai field) in a field of another table, so I was trying to set the default value so I wouldn't...

I have a table, tblPatientV1, and a table, tblStatusV1. tblStatusV1 has two fields; ID and Status. Status has Active, Inactive, and Discharged entered as...

I'm creating a form and while going and back and forth I can no longer view my form!

I can't delete tables or relationships ... delete is grayed out. Help!

I am trying to set the focus (SetFocus) of a find button to default to a specific field. I have done so successfully in other Access Files. However one file...

I am using a table with almost a million records and redesigning a database to run a series of queries which currently are very lengthily. Could someone...

What is the advantage in defining relationships in the Relationship screen if I can define the relationships I need right in the queries when I need them?

=IIf(IsNull(), "N/A", ) The result I get in my text field is "#Error"

I have a data base developed in access 97, converted to access 2000 and now I'm trying to convert it to 2003 but most of my reports queries and forms use the...