I've inherited an Access 2003 database. The colors on one of the tables are dreadful, to my eye. How can I change the colors for the background and the font...

Client has requested that if one user has started editing a record, then the record should become read only for all other users. Is this what is known as...

I have a database tbl_Vendors = Vendor_ID (auto) PK tbl_Sites = Site_ID (auto) PK, Vendor_ID (number) FK tbl_SiteVisits = SV_ID (auto) PK, Site_ID (number)...

Hello, I need an assistance please. I have a subform with the following: Item Number Quantity Pulled (Check Box) 001-00000000C ...

Hello - I am trying to create a unique index for values in 2 fields. However, one of the fields does not alway contain a value. Is it possible to create...

Good afternoon, I have created a data access web page to allow easier access for multiple users to update a multitable database. When Microsoft's wizard...

I've linked an Excel table, but cannot create a lookupfrom another table. I keep getting the message, "you entered an expression that has an invalid...

I have a table that conatins 2 fields, the first is an application name and the second contains a list of servers separated by commas. I need to change this...

How do I enter a Field Name (Column Title) on two seperate lines on a Data Table? For example, I want to name the Field "Customer Number" with "Customer" on...

Is there a way of overriding certain Access error messages with my own? I know you can do it at the form level, but is there a way of just saying..."anytime...

I need to create an autonumbered field in my access 2003 database that looks like the following: DCR-07-000 The DCR is a constant, the 07 is the year and...

Access 2002, fully service-packed, with linked SQL-Server 2000 tables. Somewhere between Wednesday morning (everything worked as expected) and Thursday,...

Out of 9 computers running access xp, 2 of them give me the error :"The command or action 'SendObject' isn't available now". I am using the sendobject to do...

Is it possible to fill in text within a drop down box? For example, can a drop down list include: "Yes" "No" "Other:____(Free Text)______" Thank you. FYI -...

Hi all, I don't have a firm grip on how to handle people within some of the applications I do and could use a little feedback. I'm redoing an application...

I have developed a database where I need to track the equipment in each room of a building. Since some equipment do repeat (Manufacturer and Model) the...

I have a form with a few drop dows and a command button. Each command button has an on-click event, as below: Button_A: this works DoCmd.OpenReport...

Hi everybody, I have two databases in two different offices. I need to create a third database that will work with the data of those two databases. Here is...

For my husband's small gardening business, customers are usually identified largely by their address. The customer may be known only as Madge (sometimes called...

I am trying to add a drop down menu for States in my database design. How do I do that? I am very very new to access. I am using Access 2007.