i have a bound subform (say MySubForm) in an unbound form (say MyForm).
MySubForm's Record Source is set to a query (MyQuery) which selects certain
records from a linked table (MyLinkdTable). In the MyForm, i have a command
button (cmdProcess) which essentially copies and processes ...

Hey people
I want to export specific information from an exsisting table i have into a
spreadsheet and then delete it from the table i have in my database.
Basically create an archive record. However every way i have tried resulted

I could really use some help.  I'm trying to do something seemingly
simple but to no avail.
I have a label set to invisible
When a text box on the same form (currency) goes below zero I want the

amongst other controls, my table underlying this form has a PK comprising
"Patient Number" and "Lesion Number" as they are also called on the
continuous form which is what i'm focusing on.
when a new record's to be added to the form, i use a default expression of

I saw a post on this dated 10/25/04 with replies by MARSH but I don't think
it was resolved. I'm having a similar problem but I didn't want to hijack
the thread.
Access 2000 - When a user changes the value of an option group by selecting

I am using Access 2002.
I was wondering if it is possible to add multiple selected items from a list
box in a form into a table, with a seperate row for each item?

I have a combo box on a subform that I would like to have updated with info
depending on what appears in the text box next to it.  And I am having
difficulty in getting anything to work.  The textbox is filled from a combo
box on the main form.  Any suggestions in getting this to ...

On a form's button click event, I'd like to build an SQL string, marry it
with a report and then fire off the report.  I've been trying various
approaches but not having much luck.  Can someone provide me with a basic
coding example or point me to a resource that does the same?

I want to use SendObject Action to send an e-mail
with attachments. There's a mention of Outlook Express
being MAPI compliant in XP HELP, which is contrary to my
previous understanding. Does anyone know if it is? If not,

I have a text box wherein I want to bind to
a public variable. E.g.,
Public strVarName As String
How do I specify that in the text box property

I will have 25 records in a Subform.
I am using code to save to Unbound Tables via DAO.  No problem.
BUT, I would like to examine 3 fields in each record to see if any
are Null as I save.  I would then tell the User & give him / her the

I have an Access 2000 database and on 1 form a listbox that links to a
Countries table.
What I need to do...IN THE SIMPLEST WAY...is to allow multiple countries to
be selected...and when the data entry person comes back to that record...to

All:
Placed a button on an Access 2000 form (Win98 OS--I know, dinosaur...) that
when clicked generates a "file
not found vba6.dll" error message; looked in C:\Program

My application has an access front-end and a SQL Server
back-end.
I am trying to use an Insert Statement as following:
sql = "INSERT INTO OrderNote"

I have some code that must go through many calculations on many rows.  At
the beginning of the code, I've placed:
   DoCmd.Hourglass True
At the end of the code: