In the OnOpen code below, execution is taking the Else
path even though I've verified that OpenArgs is Null, both
by displaying it via the MsgBox AND examining its value
when the runtime error is raised when the statement:

For Access 2002:
Q1:  Have tried using Stephen Leban's animated gif ActiveX control from
http://www.lebans.com/animatedgifplayer.htm on a simple form with only that
control.  I get an error, "Not enough free memory to update the display.  

I have a combo box in my form when pressed a Microsoft calendar pops-up and
the user select the date from the calendar and it will display the date on
the combo box,  all this is trigger  from on mouse down event.  Not a
problem works fine. If any of my text boxes are not ...

If a table field defined as Date is un-initialized,
what is it, Empty, Null or zero length? Though
they are normally stored as 64 bit numbers, I
see that un-initialized fields are not displayed as

I have a tabControl on frmForm. When the user selects a particular tab (e.g.
Tab2) I would like to run a procedure. I can activate a procedure when the
user clicks on the tab control using: private sub TabControl_Change(). But
how do I evaluate which tab was selected (for ...

I want to disable some db functionality once a 30-evaluation period has
ended (and the customer has not purchased the license).
Would you recommend to put something like below into the OnLoad function of
my start form?

How do I format the date specifically in a input box output?  I have this:
   Dim BegTime As Date
   BegTime = InputBox("Select start time of Tirtl Count.  Use Time (_:__
AM) structure!", "Select Beginning Time")

I have a subform that shows various records.  I want to have text box on the
subform that shows the number of records that the subform is sourced to.
What is the best way to do this.  I have looked at coding the form_load
event of the subform but can figure it out.  Also is there ...

In the course of inserting a new record into a table:
CurrentDb.Execute NewWorksSQL, dbFailOnError
I want to add a new field name and value as the SQL
string is constructed. The field is defined as ShortDate

How would I code a form so a regular user would only receive records they
entered for the day (way to allow if no records, show new blank record)?  The
Admin, obviously will be able to see all records.  The Record Source for
properties in the form for all records is qryCalls.

I have a listbox that shows records with their elapsed time.
As such...
Record    Opened    Elapsed
1    10:00    1:00:00

Would anyone be able to assist with this problem.  John had suggested adding
spaces in front of WHERE and ORDER by but that didn't work.  I'm desparate to
get this form to run.
Thank you,

I have a form which allows the user to add records to my database. All of
the records are shown as text boxes on the form. Two of the fields are
'FirstName' and 'LastName'. Each field has a corresponding textbox on the
form (called 'txtFirstName' and 'txtLastName') so the user ...

Hi, Guys! Good morning/afternoon/evening!
I have a simple bundy clock application using microsoft access 2003. My
dafault values for Time-In is TimeValue(Now()) and for Time-Out is also
TimeValue(Now()).

When initially designing one of my dbs, I had added a few option buttons in
an option group, let's say two.  Now, 3 years later, they've decided they
want to make them into checkboxes (as well as add others).  OK, now is it
possible to change these option buttons to checkboxes?  ...