I have a form with 3 subforms. How do I change recordsource on subform3
after update of combobox on subform2
Mainmenu
SubForm1

I am trying to get around a serious error that occurs in my application if I
bring up a report to print and then click the "Cancel" button on the Print
Dialog form.  Doing so results in an error that closes the database.  I know
there's an error code to trap for but I can't for ...

I have a report that complies weekly statistics - painfully populated by VB
from the Activate event
This report works fine when run - but when emailed from a form via:
DoCmd.SendObject acSendReport, stDocName, acFormatRTF

I have a program where the focus moves from one form to another and then the
focus is returned to the original form.  When this action takes place, the
form’s caption bar that receives the focus turns is highlighted or turns
bright blue.  What I would like to do is either freeze the ...

I have a form that I want to lock when the form opens, so in the open event I
set the items to
  me.textfield.locked = True
  me.combo.locked = True

Access 2003; Windows XP Pro
Using a combo box in the form header, and it's After_Update event I am clear
on how to display and refresh or requery a subform based on criteria changes
in the subforms underlying query.

I used to use
Combobox.ListIndex = Combobox.ListIndex + 1
to move to the next item in my combo box. It doesn't work in Access 2002 any
more. My combo box is based off of a select Query and the data from the combo

I would like to save a record in my subform by using the
"afterupdate" procedure. basically, I have 5 fields in my
subform. after the 3rd field, I would like my subform to save
the record, instead of only saving by setting focus to a

I have a DCount that isn't working, I think its the criteria part. Its
says missing Operator.
Me.Text18 = DCount("EmployeeID", "Employees", EmployeeID & " = Me.TextD")
I tried This Also..

This statement is suppose to find an "Employee" in the "Time" table and
if the "IN" box is checked yes open the "Tables" form, else it opens the
"PayPad" form .  I keep getting an Error on the FROM part.
Private Sub Command26_Click()

i need to email weekly report of statistic from my database
i could find last week (>Now - 7), but i'm inclined to store the last time i
sent stats incase they are not sent exactly on time and find occurances
since [last stats] upto now

I have a continuous form called CompanyJournal that has a dtDate field. In
the dtDate field I have an On Double Click event set to open up a form
(frmDatePicker)that contains the datapicker control. After the user selects
a date I need to update the dtDate field in the record ...

How to do this seems to escape me:
I have a form that the user chooses from an unbound combo box of Time Frame
and all are based on calculations except one: "Enter Specific Dates" and I
want the user to input a "Start Date" and an "End Date" and that info goes

How can I send a word document as an E-mail?
I have a word document as a template that i want do send automatically to an
e-mail passed to the routine.
I don't want to attached the document word. I want that the body of the

I want to use the calendar tool on a form. I want to place names in each
area so we can tell who is on vacation each day. Is this posible ? if not  
any sugestion?
PrimePixie