After inserting Allen Browne's Audit Trail code, I attempted to change some
data in my Hardware subform.
I received the following error message: Run-time error '3825': SELECT cannot
be used in an INSERT

I have 3 comboboxes on the form and all of them have a query for their
row source.
It seems MS Access running teh query in the background to get the list
which is very slow to load the form.

I have modified the Allen Browne search form to filter the results of a
parameter query. The query gets its paramters from some of the fields on the
search form. It works but only if I type in the Locality parameter. For
Example:

Hi, i'd like to get the login name for any given user (we use a shortname for
our network, consisting of their first initial and last name) and use that to
filter out all the records except the ones that have that user's name on
them.  I'm not worried about all of the security ...

I tried to have this coded properly.  It seems to returning all of the
correct answer but one never knows!  Could someone please look at my
parentheses to see if they are correct.
Thank you

I am working on a project to figure cost to install Millwork
I have a form where I enter the cost to install each item on
this form I am using and unbound textbox in the footer to
total the cost column

Could someone point me a website where I can get some information and
examples on how to create tables with VBA code (ADO reference if possible).
Thx,
Ludovic

I got a weird problem. I can open my .mde version (the developer's side), but
my users encounter a pop-up error message saying error in function or
expression. I check the function and query and everything is normal. Do you
know what cause the problem? and how to fix it?

How can I set an ActiveX Calendar for the Friday of the week that the form is
opened on.
This is for a report that is a sign up sheet for a weekly event.
I have set to current date with:

I have a multi-user application that executes on a runtime on a file server.  
I didn’t split the database by “front-end” (forms) and “back end” (data).  
When there is no corruption, the database runs smoothly for days. On
occasions, the database gets corrupted thereby needing a ...

I have a table with 3 fields [DateIn] [Rates] and [LastModified]
DateIn default value it is set to Now() in the table
When a user enters a new record he is required to enter a Rate only. The
system will populate the filed DateIn automatically and at this stage the

I have a main form with the following controls:
 1.. a combobox for selecting Commune Name/Code and
 2.. a subform that display a list of Name, position and photo_path when
commune in the combobox is selected. I have put

Dont know if this is possible
I am trying to create a continuous form that contains staff details and
daily shift times. I would like to be able to update a text box on the form
for each record dependant on the shift worked.

I have designed a form there are two fields called actual payment [AP] and
commission [comm] the scenario is like this if [AP] is from 1 to 25000 - the
bank will charge 25
as commision [comm] (THE FORMULA I WANT TO ENTER IN [COMM] and from 25001 to

I have a Client form with 3 fields. cboName, txtAddress, txtID
When I go to a blank record to type in a new client.  OnNotInList I'm asked
if I want to add the new client, I select yes.  When I try to add the
additional info on the form and close the form I'm told the changes will ...