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

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

When I update a feild in MS Word, Access opens up to get the proper information, but does not close when it is finished. Essentially, every time I update a...

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

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

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

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

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

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

Is it still 1Gb for the latest version of Access?