Should I change 556 to 560???..............Thanks for your help..........Bob
Private Sub Command560_Click()
On Error GoTo Err_Command556_Click
   Dim stDocName As String

I have a switchboard form designed; I have the switch to select etween two
dates and print the appropriate report; no sweat. However, I need to set a
second criterion that will select the proper employee and sort only his or
her production data for the date range that has been ...

I fired up my db in access 2007. it has an expression
=[Title] & "  & " &[title01]
when running the db in access 2003, the expression fails with $#Name or something like that.
If I enter title01 it works fine, if I use Title it works fine.

When I send the database the following value 15/06/06 it assumes it is
15/June/2006 and that is OK but when I send 01/07/06 referring to 01/July/06
it assumes it is 07/Jan/06 (I am based in the UK)
What can be done to solve this problem?

I'm trying to decide whether Access is the best tool for the job here, and
have some questions.
How would a group collaborate on an Access database? A coworker and I would
be working on this together, with both of us adding and updating information,

I would like to retrieve the file path\name of the access file from within
the access VBA code
Thank you,
Samuel

I tried to make change in one of my access forms
but the program wont let me because I dont have
exclusive access.
How to get exclusive access?

I would like to create a web page that would accept input from remote club
members and create a table or file in my database.
Is this possible?

I have made a beautiful report in Access and I need to email it out, but when
I try to attach the file, it goes to a database screen.  I am unable to copy
the report and paste it into Word and I cannot save it as a Word document.  I
tried exporting, but couldn't figure that out.

how can i make a Candidate Key

Our mdb is fine on the server in the office but when I do development work on
my notebook it can be frustratingly slow to save after (for example) adding a
control, or changing a property. It's probably only 15-20 secs but seems like
an age while you're waiting to see if it has ...

If I search for e in MySQL it will return e, E, É, è, and é etc. If I
search for e in an Access, it will return e or E.
I've tried using an Access query and I've tried through VBA/ADO.
Is there something I can do in Access so that it will see all accented

Hi,  I am working with MS Access 2003 and I have a parameter query
that request beginning and ending dates.  I would like to place those
date entered by the user on a report.  Would someone please tell me
how I can do this.  The dialog boxes that request the date information

I am trying to parse a single field to clean up an old database of addresses
for a friend.
How can I remove the word "and" as in John and Jane Doe while preserving the
fields that have "John's Automation Service"??

Hi, after a user logs in through user security I'd like to send them to a
specific Switchboard Manager page which will act as their main menu. The
Switchboard page they view will be based on the security group they're a
member of. How do I send them to a specific Switchboard ...