We have a system where numerous Access databases send out excel files to
clients automatically using the DoCmd.SendObject command.  (We also have
databases which use the Outlook API and CDO but the failure here occurred on
one using the SendObject command).  We had an email go ...

As a means of making things easier for those responsible for maintaining
systems, when an error is caught, I would like to display an error message to
the user stating:
1. Form/Report which throws the error;

Can access be programed to work with a barcode scanner; in other words, scan
an items barcode and have Access input the information onto a form?

Is there a standard function that converts an octal number
to the corresponding decimal number?
Like the "inverse Oct()"

This one is a bit bizzar.  I have a simple, one table
form in continous list view.  After I leave a field it
locks and nothing else can be entered.
I cannot find where this locking is taking place.  I've

I am using Access 97 and hence do not have the option of selecting 'Compact
on close.' Is there a way to compact my database everytime it is closed by
running a macro or something?
This database will be shared on a server. Does this complicate issues?

I already know the way to create custom menu bar in Access by point to:
Tool-->Customize--> and then drag custom menu into outside.
But I wonder if there is a way to put (simple) VBA code into custom menu bar?
I mean, for example, I already have a blank custom menu bar, and then I ...

Can anyone recommend something that I can use to clean the screen on my
laptop?

How do I write a WHERE statement to pull records for "Today" only. Is there
one, or do I have to do it with VBA?

Hope anybody can help me.
Created 2 tabels via append query's and export limited the content to two
text files.
Both txt files have differtent content and export specs.

Can someone tell me what i need to add under
tools/referencesin Vb to activate "Openrecordset" please
pat

I have an Access 97 (yes, still) application which was developed on a Windows
NT machine. I've upgraded my development PC to Windows XP and now I'm getting
errors wherever the Format(), Left(), etc. functions appear in reports.
I'm sure I've had something very similar before ...

Good morning.
I am using an Access VBA module to control Excel and I need to figure out
code that can simply change current directory to a set directory and then
show Excel's "Open" Diaglogue box. I am aware that I can use an open command

I have XP Professional and my database is 2000 format.  Anytime I have in my
code the DoCmd.   cmd. or Me.  and I debug I get hung up there.  
I have Microsoft ActiveX Data Objects 2.1 Library referenced and my dim
statements are:

I have Access 2003 and Access 97 installed on my PC.
I wish to upgrade the Access 97 databases to 2003.  For example sake, lets
say I have 1500 databases that need converting.
The acFileFormat  offers several options of formats: