How do I type the & symbol in a Label? Example: L&H. Access replaces my &
with an underscore.
Thanks
JoAnn

I've created a table that has two fields that together they make my primary
key.  I am trying to create a relationship between two tables (Enforcing
Referential Integrity).  When the enforce referential integrity button is
clicked i get a message that says "No Unique index found ...

  I'm trying to make staff scheduling through MS Access,I need to have a
form or query that shows me the date ( in the Column Heading) and the shifts
( in the Row Heading),same time, i need this form or query to be updateable.
Can you suggest ?

I have an Access 2003 application with over 100 VBA code modules.
Short of calling up each one in the VBA interface and ^A^C then ^V to
a text editor, is their a faster way to dump all the source code into
a text file on disk?

I have a data base and I want the primary key to be a combination of several
columns, ei 1.  date and time, 2.  scac code, 3. vessel code, 4. trip code
Is this possble?  If so, how is it done, if not - any suggestons?

The guy I replaced in my current position used text boxes throughout
instead of labels on his forms. This makes it difficult when making
amendments, as all the field names in Design View just say Unbound. I
have been replacing them with Labels as I go, but am I missing

Hey All,
I am using Stephen Lebans' RTF2 ActiveX control within Excel and
almost everything works quite magically. The only issue I am having is
when I go to print the Excel woorkbook the data from within the

I have a form that is to display a table in datasheet view. It works fine
when I click it directly i.e. it opens in datasheet view. Unfortunately when
I try to open it via the switchboard thru a button it opens the form in form
view. Could someone assist I think I might need to ...

I'm urgently looking for a solution:
I've got some long word-texts and I have to edit out all the typists mistakes.
The most common mistake is words followed by a space and a colon.
(e.g. "example :" instead of "example:") (notice the space between the word

I want to change the format control properties "DataFormatAs" to a currency
in Data Access Page (access 2000). Its asking for a code but I dont how?. Its
easier in newer versions

I seem to remember in the dim and distant past a way to enlarge/maximise/zoom
the expression builder. Something to do with the ALT key.
I've looked around but can't find anything on this.
Does it still exist?! (Access 03)

In Access 2003, I'm trying to use a date field as a control to a memo field.  
To be clearer... I have six dates 10/2/2007...thru 12/27/2007 two dates per
month.  I have the report grouped by month.  I have a header for each group
with the title "This is for the month of" and I ...

I'm running Office 2003 in Win XP SP2.
Recently all my Access files automatic creates a backup copy of itself each
time I open and close them. The files comes in filename_backup form. After I
delete the backup copy, it'll come back again.

When I do a filter in a table, I get 371 records but when I run a query
based on the same set of criteria I get 63 records. Does any one knows what
is going on here? This is a real problem and I can't figure out how to fix
it. Any help will be greatly appreciated.

I have a report based on a query. Now, I 've just discovered that I
forgot to sum the total units received
and to put that sum on my report footer.
To do that, I 've create a new query. Now I will like to have a text