Is there a way to compact the database everytime the exit button is clicked? Thanks, Jasper

I am looking into designing a Access Database that would help run a Tournament. Features it would need to do. -Have a way of Entering in Players -Have a way...

I have a client using Outlook 2003- and she keeps getting memory error messages when trying to access her supervisor's calendar. She has rebooted and this...

I am having some difficulty with this code and am wondering if someone can give me some assistance. I am experiencing this problem with all newly created...

I am creating a database list of our volunteers. Some volunteers serve on more than one committee. What would be the best way to format a database where when...

Seach in Vista has been improved to the point where it is incomprehensible and therefore unreliable. The user has no clue what folders vista will search,...

Hi all I am giving the following sql to get month as string from a date Select Cstr(month( salestarget.targetdate )) as monthno from salestarget. So the...

I have a form which has 2 check boxes: Invoice and Cheque. If I tick 'cheque' then 'cheque number' and 'date' become visible. and when I tick 'invoice' then...

I don't know if this is possible or not, but I would love any ideas and help on how to accomplish it. I have an excel table and I need to import some of the...

I am creating a form where addresses are needed, however I would like my form to auto populate if an address currently exists within the linked table or...

I have a form called frmArticles that has a subform called sfrmArticleTasks that is in a container called isfrmArticleTasks. This way, I can keep better...

I'm adding a new Yes/No field into an existing DB. I will update some of the records based on data in other columns (To be precise, previously I had a fake...

I have a query that is using 2 tables in it. One table in that query has a field called LeadDetailID and it is an autonumber and a primary key. The 2nd table...

Hi, I have a Database in Access 2000 that have a button for opening a file from the server, using Internet Explorer. Can I change the URL in the address...

I have 3 tables - Stores, Memos, and Memos Received Once we send a memo, we request stores to fax us back a signed copy of the memo. Memos - include...

I'm constructing a simple query and depending on how I do it in the Access design window, I get different results. The SQL for the two queries are hereunder,...

Our application has used this PrintersClass module for some time without a problem but some new Toughbooks have issues. We use laser printers, usually the...

I know you should not have fields that total the results of other fields store in your table but how do I get the results to show on my reports or queries. ...

How can I get the average of a querry result field based on the condition of another field in the same query? For instance I need to get average value of all...

Hi im a beginner to access. Im maintainig a database made in access 2003. In one of the module there is an application which is linked with outlook and...