I have a Sales Form (frmSalesForm) that has a continuous subform
(frmSalesSub) to enter each product sold.
I also have a query (qryOnHandbyPurchase) that calculates QtyOnHand by
subtracting QtySold and QtyReturned from QtyPurchased.

I'm trying to use this codeon my listbox.
If the row is unselected, then when I click on it I want it to be
selected, if it's selected, then when I click on it I want to unselect
it.  This doesn't seem to be working!

I usee the following link and placed it in a module named “FOSUserName”.
http://www.mvps.org/access/api/api0008.htm
Then, I created a field in my table named “Userid”.  I placed this text box
on my form and in the default value property  I entered:  =FOSUserName()

WHen running a DLOOKUP function in a module I get the above error.  I cannot
see where I've mis-coded anything and can't see anything different in this
code than in other code where the function works properly.
I am trying to retrieve the "Rate" from "tblPayRate" based on the ...

I have created a new query, which simply shows me people scheduled for a
meeting from today forward:
SELECT tblCandidates.CORP_OVERVIEW, tblCandidates.PRIORITY,
tblCandidates.AREA_CODE, tblCandidates.ID, tblCandidates.INPUT_NUMBER,

I have a form which, based on the date in the Called_On field on the form
needs to:
1) search tblDailyComments for the date and bring back the DailyComments
data in tblDailyComments.

I have a form with a tabbed control containing a subform. There is a 'New'
button on the form that creates a new record (via INSERT) and blanks out all
entry fields. When I click New and then go to the tab with the subform, the
entire subform is grayed out and I cannot enter any ...

I just faced a problem this morning, and i have kind of fixed temporarily. I
have an access database where i used the module for disabling/enabling the
shift key, just to secure my stuff. This morning one of the users had
problem. Looks like if i disable the shift key module, the ...

I open a form based on three fields. Currently I have all parameters in a OR
kind criteria of the form source. Is it possible that I can use the
parameters to refine my search. eg: I ask user for PA Name or FP Num or Smpl
Num. I want that if user just enters name then i get all ...

I have investigated the posts on "Access web" relating to colour
(formatting) records on continuous forms and they work just great , however,
I have a need to apply a similar technique to alter background colour of a
record based on a field within the record.

Hopefully a simpe question
Can I add colour to buttons ... Ie if negative value make it Red ... If zero
make it black etc ... Iknow I can change the font but can I change the entire
button colour ??

I would like to preview/print reports from selections in an unbound combo
box. This is a big deal to me as I have very little code skills. I wonder if
anyone could help me throw this together? Here are the specifics:
LookUp Table.

I have an email routine in access that sends an email notification to the
user.  In this notification is a link which takes the user to the Access
database.  The problem that I am having is that some users are on the G:drive
and some are on the K:drive.  The path is the same but the ...

If I have several tables: Table1 contains 1) Industry_class_code and 2)
industry_class_description, Table2 contains 1) customer_no and
2)customer_description.  Table3 contains 1) division_no and 2)
division_description.  Table4 contains 1) parent_number and 2)

Is there a means to bring up or move to a specific record in a recordset?
Instead of moving to the next or last record I want to move directly to the
second record.  Possible?