I am trying to have a button open a custom help file.  I have simply set a
hyperlink to the file.  I have used the code
Private Sub Command124_Click()
DoCmd.SetWarnings False

I have a table that gets updated in one database. I don't want to link this
table to the other database. I'd rather use vb in the open database to copy
the table to another database. I guess I would also need to delete the table
in the other database before copying the new one ...

Using Office 2003 and Windows XP;
When you access, for example, the back color of a control there is a color
palette with built-in colors and below this is 16 squares called "Custom
colors".

Is it possible to test for a successful internet connection say on form load
to set control parameters?
Id like to disable controls if a call to the internet would fail (I can trap
that in an err statement) but enable the control if the call would work.

Hi i am having two tables
1: Code
2. Data
Code-asset_value-Month_fig_refer

I have 10 databases that have the exact same layout (employee time).
What is the easiest way to combine the information into one new file.
I have tried JOIN  and UNION and either don't really understand how
they work or used them incorrectly.

dear sir,
i have the access -03 as back end with some forms.
how to access these forms with front end programing
i mean i want to get the forms in the data base by an external front end form

I would like to open a specific workbook with this code. Can someone tell
what I should insert. Everything I have tried doesn't work, possibly because
I don't know what I am doing.
Private Sub OpenExcel_Click()

in my Access 2003 VBA event procedure, the "stop" command no longer stops
execution.
It used to work.
any ideas?

Is there a way in VBA to check if a linked table in the database has
been updated?
Example:
I have a table "LedgerTemp" which is a direct link to a text file on

I have 2 tables (Employees) and a (EmployeeInformation).  I want to send each
employee an email with the data they have in both tables.  I  would like to
automate sending this information so each employee would get their
information (and only their) when code was run.

I have a table rcalled Records, with the fields
ID (Autonumber)
RecordNum (long int)
and a form called FormRecords with this table as its source.

Hi Allen, thanks for the quick feedback
my database already had the Break on Unhandled Errors selected.
I decompiled as you suggested (...\office11\msaccess.exe"...)
now  I get an error ... variable not defined.