I have Access 2000 on the job. I have two tables (CDCR#, Last Name, First Name, and DOB are the only fields) and with many medical related fields. ...

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 3 fields for Name. LastNm, FirstNm, and Middle Initial. How do I ensure the full name, i.e., "LastNm, FirstNm, MiddleInitial" combined are unique...

Hi, I have a job list form with basic info on it. I want to be able to click on the job number text box which then opens up a more detailed form and applies...

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...

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 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, I am trying to locate the expressions: IIF, Count, Sum, in the Expression Builder window opened through Validation Rule in TableDesign. (Access 2002...

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...

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....

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,...

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...

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...

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 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 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...

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...

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 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...

Hi I am trying to learn how to design a relational database. I have designed one database in access 97 but it was a flat database file since I didn't know how...