I get something like this a percentage of the time when
I open an A97 report by dbl-clicking it in the database
window. I can not remember seeing tnis when the
report is opened in code,  I can not remember it

I need to be able to open an Access97 db with Access 2000.  But I need
to assign a workgroup to the db when it opens.  I'm using Windows XP
Home edition.
I already have a shortcut on my desktop but don't know how to set it up

In Access 97 I used @ to make message boxes to separate the lines,
rather than have the message all in one line.
In Access 2000, all that happens is that "@" appears all over my
message boxes.

Form:  Main Menu
From the Main Menu you open up the main form, ?Program_services?
(unbound) which serves various purposes aside from the fact that it has
a single unbound, first, subform, ?frmMain? with two option buttons.

Dear reader,
What is the VBA code to show the system name of a pc.
Or is it possible to show the system name immediately in a query.
Thanks for any help.

I am trying to open a search results form based on the input from a
prompt form. I am using the following code:
--- Begin Code ---
Private Sub btnSearch_Click()

I have a form that uses an Image object to open a report (the report is
based on a query).  I used the image object because the MS command buttons
are dull looking.  All of this works well.  The problem occurs if I choose
to cancel when the "enter parameter box" appears.  The query ...

I am building an Access 2002 frontend with linked tables to an
encrypted Paradox 7 database. When I first create these linked tables,
I'm asked for the password to the encrypted Paradox database, and the
linked tables are successfully created. I use the data from these

To simplify the user interface and to protect code I have unchecked the
Tools|Options|View|Show Hidden objects.
However, if a user selects displaying the hidden objects, I would like to
reset this option by code at next database launch to not display the hidden

 I have a form that displays and allows user to edit colorsets, each
 colorset containing between 3and 11 colors.
 Each individual color is a combination of numerical values of
 Red,Blue, and Green.

The file is now available as
http://www.ffdba.com/downloads/testingNZ3.dat
(rename .dat to .mdb)
or

I have a problem with building a totals query showing data
for the last date only.Under the last date i understand the last date
of  field invoicedate.This invoice date is in the table orders.
Therefore in the column of the query i have entered :

Greetings all...
I need to be able to input dates into a table in the following format:
Saturday/29/October/2005
Could someone please tell me the input mask for this?

Here is my situation:I have several Access database projects that all
keep their back-end data in a directory on a server. I would like to
have a small Access application that could open each .mdb file, then
compact and repair it, with no user intervention other than launching

I am trying to create an instance of Outlook.Application so that I may
build an email within a routine in the VBA behind my database.  
I am running MS/Access 2003 (2000 format).  The statement that is
failing is: