I notice when my users are very busy on particular days, that the backend mdb grows. I compact it automatically, but I am curious as to why this happens? Also,...

Is it possible to use the solver function from Excel in an Access spreadsheet. Alternatively, is there an Access based optimiser? Thanks

Hi all, I've read http://www.cpearson.com/excel/events.htm to help me understand how to trigger a macro based on a cell value, but can't get it to work. I've...

If you don't specify a relationship type, Access will try to guess. If there is a unique index on the field(s) on one side of the relationship only, then the...

I want to tick a box on a form to start a job, the tick another box to finish the job, then have the total time to do the job appear in a report. Can anyone...

Fairly new and still (always learning) and am stumped. My tbl has 6 fields, all text. On my form I want the part number to be selected from a combo box (I've...

How can I prevent change of .mdw file, which my mdb is using? In my database every user has diferent permitions for every table,form,query and report, but...

I'm using Access 97 and have a form with a bound table set up so that if the user opens it, it automatically defaults to display a new record. The focus goes...

I am starting a business in the next several weeks and am looking for a database that can do the following : CRM Service Call Inventory Order history Can...

I have 10 identical Access 2000 databases installed on 10 laptops in the field. I have created a macro that will, Action: "openquery" with all the fields in...

I'm a new guy with access data base, I have created a form based database, and I like the way forms work. I need to allow the data base to work over network...

I want to create a databse that will be accessible thru the web, for updating and viewing information using a webpage, how would i go about doing this? the...

Hi I have been asked to do something for one of the departments in my office - I thought it would be easier than it's turning out. They have a years worth of...

I have a database that was supplied as an Excel .csv formatted file. I wish to import this into Access. The instructions that I was given we- In Access go...

Hi, I entered a name into the form and ran out of spaces. I went back to the table to increase the field text limit from 50 to 70 It tells me I have to first...

I have a VBA utility that imports tables in a MS SQL Server 2000 database to an Access 2000 database and also provides the user with a function to delete these...

Thank you David This info is very useful to us. Maurice St-Cyr Micro Systems Consultants, Inc

hello, ever since I upgraded the access runtime to 2003 I get an error message ever time a database is attempted to be opened. It says: Worgroup...

Hi im having lots of trouble with parameters The first parameter works fine () Or ( IS NULL) Its the second and third that im having trouble...

Hi there....I have a report that I have created that I want to SS number to be on ONLY if it is going to a certian place, otherwise I want the report to leave...