What exactly happens when Access encounters an untrapped error?  It
seems like it is resetting all global variables when this occurs.  Is
this indeed what is happening?  If you have a global variable assigned
to an object, is it set to nothing when an untrapped error occurs?

From  http://www.regdeveloper.co.uk/2008/01/14/office_mac_08_vba/
"VBA will disappear completely when Office 2007 for Windows is replaced,
sometime around 2009.
Microsoft announced last July it would no longer license VBA and said future

I am trying to get a date to work correctly on a query that is
connected to a form.
The query produces a report.
When I click the command button on the form the parameter dialogue

I have one question like that:
I have one customer table: customerID, name,address,phone,zip.......
I must check the customer in this table or not before insert it. The
records of the table is 1000K, I will check the zip, name and address,

In runtime environement my access 2007 application dont show the Navigation
Pane, anybody have this problem ?
Thank's for reply
Bob

In my app I have a form that fits into the whole screen. The form is
maximized. When users work in other apps while the Access form is still
open. The Access form very slowly moves down. After a while the form has
dropped that far that the record buttons and number are no longer ...

I'm having a bit of an issue making a self join in access (similar to
the example explained on Allen Browne's excellent site -
http://allenbrowne.com/ser-06.html).
I've made the self join in the query window, however when I've tried

I'm sure this topic has been rehashed here, but why is a DELETE query of the
type
DELETE FROM A WHERE COL NOT IN (SELECT COL FROM B);
so bleedin' slow?

Is there a possibility in Access 2003 to easily edit a form? In Visual Basic
you can even use a texteditor to edit the forms and modify properties of
objects. This is far more faster and easier than in Access.
Thanks

Hello people,
I have some records in a table that have common values for ex:
FNAME        LNAME          SSN               EE
CH                SP

I've built a DB I would like to use in an Intranet through web, this
way a small group of people can gain access by typing the address in
their browser. It is a small DB, with a few tables. I've built a
couple of Web pages using Access (2003), and later an index with both

Error 3167 Record is deleted
And
Sometimes the main entry form displays a record in the form where all
fields are "#Delete"

I have a form in an Access 2003 application which opens maximized.
Its CloseButton property is set to false.  On this form I have a
command button that opens a report in preview mode.  The report opens
fine.  It opens maximized as one would expect.  However, the report

Re:  Access 2003
I am wanting to change the foreground/background of a label (to help
the user see where they are on the form as there are many fields).
This works:

I created a report in Acess2000 and now it repeats itself three times.
At first I thought its a problem with the page margins but that would
mean that empty or almost empty pages would follow the initial report!
In my case the whole report repeats itself completely.