I have a query that I would like to automatically Merge into an existing
Template document from a form. Can anyone help me get started with this?
Basically I have a large number of records (Job Number) and with each job a
number of parts are tabulated and attached to the job ...

I have following code behind the after update of a button.
Private Sub Text0_AfterUpdate()
   If IsNull(DLookup("[SAPnr]", "Order data", "[SAPnr] = '" & _
       Me.Text0 & "'")) Then

How do I show the subtotals from a subform on the main form?

I am an Access novice and any help is greatly appreciated.  
In the form I'm creating, I want certain fields to be entered into a table
when a Save button is clicked.  If the data has not been saved already, I
want it to create a new record in the table.  If the record already ...

have an Access database from which I create a CSV file. Now they want an
XLS spreadsheet also. Since I already have the CSV I want to use that to
create the spreadsheet but can't. I'm using Office 2003. My code is below.
       Dim oExcel As Object

I have a main form and a subform, I trying a code in subform as below and
found a run-time error#3464 on the line of "Set rst =
db.OpenRecordset(strSQL)"
I am appreciate for your help in advance!!!!!

I am using speech recognition.  When it is determining what you "said" it
places a "." as a placeholder and removes the "." when it is done.  I have a
field which is text and is for phone numbers.  I need to tell Access 2003 to
accept "." and 0-9but not accept the "-" which ...

Trying to create a simple cancel code in case user gets crazy hitting
buttons. The code below works great EXCEPT that when user hits button a
"second" time, vberror message pops up saying command undo isn't availble and
asking to debug. Is my code too complex or is there ...

After being about 95% complete on my application, I realized that Option
Explicit shouldl be set on all forms. I went back and did that. Thankfully I
don't have any varibales that this affected except one. The error mssg says
the "RetValue is undeclared on the first line of the ...

how can I lock date field with date(), though it auto. generates current
date, still user can change it
used below
Me!dateenter.Locked = Not IsNull(Me!dateenter)

I have Menus that I want to come up a certain times of the day.  The
problem is I can't seem to make the thing work when a Menu goes past
midnite into the next day.  Is there any solutins out there that can be
implemented.

I'm trying to run this code to set a form's recordsource.  I've tried this
code both in the open and load events.  intTot is actually a number field
whose format is byte.  Am I missing a quote somewhere or what's wrong?
Thanks for all help offered!

I hope I'm not posting too much. I have general question regarding lebans and
access' custom navigation buttons. Steve did a great job of creating the
code. However, I use a lot of them in my forms and trying to keep track of
the call routineswas getting kind of hairy but I got ...

SHi,
here is my situation, my "SalesRegister" table contains fields called
"SaleUnits" , "SalePricePerUnit" and "TotalPrice". I'm calculating
"TotalPrice" by multiplying "SaleUnits" with "SalePricePerUnit" IN A FORM. I

I would like an amount in a field on a Master form updated when a logical
field in a subform is checked by the user.  If the logical field which is
called Approved? is checked, then take the amount stored in ApprovedCap field
in the subform and add that amount to the TotalCap ...