I have a time field textbox. I need to get the hour to use in a
variable.  I can't use 24 hour time.
What I need, is if the time is 9:00am, then put 9 in the variable. If
the time is 9:00pm, then put 21 in the variable.

I found good information on how to filter one Combo Box by selecting a
related column from the same table in a previous Combo Box.
Help was found at:
http://office.microsoft.com/en-us/assistance/HA011730581033.aspx

I need Access to read the value in a field and then based on the middle
letter, return a value in the next field.
The first field is a Product Long Code and the second field is the Supplier.
A Long Code can look like: EA01-B1-4460

I have a command button that refreshes its form to complete any pending
updates then goes on to perform some code.
Private Sub cmdButton_Click()
 Form.Refresh

Hi, all;
I'm creating a new command button, as I have many times before, and I'm
using the wizard to automatically create the sub for the OpenForm DoCmd.
However, when I click the button on the form, I get

I'm new to Access 2003. I am developing an application in Access 2003 and
have encountered this error message: "Unable to connect to OLE Server or
ActiveX control". Is there a switch that can turned off to prevent his in the
future? What is the work around or fix for this problem? ...

Can anyone help with this frustratingly easy problem?
I have a table with two columns: CourseCode and CourseName. I have a form
with a bound combo box to the table showing the course codes.  I have an
unbound text box that I want the course description to appear in that relates

I have a very large and complex form that is the bases for a search query. I
am trying to get two combo boxes to cascade, one is generic asset description
and the other is type. However my problem is that I need these to fields to
come from a many to many relationship. I can get it ...

I have been using Steven Leban's SetGetSB code toreturn the user to the row
that they where using, in a continuous form, before a requery. For a DAO
project it works fine. But I have been working on ADP's and ADO and it no
longer works. Does anyone know how to fix the code or ...

I want to copy a record from a table, then change one field value.  How
can I do this?
Copy Record
Insert Record

I am working with a network that is remote to me (I dial in with vpn and
RD). I've not seen this ever before, but when I do a repair and compact
on the db backend mdb file (access 2000 all service packs) the user
group "domain users" vanishes from the files permissions dialog. ...

I'm using Access 2K on a W2K machine.
I have three forms, Main Menu, Combo List, and Output which has a sub form.
I would like to use a combo button to open the Combo List form and from
that form, pass the combo information to the Output form and open it.

I'm running this code, but its a little slow.  Am I doing something
wrong?  Is there abetter way to do this?
Private Sub Command67_Click()
    DoCmd.OpenForm "Buttons", acNormal, "", "", acHidden

I have a form (frmclient) used to enter / edit / add to a table (tblclient).
I also want this to be available in datasheet view. What's easier, just
having two forms each with a different default view or is there a way to use
a command button to change the view or maybe another way? ...

Good Day All,
I have a form that I use for order entry and from my frmmain I can open the
form in edit mode (with a password) or read-only mode.
The code that I use to open the form in read only mode is as follows:3