I thought I had the answer, but I was wrong.
Can anyone tell me why this doesn't work?
Private Sub Combo317_AfterUpdate()
On Error Resume Next

I'm trying to call Form_BeforeUpdate event from the On Click
of a command button but I keep getting: Argument not optional.
Any help will be appreciated.

i got tabbed pages on my form
and the coding for this goes like this
If xxxx = False Then
   Me!Page2.Visible = False

The following expression works on my PC running Windows NT.
       !BeginTime = Now() + #12:00:04 AM#
It puts the current time plus 4 seconds in the field called BeginTime.
(generally, the VB is the ADO version)

I might be being thick here, but what is the easiest way in code to return
the sum of values from a field in my form's recordset?
I have a continuous form, and I want to sum the values of a field as a
parameter into another function. Normally I would simply add a control with

I complained a few days ago about Sendkeys and Numlock issues. I
questioned various keyboard makers and all replied that I would not
find a numpad that will ALWAYS send numbers no matter what, except for
programable ones.

I am using a form which includes an image for each record (similar to the
employees form in the Northwind database).  When I move to a form that
displays a jpeg image I see message flash on the screen and vanish before
there is any chance of reading it.  This doesn't happen with ...

I'm having a problem with cascading combo boxes. I'm using the entry in
Box1 to control the contents of Box2.  My row source for Box2 references
the Box1 control in it's where clause. I am also requerying Box2 when Box1
changes. The two combo boxes are on a form that is a continuous ...

I receive a msgbox with an error message when i try to open a form in a db
converted from 2k to 97. The msgbox has an icon of a doctor with
stethyscope. this is the text...
msaccess.exe has generated errors and will be closed by Windows.You will

I have the following code in the Open event of a form:
Private Sub Form_Open(Cancel As Integer)
   Dim obj As Object
   Dim dbs As Database

Here is what I try to do:
I have three fields in a form, 2 of them are text boxes and the third is a
ComboBox. I was trying to write a code that kicks in on form close that
checks if any of these 3 fields is blank, then pops-up a msg box in this

I am really stuck on this and have been hitting a roadblock for hours, and
since I am here, I humbly ask for any suggestions that you folks might have.
I have a form with a subform that is made up of "instances" of yet many more
subform; each instance at the lowest layer ...

I am using Access 2002.
I have a report with a subreport. I want to change the values of certain
controls in the subreport using the main report's openargs. However, whenever
I try this, I get error 2455.

I ask my clients to enter their userid into a temp_input field through an
inputbox.  I want to look at a field [emp_uid] in the table [employee] to see
if the value in temp_input is in the table and if not, put up an error msg
and have them reenter their userid.  Any Ideas?

when i open access form it will go always last record of the table