Hi. I have a form that uses the common dialog control, and it worked fine on
my old computer, but not with the new one. How can I get the form to see the
control?

The subform in my main form has a record source which is a table that only
has numbers in it (references to other tables).
MsgBox
Forms![frmTravelRequest]![frmHotels]![frmHotelLocationsSubform1]![LocationID]

I took this code straight out of Northwind and modified it for my subform.  
Can anyone see any glaring errors?
Private Sub ActionID_AfterUpdate()
On Error GoTo Err_ActionID_AfterUpdate

Hi TWIMC
The error message that I get initiates on the code line
rge.CopyFromRecordset rst. The error message returned is 'Run-time error 430:
Class does not support Automation or does not support expected interface.'

Hi TWIMC
The error message that I get initiates on the code line
rge.CopyFromRecordset rst. The error message returned is 'Run-time error 430:
Class does not support Automation or does not support expected interface.'

I can't seem to get this to work.
Its on a command button.
StartTime and EndTime are fields in MenuDetails Table as is StartDay
Basically I need TxtTotal to give me the total time between StartTime

bit of a newbie with access, working on my project for college at the
moment, and need some help with one of my forms.
I have one main form (called Course)
it has a subform inside.(CentreSmall)

I have posted code below that I am using on my checkbox(Collect) and
associated button(cmdCollect) that are both in frmProducts, a subform of
frmFollow.
At the moment, I am able to create record in frmProducts, exit frmFollow, re

Hi, when I automate a procedure to send data from Access to Word (bookmarks)
then I find that the procedure runs smoothly but at the end the focus ends up
on the Database Window rather than the new doc.  The focus does not even land
on the Access form.  The procedure does include ...

I have this form that is based on a query that is a combination of a make
table query and 2 tables, what I'm trying to do is from a command button on
the form is to: Close the form, run the make tabley query and then open the
form, what happens is that when it tries to run the ...

I have a field with a function Date(), which updates everyday for the same
record
how can I have a Date() which will ofcourse does populate the current date
in the date field but in addition to this, it should not change or update ,

How can I use the Round() funciton in queue but not round up the decimal place.
E.g. I would like to round up 3.456 to 3.45 instead of 3.46.
Thanks for help.
Jerald

I'm using Access 2003.  I'd like to create custom menus for my apps.  
Normally, I'd use combo-boxes, command buttons, etc. to accomplish things
like filtering data, launching reports, etc.  I'm thinking that custom menus
could alleviate a lot of the form "clutter".

I have a subform that is based directly on a table called tbl_WizardReqEnv.  
It is a stagnant set of 5 records that only serve as a switch.
All I want to do is determine that at least one or more of these records
"req" field which is a yes/no field - is checked or not.

Hi Hello,
I am a new user for MS ACCESS,
I have a form named "order lookup" with criteria of
[forms]![order]![customer ID]