In access 2003, I have a form that multiple users access.  I need to make a
certain field read only after the user has entered a unique number.  Can
someone help me figure out how to do this?
Thanks in advance.

I have to imagine it's possible to use a macro to create a new record in a
given table, and send it data. Is it possible to do this?

I have created a macro in my Access application that uses the
RunCommand action with the SendToExcel command.  When I run my report
in print preview mode this option (Send To Excel...) is grayed out or
disabled.  I am using the runtime version of 2003 and my version of

XP, Office 2007
I've got a table I need to export to Excel and the only solution I saw was
TransferSpreadsheet.  Below is what I came up with(with help from the
Scripting Guys archives):

I have two forms open.  I want to set the value from a field on one form to a
field on the other, but I'm having trouble.
When I update the field I want the value to come from, then run the macro,
the value that populates the other form is the old information, not what I

I'm using the method described by Ken Snell (link below) to import files in
to Access. I've been successful with getting file directory to open, but when
I select a specific file to import, the file that gets imported is the first
file in the directory. How do I edit the code below ...

After a recent automated MS update, I now get an error message in a MS Access
DB when I try to run a filter command:
"The object doesn't contain the Automation object 'RecordsetCLone'."  
The filter runs properly after I click OK, but I need to get rid of the

My knowledge on Access is pretty much self taught.  I have done several basic
ones.  I want to know if there a list anywhere that contains macros/codes
that can be used in Access along with a basic explaination of what the macro
can do for you.  I would like to print this info ...

Is anybody had the same problem I have right now?
I'm trying to open my reports in MS Access 2003 (I created one year
ago and they were working every day fine) and I can't.
It doesn't open reports; it doesn't show any error messages.

I don't know VBA code, so I'm trying to get a Macro to open one of four
specific client reports depending on the billing code in an Invoices Table.
It is a temporary table witih only one record.
So I have four lines in the macro - one four each potential report. The

When a user creates a macro that generates an email sending a report, the
email often returns frequent out of office replies. These come from various
employees at various times. I was wondering, if there is a way to generate an
email from a macro and not let any replies come back to ...

I use a macro to export my queries to MS Excel using the TransferSpreadsheet
funtion. I export one query per file. This happens every night. I would like
to report on the Excel file the time/date when it was updated. If I try to
use the Time and Date functions it will give me ...

I have used a condition to make a label red if the value is null
Condition: "IsNull([RegistrationDate])"
Action: "SetProperty"
Arguments: "Label233, ForeColor, 255"

I have an embedded macro on my combobox which looks up a selected name on my
form.
Is there any way I can use the if statement in the macro after it has found
a record?

I have been trying to work on this for a while... and I hope I can get some
help.
basically, what I am working on is a type of checker.
Here is what I have come up with...