I'm trying to close a form after a specified amount of time. I have a
countdown timer counting down from 30 seconds on the form, and a macro to
close the form but I just can't get the form to close when the timer reaches
0.

The code below, or equivalent, works in Access 2000, Access 2002 and Access
2003, but not in Access 97.
A Reference to the VBA for Extensibility library is included.
Is there a fix?

I have an Access db and there is a macros which automatically runs whenever
the Access db opens. I know that there is a short-cut key to stop running the
macro when the file opens but I've forgot the key. Can anyone help?
Thanks.

Hello....Does anyone know of a way to change text that has been typed in ALL
CAPS to Sentence case without having to retype everything?

Can anyone tell me what might be wrong with this? I keep getting an error
message and everything seems to be in order. Maybe I'm missing something!
Private Sub Report_Open(Cancel As Integer)
   DoCmd.OpenForm "Report Range", , , , , acDialog, "Attendance Summary"

I have 3 combo box fields in a "Case" form that represent a categorization
for a help desk case. Each combo box queries the "Categories" table to get
the content to list. I want to create the following behavior:
when the user selects a line from Category1, the combo box in ...

Can I create a macro in Access that will type in text.  I would use it like
the autotext feature in Word

I have MS Access 2000 and I am trying to fill in multi fields in a form (5
fields will always be the same) using a combo box where I selected these five
items, but I can not figure out how, when selecting the first column, it will
fill in the other five fields too.  I am not ...

I copied the Bisual Basic code of MSXML IXMLDOMNodeList from MSDN and
adopted it to my Microsoft Access 2003 for VBA execution.
I ran the attached MSXML code in my Access2003 Module and I got: Microsoft
Visual Basic Run-time error '13' - Type mismatched. This error lies in the

I have a situation where I want to select records in a given table and append
them to another table.  I then want to run two update queries that will
adjust the quantity field of the records in both the original and the
appended table.  I have written the action queries, and when ...

I'm trying to create a macro to automate a process of running a make table
query from tables I have linked with ODBC.  Access interprets the data type
as text.  They are intended to be used as date/time.
The following are the steps I tested so far:

How can I create a macro to create new records and autofill them based on the
last record I entered?

I have a problem with an access database. The data is imported from a csv
file (Comma Separated Value) conseuently the  database contains this sign " .
I want to remove all the " everytime I open the database automatically. how
can I do it? Any help?

When I specify the To and CC mail addresses in a SendObject macro they do not
appear in the email template when generated. I am using Lotus Notes...is this
a known issue?

Hi
I'm trying to set up a video database. i have a number of copies of each
video that i want to hire out. i want to keep track of them via a status
available checkbox. when i hire out the video copy in the hire form i want