I would like to run the code in a form based on the answer in the second
form.  On the first form (CDM) the user would select a command button saying
they want to run this option but only for a specific department.  The code in
the CDM form would then open a department form ...

I can't get an unbound calendar control to default to the current date. I've
tried using calendar.value = DATE in the "on open" and "on load" and it does
nothing. I've tried all the permutations I can think of: calendar.value,
me.calendar.value, forms!form!calendar.value and DATE ...

A problem with QueryDefs...
I send out email reminders on a monthly basis to school districts. To this
end, I have created a form (called 'frmSDMonthlyReminder') with a button
(cmdButton) and a combo box (cboSD). The button, when clicked, opens the

Getting very annoyed with this one. I have previously successfully used code
behind a Close button on a single record form to take me back to the
appropriate record on a list. Code used the FindRecord command to link
between the two forms e.g.

I am makeing three fields required for the form, Company, State, and Date
Fine Paid.  If all three are not blank then the macro is ran, if one or all
of them are blank the user recieves this message: Please Enter Required Field
(Company, State, and Date Fine Paid)!

I wrote this code when I click a selection field, but it does not work.Can
you tell me where do I have the mistake?
Private Sub AttendClick_Click()
   If Me.AttendClick = True Then

Any label printers out there that are relatively simple to config for
use with Access 2000? Some clients do a lot of label printing and it's a
pain for them to keep track of how many have been used on a 8.5x11 sheet
etc. Printing would be initiated via code, and the label printer ...

I have created a form (frm_Filter) that allows the user to select the values
to as many parameters as they wish (City, Item, Priority level, customer
Name, delivery date, etc...).
If the user presses a button (cmd_Start), then a filter string is created

When I try to click on the button3 (code below), that calls the openfrm and
opens the correct form, but I get an error message in the on_open event of
sfrmca_selectapps in the code line, invalid use of null:
   FLAG = Right$(Me.OpenArgs, 1)

I have a record entry form that I use in datasheet format to enter records. I
created a form to use as a menu with a command button that opens the record
entry form however when I open the form it does not open as a datasheet, but
rather a single form.

I am trrying to open a spreadsheet in excel from form command button but
when I run I get message object variable or with block variable not set
code as follows where am I going wrong?
Thanks

I am baffled - why does my code work when I step through it but as soon as I
remove break and run it doesn't?  Here is the code:
   DoCmd.OpenForm "frmNewStudents", , , , , acHidden
   DoCmd.OpenForm "frmNewStudentsPrevious", , , , , acHidden

I'd like the background color of some fields in my datasheet to be gray.  I
can set that back color property on each field, but in datasheet view, I only
see a white background.  Same result if I set the field's back color in VB.  
Is there any way I can get my gray?

Trying to use a list box in a pop up form to select one specific record to
print from a query that may have more than one result.  When 2 numbers are
entered in the main form to query the database to print a specific
instruction booklet there is a possibility that the query can ...

I have this code I'm running from a command button.  The last line won't
compile.   checkStatus (GetStatus)
Private Sub ButnGetSts_Click()
Dim rtn As Long     'return value from function call