Hi, I am working on a genealogy form. The only table (so far) lists everybody in the family, one record per person. Each record has an autonum ID. The...

Hi all; I have 2 tables. One main table (lets call it A), one table that has information that needs to go into the main (B). Following the advice of some...

Does the 1Gb limit apply to post 97 versions?

Hi I was wondering if anybody could help me with the following: I have imported an excel file into Access 2003. The file was made up of two worksheets. As a...

I created a simple form for a group to track members in their interior design society. The problem is the data in the table and form is in the order the data...

hi Duncan. if i understood correctly, you're saying that the database i sent you works "correctly", or as desired. but yours does not, and you've...

I would like to either hide or remove the built in menu (File, Edit, View etc.) Can this be done without changing other office program menus?

Hi all - I need help with subforms. I have a main form with multiple subforms *eek!*. In each of these subforms I need to allow records to be added to the...

Hi, I have 2 different versions of MS Access (97 and 2000) installed on my computer, as I need them both. Recently came across a problem where when I try to...

When I take a particular Access2000 database (J1) that I created at home, and open it at work, it causes Access to crash. To make things more complex, it will...

Hello, I am using an Access Form for data entry. There is a subform inside which brings up a list of matching last names. Every time I open the form...

How can I get my "ORDER BY" results to show in descending order? Please email me at Thanks.

I am importing .bmp graphic files into my database. I delete the graphic file after a few days. The database seems to keep the data imbedded because...

I have a macro that runs a make table query. Every time I have to click yes to delete the existing table. Is there any way to make it run without asking me...

I am having a bit of trouble with the Datediff function. I have two fields Start_Time and End_Time I want to use the DateDiff command to calculate...

I have a database that keeps track of test scores and eligibility for promotions. Eligibility for promotion is based upon test score and years of...

Hi Can anybody help me with the following? I have table which looks something like this: Date Quantity Sold 01/01/03 5 02/01/03 2

Can anyone help me with this one? I have a table in a personal database with Previous & Current Addresses for we have lived. I'm using that table in a query...

Can anyone advise if Microsoft officially support Access 97. Any links would be advantageous. Thanks

Hi, I have a form which contains Last Name, First Name and SSN combo boxes, which will get their values from table 'tblPhys' The First name and SSN Combo...