Hi, just today I've run into a problem, when I press Alt+F11 to open the VBA
editor, I get an error message that Access has encountered a problem, do I
want to tell Microsoft. Seems I had this problem a few times over the past
week, but today I can't get editor to open at all ...

What does the Me! do?
Found this on http://support.microsoft.com/?kbid=296249
The code works great.
Just curious about the Me! part.

First, let me preface by saying that I do know Access 97 is severly outdated.
My client is just now switching their main accounting application from a DOS
based to Windows based, and Access too will be upgraded.  The machines in
question all have Windows XP Pro, Access 97.  I ...

newbie question - Access VBA help says that DoMenuItem was replaced by the
RunCommand method.
a)  I'm having syntax trouble changing the following two line to the newer
method:

I have a script that assigns a biological season to each record in a Caribou
database based on the date of it's sattelite transmission.  It works just
fine on my computer but for some reason when my co-worker run's it from her
computer some of the records consistently get ...

I am trying to link to an ODBC source. But some fields in the table have the
$ in their name so I get an error.  Is there anyway around this.  I just want
to create a pass-through query using some of the fields which 2 of the fields
contain the $.

I have a dialog box that requests the date range for a report and it works
fine for that report.  I'm simply using a macro to open that particular
report when the OK command button is clicked.  Is there a way--using macros
or VBA--to make this one dialog box work for multiple ...

I am trying to create  2 report:  A and B.  
Report(A)  contains the name and description for each of the tables in my
db, and then Report(B) that lists each each field name and description in
each table.

Sorry for those who have already answered.
I have searched as best I could for the following but I can't seem to find it.
1. I need to create a form that alerts a predetermined user and their
supervisor when an order is either - due in the future, due in a week, due

Hi there - I hope someone can help - I don't use loops much, so I'm
stumped on something which is probably very basic and straightforward.
I've got a set of data covering a 3-month period, provided by BT on
calls made to a helpline number. The fields call all the usual stuff -

the following module produces these results:
(xlb114r returns as xlb1114)
(xs245aaw returns as xs245w) the "W" in this case is important.
but I also need (xan72aa-7.5) to return as (xan72-7.5)

hey all,
I have written a small db that downloads zip files from a site and then
automatically creates a directory and unzips a file into that directory,
except the last bit doesn't seem to be working. It does it all but the

In Office 2003 and Windows XP,
I am trying to set a text box on a main form to the total of column
HEAD_COUNT in table MyGlobalTableVariable WHERE DEPT1 = MyLocalDeptVariable.
What I have so far is shown below:

Using Office 2003 and Windows XP; using VBA, how can I:
1) Programmatically set a combo box to a particular entry in the drop down
list?
2) Clear the combo box drop down list of all entries?

how can i read visio shape propertys with access vbacode??