Hi I need to stop any error messages coming up on the
screen is there a way i can supress all the errors and
just create an entry in a table of the error number and
the time & date

Is it possible when I open the database I want the ldb file will have a
different name than the mdb file
Ex: my database is: client.mdb I want the ldb to be test.ldb not client.ldb
Thanks for your help

I have a form ACCT where the user enters and account number and clicks  
button that has code to 1) verify if information is in table A and 2) Open
the detailed form using link criteria to open for only that ACCT#.  It was
working until I added a subquery to the query that drives ...

Windows XP, MS Access 2000
======================
Hi,
I have the following line of code in the OnClick property of a button on a

Greetings to all.
I am puzzle with an inconsistant result from dlookup, warning of “Duplicated
Value” in a form control “before_update” property. I am creating data entry
forms for different work areas. The sub worked for one area but not the

when moving around in a forms memo field I can't move the cursor without
text being selected.
this is very awkward if not annoying as the user may need to delete some of
the words.

The code below uses ADO to "sequentially" search tblTasks for a matching key
and then extract the value of another field in that record to open a form.
Given that TaskID is the primary key of tblTasks, what is the efficient ADO
code to find that record?  Any other commens on ...

I need to carry over information from one to another record, previously enter.
I would like to code an Command Button [Add] .  Everytime the use click add
some info from the previous record is carried over.

Hi I am using the following to get my file locations
Set wShell = CreateObject("WScript.Shell")
path = wShell.SpecialFolders("Desktop")
path2 = "E:/Backup"

I am having a problem with a subform nested within
another subform.
When the recordset of the main form is changed the
subform does not refresh.

I have a feild that I would like to count the 0 or less on the form header.  
I know that if I would like to count all records it would be count (*). I
dont know what code to put in the ( ). The feild name is net.
Any help would be great. Thanks

I have a complicated form that I want the user to be able to access help on
some of the controls.  Some of the help will be one sentence and others could
be a pararaph or more.  How can I get my form to do this?

Ok this is a good one. I have a drop box that get the Manufacturer part
number from a table, it then populates a set of fields using the AfterUpdate
event. I want to display a warning to the user that tells them if the
quantity ordered is greater than the quantity quoted. I ...

I am getting this error, #2486, "You can't carry out this action at the
present time" when trying to close forms or go to other forms after I
update a number of records in my database via code.
I can't tell exactly what is locking it up.

I have three fields:-
  Type (1 character + or -)
  Bought (currency)
  Sold (currency).