I'm making a Micorosoft Access 2000 DB.
What I want to do is to declare several constants (in VBA6) that I can
reuse in other code such as me.caption, instead of trying to use a table
 to store just that information.

I want to start the Backup option from >File >Backup via VBA
I tried
DoCmd.RunCommand acCmdBackup
I get a message  like "Not available"

I will try to explain the best I can. Any help or suggestions are greatly
appreciated.
I have a main iventory table, a Purchase Table, and an invoice table.
My main iventory table draws from the order two as follows:

Hiya,
I am trying to create a Contact Database in Access.  This database includes
an e-mail field.
What I would like to be able to do is to run a query on specific customers

Is it possible to have Access generate an email or prompt Outlook to generate
an email?  I want to have an Access field that monitors due dates and then
send out an email 10 days prior to the due date.  I am new to Access and I
don't even know if this is possible.  If there is a ...

I created a report, an invoice.  It reports the clients up to client 6.  The
clients after cleint 6 will not show up on the invoices I created.  They do
get reported on the invoices that I did not create.  The data in the table is
correctly entered.  I did not create a form ...

I have a simple form that I use to insert data into a table.  On my form, I
have 3 text boxes that have an employee number, first and last names
manually input.  I have another table that includes all this information.
What i would like to do is: input the employee number and ...

We have an unbound form & would like to load the text box on the form with
data, then wait for the operator to make changes on the form. After that we
would like to get the data from the text box & proceed with the vb code.
Here is a skeleton of the vb code.

I have everything in place from the access database side, i can select a
record, create a query in VB "ContractSelect" that contains one record that
i want Word 2003 to display as its datasource when it prints, but what
happens is that when ever i open/launch word from WITHIN Access ...

Hi I'm trying to determine the application path.  I've done this
before in VB6 using app.path, however app doesn't seem to be a valid
object in VBA.  I'm looking at the application object but that doesn't
seem to have a path property.  

I have a report that groups on a_id. a_id may have 3 records underneath it
but I want to do a count at the end of the report that only counts a_id one
time.
A quick eample of what it does now:

I've noticed that sometimes when I move my database between PC's some of my
reports change orientation from Portrait to Landscape (I am using Access
2000).
Is there anyway I can stop this happening?

I have created a small database in Access 2003 that is linked to a form in
InfoPath to track vacation days.  Currently, I cannot find a function that
will update the field for total days already taken when new information is
submitted from the InfoPath form.  I am very ...

I have a simple database of 3 tables with one main form to enter data into. I
set up an Autoexec macro to open the main form when the database is opened
but I recently changed the name of the form from Main Form V3 to MainForm (I
had tried a couple of other versions to see how ...

Recently got a new CPU, upgraded from Office 2000 to Office 2003.
Problem is my reports will not open that were created prior. I have have all
admin privilages. I also can not get into the design view to correct any
problems.