HELP! I don't know what happened. I was just doing basic cleanup of forms and reports. Now any event that fires gives me an error - all based on "File...

I have a Combo Box based on a look up table for a percentage field. The percentage field has been set up as follows: Field Name: Percent Data Type: ...

I'm running an Access based reporting application in two environments. The older, MS Access 2000 version has been running for years without issue. If I run...

I have a database with a frontend that was built in Access 2000 and at the time we set it up with a SQL 2005 backend. Recently we upgraded to Access 2007. ...

Hi, Hope someone can help. Here's the scenario: I have two MSAccess tables MainTab and SubTab. MainTab has an autonumber 'id' column as primary key. ...

Hi there, hopefully somebody will be able to offer me some words of advice. I am creating a database for a firm that deals with property insurance claims....

Hi, What if you have two organizations and you plan to design a database to do the same task but within that task, the defined tables will vary because of...

I have 3 fields for Name. LastNm, FirstNm, and Middle Initial. How do I ensure the full name, i.e., "LastNm, FirstNm, MiddleInitial" combined are unique...

I have a table with a Gross Sales field and a Total Costs field, there is a third field called Net Sales. How can I create a function to take Gross Sales...

Things like on the forms (beside each label), how can i include a question mark symbol that, when the mouse hovers over it, shows the format needed for the...

I have a split Access Database on a network. I need to add a new table to the database. Do I export it to both the front end and the back-end or do I run a...

Hi, I am trying to locate the expressions: IIF, Count, Sum, in the Expression Builder window opened through Validation Rule in TableDesign. (Access 2002...

I have a database that I want to share over my network (total of 9 computers on network). I split the database to have a FE and a BE. However, once split,...

I have two fields and I wish to validate one to depend on the other This what I would like to happen if field1 = text1 or text2 or text3 field2 must be...

i have a form with a subform and on the main form i have a toggle button that locks the subform.. with this code !!.Locked = bLock this worked fine until i...

I need to design a database that will track the supplies ordered from a supplier as well as track these supplies when they a shipped to investigator sites. I...

I have a date/time field in a table for which the format is general date. The default value is Now() which returns for example 4/27/2004 12:31:10 PM. How can I...

I use a crosstab query in a database as a first step in recalling multiple monetary transactions made on the same day that, when added together, exceed...

Using Access 2003. I have a tblFamilies and a tblFamilyMembers. What do I do when I have a "family" where the Dad lives at a different address and is...

Simple question, hope I can get an answer.... Ok, I have created a table and form for our company to keep track of incoming inventory. Being that we work...