I am very new to programming, and am trying to figure out a way to do two
things.  First: I have required all of the fields in a table to be filled in
- they cannot be null.  In my form, when a user tries to skip entering a
field, I want the error message to say something like ...

I have 2 different fields in my database and i need to be able to have the db
check these two fields to make sure that the same serial number doesnt come
in both fields
eg, model A 1234

This is a bit weird.
I am exporting a report to Excel using the following code:
   DoCmd.OutputTo acOutputReport, strReportName, _
       acFormatXLS, strWorkbookName, True

Age-old problem here. I have a button on a form that needs to accomplish 3
things:
1. Open a report (acPreview)
2. Allow the user to print the report if desired

I have code in several places that creates directories and I’ve noticed
several times that after I’m done testing and try to delete the directories,
I get the following error message:
"Cannot delete xxx: It is being used by another person or program.

The error is occuring in a function, but the function is programmed properly.
The value sent to the function is wrong. So I want to know who is sending the
wrong value. Is there a way to identify from where the function is being
called. I could put breakpoints on all the events, ...

I have a table with fields: RecNum (AutoNum), PartNum (text), Quan, Length_M.
A example record has entries: 2,102,27,5486, respectively in these four
fields.
I would like to programaticaly change this one record to 27 records having

I am working with a project form in MSAccess and was wondering if
there is a way to limit access to one user at a time?  I have already
set the access to 'exclusive' in Options>Advanced, but multiple users
can still access it at the same time.  Would the use of

Good Morning everyone,
I was wondering, is there a method in Access 2003 that makes the controls on
form change its size when the form window is resized.(Minimzed, maximized,
manually resized...)

I've read with interest the questions and responses regarding incrementing a
text field.  However, as I know next to nothing about VBA, I'm hoping to get
a specific answer to my question:  Can I put as a default in a table text
field "P-3000" and have that increment by 1 when a ...

I have the following code that creates an Excel worksheet based on data from
a Access table.  The first time I run this it runs fine.  The next time I run
it (during the same Access session) it gives me a 91 run-time error on the
line indicated below.  Then the next time I run it ...

I have a query that is pulling in "AgentCd"=Agent, "Sales" = Sales  and
"Downpay" = Sales with Downpayment.  Each Agent has numberous sales that I'm
counting.  I have a summary report that shows each agent code, their total
sales, then their sales with downpayment.  I'm then ...

I am trying to build a database that will import a .txt file from a main
frame.  A sample of the file is below which shows records for 3 unique IDs
(the numbers starting with N).  
The problem I have is that the second row does not have the unique ID for

I have a form designed for data entry. It has to be a continuous form for
many reasons.
My user wants to be able to fill up the data of all the first field, then
the second, etc...