I am trying to determine whether or not a record already exist in a table
using DLookup. The table is called Month_End and contains 2 fields called
Month_End_Date and Month_End_Total. Here is the code I am trying to use:
   Dim strValue As String

I have a program that runs every 5 minutes 24/7.  One of the tables I use is
a linked table.  During the night some maintenance is being done to this
table which causes the program to get the "Run-time error 3146".  I tend to
omit error handling (I know, not wise) and hadn't used ...

I need to make sure the machine the db is on is set to a certain resolution
in order for the db to appear correctly (and probably reset back when the app
is closed??)
What are your thoughts about doing this and ... how might one go about it?

is there a way to disable the 2 security messages on startup in 2003 using
vba ?
henry

I have been trying to get my mind around VB coding and forms.  I have been
using Access VBA for about five years so I thought it would be an easy
transition.  It's kinda like trying to translate Modern English into Old
English.

I have went to the tools menu to recover some files that I had deleted.  I do
not have the option to recover deleted items.  How do I add this option to my
tools menu?

Here's my problem:
If I make a button on my form to open a report using a wizard, this works
fine. However, when I add additional code and then use the button it shows an
error stating simply "Object Required", with no other information and only an

When using VBA to create a Snapshot file a dialog box is shown as if the
Snapshot is being generated, however, the actually Snapshot doesn't get saved
at the file location I specify. There are no file-level security restrictions
to hinder the creation. From the creation the file ...

can anyone point me in the right direction to be able to use a multi line
text box to generate an SQL statement.
For example, I want a user to be able to manually type in a list of product
codes, click a command button then generate a list of matches.  It is

I have my database, complete with index definitions, constraints and
referential integrity. Now I would like to export the underlying DDL. It
seems this cannot be done. Am I missing something?
Thank you

This seems simple but I can't find a way.
I have a 2 column combo. Limit to List True. In After update a lot of
calculations that set up the following text boxes. If a user just tabs or
clicks on another control the text box dosn't update. It also dosn't check

I use Msacess 2003 and I created a report with chart ( the control name is
OLEunbound0). The chart is linked to a query. I want to write a macro or code
to periodiclly refresh the chart or once the underlying data is changed.
Anybody knows how?

Can you change the color of a message box say from blue border to red?

i am using office 2000 and facing the problem of missing reference.we
have lot of pc on server and all need to add data in database at
different stages but most of the time they open or any changes I make,
it  give the missing reference error.

I have a table named Car Order and form Car Order Form.  On Card Order form I
am calculating Sub total and Total Amount by adding few field together.  For
example in control source for Sub Total fileld on a form i put: