frmMessage shows a) a message record and b) a continuous subform
frmMessagesSubform that shows all messages in a scrolled list.
frmMessagesSubform has a click event SelectMessage_Click().  What is the VBA
code that will set the frmMessage record to the record selected in

I have code in the AfterUpdate event of a Date/Time field (named
"ClockedIn") that increments my Job Number field(named "ReqNo"), starting
with the number 1 at the start of each day.  (The code is below, following
this message.)

I have a main database that links to a backend database for about 12 tables.
The location of the backend changes periodically, so I have added a command
button with code so that the user can choose the path to the new location,
click the button and the code re-links to each of the ...

I'm trying to do the following.  The form this code comes from is not bound
to any table and when I try to execute the code I get "Run Time Error 3075  
Syntax Error in string in query expression '100000")'.
100000 is the number I have typed into the txtPrincipal text box.  I

What I working on is a payment posting form. The underlying tables are as
below.
Ledger
   Transaction    (auto number)

I use Access 2002 and Excel 2002.
I have an excel workbook with many tabs.  I need to import from one of the
tabs.  The data I need to import is located in rows 33 though the end of that
tab, wherever that might be.  Rows 1 through 32 above USED to have values in

I have a combo box that has three values in it
SELECT
AP
CS

I'm currently using an unbound form with text boxes and a button to open a
report in Access2000 (very new at this, by the way):
DoCmd.OpenReport "rptMeet", acPreview, "", ("[MeetDate]=
Forms![frmPrintDialog]![txtMeetDate]")

I have a listbox named programlstbx which the user selects a couple programs
to make labels for mailing purposes. I have it coded as follows
Private Sub LabelsLink_Click()
On Error GoTo Err_Handler

I have downloaded the files, samples, etc.  It is obviously useful, as
demonstrated by the samples, but I do not have the slightest idea how to
implement it.  I can get a control on the page in design view, and the tool
bar is visible, but how do I enter text into it?  Do I bind ...

I have a text box on a form which is trying to display the value from one of
three subforms depending on which subform is visible.  I've written a nested
IIF statement, but for some reason only the first part works.  It doesn't
give me any errors, and I can change which subform I ...

When I export a report from Access to Excel I get the fields and data but the
heading and formats and report style is lost.
Is there a way to export a report to excel where the report in excel looks
like the report in access.

I have a form Teachers and a subform SubTeachers. I need to display data in
the sub form according to my selection in the combobox on the TEachers Form.
I have coded the following on the combo_change event
but it doesn't refresh the data in the sub form. What am I doing wrong?

I have a problem concerning filtering fields in subform by selecting the
criteria from another field in the subform.
The subform is based on a query build on these tables:
Products:          Containing the name of product and price pr unit

i have a button called next, which goes to the next form of the suvey
when clicked i want it to trigger this event:
(what code do i put int the next button(which currently has no code) click
event to trigger it)