I see that it is possible to compact an open database
using:
Tools -> Database Utilities -> Compact Database
I want to incorporate this into an event procedure but

I am using MS ACCESS for the first time and trying to create a data base.  I
thought I had acheived the most difficult part after I completed the "tables"
part as well as completeing a data entry form that links to it.  On my FORM
in design view my tool box shows an button for a ...

Hello, I am receiving an error at "Set rs5 = ...". Can someone please tell
me where they think the error is? I am at a loss as to what could be causing
the problem. Error 3464:Data Type Mismatch in criteria expression
Dim db as DAO.Database

I have a strange beheaviour in a form + subform.
When the form is launched the recordset appears empty and the recordcount is
set to 0.
Copied the SQL select statament that is used in the form, and pasted in the

Hi, I have created a vb.net application validating a CAS-number (chemistry).
I want to access this program from a form in access. It is possible to open a
external program using the event procedure, but cmd. closes after the program
has run.

I have an issue with an unbound form I really do not understand.
The form has 1 combobox and 3 listboxes
The rowsource of the 3 listboxes is empty when I open the form. When I
update the combobox the Rowsources of the listboxes is being filled

I have a form based on a query and on the form I have a button that calls
code to  filter between  a start date and a end date using:-
Me.Filter = "datevalue(FromQuery.audDate) between  CDate([Required Date])
and CDate([End Required Date])"

I have a main form and a pop-up form which needs to be linked somehow.
The pop-up form is being used to add information, and the main form is also
used to add information and both forms details need to be added to 1 table.
The main form has all the questions which need to be ...

I'm working on a project to assign UPC numbers. The next UPC to use will be
stored in a table with one field, one record.  On my form, I have a button
'Assign UPC', I want the code behind the button to read the next upc number
from that other table, add 1 to it and write it back.  I ...

Scenario: The code below allows me to use an unbound form (frmLocateTaxPayer)
with unbound text boxes to open and filter another form (frmTaxPayerInfo)
based on the search criteria entered by the user. The problem I am having is
that I do not want to search the txtTxPrID field ...

I want to assign default values to some fields once the user adds a new
record to the table. Right now I'm doing this by executing some VBA-code in
the (form) before insert event. This works, but the user still has to modify
at least one field in order to fire the before insert ...

Hia,
Could you please send me some sample line or idea how to
log off after x minutes inactivity?
Many thanx in advance

I am building an Access 2000 application utilizing a Microsoft  MSComctlLib
Treeview control.
By default, the treeview only shows tooltips for the node text that extends
past the treeview window and only displays the node text.

Dear Users,
Is there a way to convert any given degree into degree latitude? The range
for latitude is from -90 to +90.
E.g.#1 Given a -120 degree, its degree latitude would be +60 degree latitude.

i have a form which I have wriiten following code to prompt user to enter
desired code but I would also like to show all records where field
assesment_number is not blank  ??.
private sub form_loas()