I would like to make a button on my form when clicked would do the following
in order
1. Select some fields in the record to be specified of course
2  put it contents and save it temporarily in a variables

I have a query named "query1". I would like to create a combobox that will
list all the fields (columns) in "query1". Any ideas as to how to write a
query that will display all those fields (columns)??

I have a main form that has a button to bring up a pop up form. I want a
warning to be triggered based on a particular field's value on the main form
that would alert the user to fill in the pop up form.  But, once the pop up
form has been filled in, I don't want it to trigger the ...

I have created a multi select list box that stores the selections in a table,
I used the following code from John Vinson (thank you very much!):
Private Sub cmdProcess_Click()
   ' Comments  : Update the AnimalCondition table based on the

I have a list box where the row source is an SQL "select" statment of two
columns from a table - the first column being an ID and the second column
being the ID description that the user is selecting. The user can select
multiple items in the listbox. I can access the ID portion ...

In this code below the "rs.Edit" gives me the error: "Method or Data Error
not found"  I don't understand, I've used it before?????
If txtNewPwd = txtNewPwd1 Then
       If rs.RecordCount > 0 Then

I have created a query containing a left statement but get this error.  Can
anyone help?
SELECT DISTINCTROW Left([File_Name],Len([File_Name])-4) AS [File Name],
tbl_SAR_Header.Team

I have a form that has two list fields (namelst and sourcelst) and one button
group (statusfra) for users to choose from in order to customize a report
(trkng_rpt).  I want the user to be able to choose any number of names and or
any number of sources and whether the request is ...

I am a beginner with Access, so please forgive my ignorance.  What I am
hoping to do is insert three checkboxes on a form.  Each checkbox would
be for a group of fields  When I check one of the boxes, I would like
it to populate a set of other fields on the form.  What this is for ...

I have a 'picture' of a foot and want to put a command button in each toe
which when clicked will load two data fields in a subform and shift focus to
the other fields. ie Right foot Big Toe  button will preload "Right" into
LRFoot  field and "Big Toe" into Site field   Then move ...

I have a "MAIN" form where i set filters. I choose a condition in a combo,
then press button to show results in other form.
On that other form i have a button to open report which is supposed to show
the same data filtered according to condition set on MAIN form.

Is there anyway I can send multiple records to Outlook as reminders. For
example any records over a certain date?
I have seen & used several of the Outlook Reminder forms but they all seem
to only send the current record.

I've got a system where i get a job, I input the details, and set the status
of the job to "Awaiting Invoicing" when i'm done. I need to invoice my
customers each month with a proper invoice number etc.
When I get a new job, the description of the job is entered into a table

Background:
I have a form that is used by myself and my two partners who are a bit less
computer savvy.  The form has two subforms.  One is a continuous form that
lists all the data for the main form.  The second subform is the same as the

I have a bunch of form fields named TxtSpec01 through TxtSpec39.  Can I
access these fields (both values and properties such as Enabled) by
string?  In other words I want to make a loop from 1 to 39 and create
the field name in a string and access the field via that string.