Hi. I have several forms with a listbox and would like
to change the BackColor from a procedure that I
can call from each form's Load event(or what ever
event is relevant.

I created a tblLog to tract the users which has "Username"(captured
NetID) and "Date"(=now).
I created a frmSwitchboard bounds to tblLog and add the "txtUsername"
and "txtDate". I got an error using the codes below "Syntax error in

I'm new to Access and am struggling a little.
I am building a database which is to be used for event management. It
will store details of delegates in a 'Delegates' table and events in an
'Events' table.

AC2000 with SP3, Jet engine 4.0.8618.0
Win XP Pro SP2
I'd like to trigger a function each time a user tabs from control to control
on my UNBOUND form. The form is unbound because I use code to modify records

Using code, how do I 'hit the escape key' through code when in the data add
mode?
In other words, when you are adding a new record and the record selector
changes from an arrow to a pencil, you can hit the escape key on the

How can I design a form in ms access which could call a DTS package in sql
server ? Also it should perform a certain procedure in msaccess.
Thanks
Madhuri

I am taking the advice I received here and trying to use a form to pass the
criteria from a form to a report instead of using a parameter in a query.  I
have the report and the form with a combo box and filter button and a cancel
button.  I am modifying the code from Martin ...

...well, complicated to me at least!! (I have x-posted this to another non-MS
forum, so I apologize if you've already seen it).
I have a form (Form1) that contains a subform (Subform1). The subform is in
datasheet view, and I want to add a new field to it that holds notes - a memo ...

  I'd like to implement something like a recycle bin in an Access form.  
When the "delete" command button is clicked, it should first copy all the
information of the selected record to a "scratch" table before using
   DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70

I have a form created in access and I have added a few controls which are to
be refreshed or values set. when the user navigates in the default record
navigation controls given by access
ie, the the navigation given when access table is opened up for move to next

Using Access 2000.  Trying to test a calculated value on a subform after
changing an item on a mainform. It essentially counts the details of the
subform. I cannot get the correct value to be tested always returning zero
for the test, but the correct value is displayed when run ...

When you create a new email message, there is an 'options' menu item, when
you open this you get a screen with a button & field called 'Contacts'.
My question is, how do I insert & retreive information in this field from
Access.

When I open the access database a form pops up on its
own. How do I change the settings of the form not to show up when database is
opened. I wish to open a main menu form instead of the above form. How do I
change settings for that ?

I have a subform datasheet view.  One row holds a date.  I have created a
form with only the calendar control on it.
What I want to do is when the user clicks the date, the form with the
calendar is opened and then the date chosen is placed in the date field of

I have a form that has three combo boxes' that sorts admin name, Professor
and document type. I have it now to where it uses an rpt and shows the
filtered info.  I now need to find out how to use the same form the three
selections and have it return the filtered info but into a ...