I need to insert a very simple error handling procedure in my code to open a
form. I'm not getting where to place it in the original code sequence. Both
are very simple but they aren't working together so far. I have a form with a
text box for entering account number, and an OK ...

Thank you Mr. Lebans for your many examples of list box. they are easy to
follow.  Anyhow I have a form with 2 cascading list boxes.  The first list
box I have 2 colums.  Colum 0 has a date formatted to dddd to display the day
of the week and colum 1 has the same field but formated ...

Anybody knows how to set the tabindex of controls with code? I know you can
use the tabindex property but that does not work when you want to change the
tabindex of a lot of controls.
I don't like to use the normal way with the form with the names of the

I would like to control the tabs from my form to my subforms.  I used
me.Zip.tabindex = 5 and that gets me to the last field in the form but how do
I get to my subform?
Thanks

I have a table with the following fields:
Treatmentdate    BodyWt        Dose
5/16/1996                   92.75        130
5/17/1996                           140

A command button on my form has three choices (code below).
The first two work fine, the third bombs at ".ItemsSelected"
Compile error: Method or data member not found.
Private Sub KeyIndicators_Click()

In a 'Before Update' event I have this code:
If Len(Me!Topic) = 1 Then
     Me!Topic = "0" & Me!Topic
End If

Hi guru's:
I need to calculate the half a year or a 6 months out mark based on date in
another control, the sample below is how I've gotten it working, kind of! Is
there a better way to do this using the DateAdd function?

i m new user for the ms access i have table employee
i wan to create a form with a sub form , on the form i wan toc  all the
information of themanagers and i want o c athe names in a combobox so that
when i choose the name of the manager it ask me for the manager id and after

It will help if the formation box brought in all the database.  The tables
and queries need to force the page to do a new print and find the IP address
again.  The last page of the query has no formulas in it or check boxes.  the
IIf statements are nested 2 times per line, and tere ...

Again I turn to my mentors in the shiny computer screen for some help with a
thorny issue.
As some of you may recall, there is this silly survey that I'm responsible
for creating. I've got it up and running wonderfully, and it's storing my

The user enters data in a form (an issue log) and clicks OK. The data should
be appended to Tables!tblComments, but I get an error: "Run-time error
'3075': Syntax error (missing operator) in query expression 'Enter comments
here.'.

I have a subform that opens invisible to start a "encounter clock" to time a
session.   When a button is clicked on the main form to end the session, I
want that subform to appear so that the user can "sign off and stop the
clock" on the session then click a button located on ...

Yes, a friend of mine had sent me pictures in the "jp2" format, I know that
her OS is the same that I have, WinXP. the only thing that I can think-of
that that format is for is either a Scanner or a digital Camera. does anyone
have any ideas? I hope so.

Is there a way to merge layered images in access?
I want to be able to have a image with transparency show above another
image.
I can do this and it looks great on the form but how do I group the two