I am trying to use a combo box to pull up records.
When I select a name in the combo box then leave the
form open and then manually run the query it gives
me the results I want, so I know that part works.  I read

I am creating a form which is an entry point for the "many" side of a one-to-
many relationship.  The end result is that the mainform would containg a
listbox of available projects based on a field called JobNumber (this is on
the "one" side of the relationship.  The field PunchID ...

I have a form, "MainMenu", with a list box "empList". The list box has 3
columns. I want to pass the value in the third column of empList (called
empID) to another form. The MainMenu form has a button that opens the second
form, using this filter criteria:

I would like to import data from an xls file into an Access tbl and mark the
xls record as imported.
I have tblCandidates.  I would like to:
1) open the XLS file for read/write

I have a simple question, but I could not resolve it.
I would like to open a certain form - frmOrders by pressing a keyboard
shortcut i.e. Ctrl-Shift-O.
I have not found how to assign a KB shortcut to a certain VB Code.

I have two forms, MainMenu and Enter_View_Requests. MainMenu has a button
that opens Enter_View_Requests and finds a specific record. I used the button
wizard to create the code for this, so I'm pretty sure it's correct, but here
it is:

I have a specific situation here. What I'm trying to achieve is to
prevent a listbox from being populated from values provoded in
textboxes.
This is the scenario:

I used the command button wizard on a form, "MainMenu", to create a button
that opens another form, "Enter_View_Requests". MainMenu has a list box
"empList" with 3 columns. The third column is empID. This is the column I
want to use to filter Enter_View_Requests. Below is the ...

the problem i am receiving is that i can't work the subtotal pf my
receipt out. Basically i have a receipt with various details on such as
product,quantity,unit price,extended price. My problem is that i can't
work out the subtotal. I have code already in the extendedprice box

suite2002  code numbers

Hi TWIMC,
I have combo box on a form and if the user deletes the selected entry from
the combo so it is blank or holding a null value, when the user move of the
record e.g. to save the record I get the message 'You tried to assign the

I have this problem in all three Office products which I regularly program,
Access, Excel and Word.
I write event handlers to respond to (for instance) a change event, but my
intention is to respond only to changes made by the user. The problem I have

I have created a string of code to have the buttom run a group of report
determined on what the user selects.  However,  when I add the combox using
the field Record ID it will not work.  When I us all the other option by them
self or as a group they will work.  But as soon as I ...

I am creating a form where users enter new records that relate to the field
[JobNumber].  I am wondering how to write an expression or code that will add
1 to the New Record in the field [PunchID].  It would be sort of like an
AutoNumber, but each JobNumber would start with "001".  ...

The code below is associated with my Subform1. When Mainform opens I
get 2 warnings that I have
made invalid references to the property Form/Report. Once I get past the 2
warnings, everything seems to work fine.