I would like to format a date/time field, such that, the time component is
displayed in 24 hours format. How do I ensure a leading zero is added to time
from 00:00 to 09:59?
For example, a leading zero is added to time 07:30.

I am using the following code to attenot ti open a recordset and add a new
record to it.  I'm using Access2003 and the databases are split ( backend
with data is in different directory front end with all forms etc) Is this a
proper way to open a recordset with a split database? I ...

Okay Gurus...
I have an Access 2003 database that I use Me.Recalc.  When I try to open the
same database in Access 2002 and use it (press a cmd) it crashes.  If I rem
out Recalc it works just no recalculation but it works fine in 2003.  Can

i have a sub form within a sub form and  i have allow additions turned off on
the second sub form. i want to turn it back on with a button. both sub forms
are in a tab control box. here are my form names.
main form frm_main

I have three pairs of command buttons whose enabled properties are set to
disabled. I want each of then to become enabled on form load on three
separate dates. The code that I have written for this to happen is mentioned
below:

I have a statement that returns the value of an intrinsic
constant for a ControlType. It returns the value as an
integer ie 110 if the control is a listbox. How can I get
it to return the value as acListBox, which I'm more likely

Thank's for the help I got, but I have another problem.
When Ord is a string I get Error 13, Type mismatch. I thougt the code below
would give me the result Ord, because it isn't True or False, not an error.
How can I escape that?

Is it possible to easily ensure use of combo boxes in a
certain order?
I arent that good at coding but understand the basics
Thanks

Hi there. Using A02 on XP. Have a DepositForm and want to
have the field [DateDep] lock after data entry. (Edits are
allowed on a separate Supervisor form.) I have tried to
put the following in a variety of event procedures but

In a form, when the property window is opened, is there a keystroke combo to
close it, rather than having to click on the X in the upper right hand
corner?  Ctrl+W closes not only the prop window, but the form under it.
Many thanks

I'm just wondering what the diffrence is between using the code on the first
row than on the second row.
1. set DB = CurrentDB
2. set DB = Opendatabase(CurrentDB)

I have a continues form with combobox. If one of the fields is 1 the row
source should be "A"
and if the same field is 2 the row source should be "B"
Is there a way to do this?

I am trying to trap [and stop] instances where users close the app by
clicking the MS Access main Window [X] button in the top right of the
screen.   You know the one, it closes everything....  I want them to close
the app via the menu option 'quit database'.

I have 12 Directories ( User1 - User12) located in c:\Users\..
When I select a user name from a combo box i.e. User3, a list of all files
ending with "doc"in the respective directory (c:\Users\Users3\*.doc) should
be rendered with a hyperlink to the actual file/s.

I am using Access 2003 for my database and have code written to export data
into excel, the following code works in my program:  
Private Sub ExportBtn_Click()
On Error GoTo ExportBtn_Click_Err