I would like to set a date time picker control value on a tab control.
I tried to put code onFormActivate, but it fails.
It seems that I need put the code onTabControlChange.
How can I to specify which page is activate onTabControlChange to set the

Can someone help me on this? I have a form with 3 text boxes: Category,
Service, Activity. There are command buttons by each of them that open 3
different forms. After I open Category form, add and save new value, I use
Open Arguments to pass ID value into previous form. How can ...

I can't believe I'm posting this, but I can't seem to get this to
work...
I'm setting up a simple form with one subform. I need to enable or
disable a checkbox on the main form based on both the count of the

I'm trying to create a dialog.
I have two text boxes in my main form ( txt_A and txt_B)
and two command button ( OK_cmd and cmd_Cancel ).
Then in my dialog form,I have two combo boxes ( cbo_1 and cbo_2)

I have a form has a subform in it. All of the fields in the main form are
related to a table on the one side of the relationship(via query). My problem
is when i try to create a subform based off the values in the table thats on
the many side of the relationship, i get an ...

I have two tables where there is a one to many relation to the secondary
table. The secondary table also has a related lookup table that translates an
ID to a text field (to allow for an editable text list):
Primary - volunteers:

Hi, after researching, I think the best way to print a Word document from a
form is with the following code behind an Option Button:
Private Sub Option60_Click()
DoCmd.OpenReport acViewNormal, qryWorkOrders, [RoofPlanLoc] =

I have a number of forms opening and closing and while closing a particular
form and changing focus to another form which was already opened, I get a
message asking me to type in what number
forms!FORMNAME!PatientID

Background: I originally had 6 tables in this database, I cut it down to
three tables and added a large amount of items to one.
I ran across a website: allenbrowne.com from these forums. I found the
perfect search form, here is the link http://allenbrowne.com/ser-62.html I am

I have created a form on our Access 2003 Accident Report database that I want
the users to be able to use to add photos with. Image Control was used to
convert linked JPG files for viewing within the database.
I can currently type in the path to the photo in the text box and the ...

I have an application that's deployed at several location on windows
2003 servers. On each site it uses a distinct system dsn which contains
sa user and pswd, different for each site. Access ver 2000.
On on server, any time I call a passthrough query, I'm prompted for the

Can someone please point out what I'm doing wrong here.  I am getting error
3134 -Syntax Error in Insert Into Statement.  This code is behind a form
using the after insert event.
By using the msgbox, I can confirm that the data is in fact correct,

I'm ready to scream. We have a form with several combo boxes. One of those
combo boxes is cboCourseNo, it has a drop down list of the CourseNames but
it's actually using and storing the CourseNo. It works perfectly. It does
what we want, it enters and saves both the CourseNo and ...

I have been trying to set up an MS Access Database for invoicing and I got
"stuck": my knowledge is minimum.
I would like to know if you would be available for my database-invoicing
thing.

I'm using a button to open a form with the button's Click event procedure.  
Is there an effective VBA technique to set the default value property for the
form's <DamageYear> field to the variable 'strYearOfDamage' ?  
The following Click event procedure correctly passes the ...