First time poster here but I'm looking forward to learning a lot.
I'm using Access database 2003.  I have the following databases that I'd
like to create a 1-to-many relationship:  Customers, Master Schedule and
Shipments.

I have a table which two different groups will enter data.  For example, the
first group will enter demographic data, diagnosis, admit date on a form to
populate the table.  The next group will enter discharge dates and charges,
etc on a different form.  I want the second group ...

Is it possible to export a report instead of a query into excel?
Thanks,
Jasper

I have an access 2003 report that has a text box called text2. I would
like to make it when the report is opened text2 is copied to the
clipboard. What is the best way to do this? I have tried writing an
event for on open (VBA code). The reason I'm doing this is because I

I put the following validation rule on a field:
Is Null OR Not Like "*[!((a-z) or (0-9))*"
The rule is suppose to only allow letters and numbers, however it will not
allow anything!  Any suggestions on what I am doing wrong. (I have access

I have a main form for inputting data and there is a checkbox for Complete
that when clicked will display the current date and this works fine. Here is
the code I put in the click event of the checkbox:
Private Sub Completed_Click()

I'm working in Office 2007.  When I go into the envelope tab there is no tab
which indicates I can insert an address from an address book or anything.  Is
there some other way to insert addresses into my envelope function so that I
do not have to keep retyping addresses???

I am trying to have a report only report on records that are within the last
7 days from the current date and that does not have a date from a [Date Sent]
field.
Example: If the current date is 08/21/08 I would like the report to get all

I have a form (subform actually) based on a table, with the following controls:
Net Value - entered directly here by the user
Tax Type - this is a combo based on a TaxTypes table holding Types and Rates
and when the type is selected there's an After Update event (using If

trying to open dvd in drive d. disc not being recognized and says it may not
be formatted. how can i open the disc?

Inside an existing database converted from 2003 to 2007, old functionality in
the bottom navigation bar of the form view there was the ability to type in
information to search, it would default to a particular field-now it defaults
to any information matching what you've typed in ...

It appears the settings to Tools > Office Links > Publish it to Word or Excel
is not working anymore. I get the following error "Microsoft Office Access
can't complete the Output operation" How can I get this fixed? Where can I do
to resolve this error?

I would like to programatically read the lines of code in an Access ADP/MDB
for comparison and manipulation.  Does anyone know where I can find
information on doing this and the format of the lines?

I posted this before and never got an answer. Here is more information.
I am using Access 2000. I have a table behind a form. Three of the fields
are memo fields. They are Services, Terms, and Vocational. I use the Got
Focus feature to have the cursor go to the first posiiton in ...

I am running MS access 2002.  I am a semi-beginner I know enough to get what
I needed done done.  However I am wanting to improve the performance of what
I have.
Basically it is this.  I put together a database that contains all of the