How do i set a preselected time of 3am in to a text feild?
I have tried txtStartTime.text=DateAdd("h",3) but this increments the
current time by three hours, so im thinking i may be using the wrong comand.
How do i make time equal 03:00:00?

When a dialog form is opened, execution of the calling code is interrupted
until the dialog form is made invisible. What do I do if I want to open a
dialog form, but set certain controls to have default values, which are
specific to the code which is calling the form?

I have a data entry form. I want to assign a date to the Day field in a table
when user goes to the next row thru hidden txtDate text box.
But, I'm getting the error: Run-Time error -21437352567 (80020009) You can't
assign a value to this object

I have a combo box to display a list of name. I need to deal with the case
that when a user enter a new value of name then it would pop up a message
asking for add new value. If the user say, "yes" then that value is entered
into the list and also into the table.

I have a form that will be used for data entry.
This is split in two sections:
The top half identifies the client through a number of cascading combo
boxes. This client then is shown in a subform, to see if the data in the

I have a combo box "cmbFilterMgr" on my form that I want to filter by when I
select a name from the list.  I have a combo box field on my form which is a
User Name field and is called "LoggedByID".  In my filtering combo box I want
to select a User name and have my form be ...

I am trying to create a form where you can selet from an option group and
then narrow down your selection with a combo box to gererate a report.  I
have copied a string of text from another form.  But I can't seam to get it
to work.  Can some let me know what the varsortby value ...

I have a stored procedure in SQL Server that looks for a bunch of parameters.
It inserts a record into a table, but in doing so, it does lookups in
secondary tables to translate the input parameters into IDs from the
secondary tables.

I need a function that will calculate what next Tuesday will be for any given
date.
I have an invoice that always arrives on Tuesdays, and I need to calculate
which Tuesday an item will be included in...

I have a table using auto number. Increment by 1 starting at 1. In my form
for that table, is there a way for it to display the highest number upon
open rather than the lowest (1)?
thanks.

I'm sure this has been answered somewhere but I can't find it to save my life.
basically, I just tryinh to total a feild [Time] from a datasheet subform on
the main form.
I entered the following as the control source for a text box on the mainform:

I have a form where the user will choose a Plan Name, then a Product Name
that correlates to the Plan.  Once this is chosen, the user will then choose
one of three command buttons to click on to give them either current rate
form, current amendment rate form, or previously ...

We have a table TblAppraisals where details are stored of job appraisals, by
date of appraisal.
These appraisals happen normally every twelve months, so there are lots of
entries for lots of staff.

I would like to use the same code to execute on events of several forms.
I would like to be able to use the name of the Form as a variable in my code
so the code could adapt it self to the form.
Ex:

I have a reports menu (form), where one of the command buttons opens up a
"Staff Profile" report.
I have put in a trap whereby this happens:
Private Sub butStaffDetails_Click()