I have a problem I badly need help with. I'm using the Order Entry template
for Access an d have modified it like this. I have an Orders form with an
order details subform. The subform is like this
ProductName UnitPrice CostPrice Quantity LineTotal CostLineTotal

I am new to the Access game and run across issues that I just do not
have a clue how to do...
On my form I have a Combo Box where the user selects a store number and
all the pertinent information in the textboxes fill in...this is for

I have an Access form with a query as the record source.
I have a TextBox BeforeUpdate event to test to see if
the record is an existing record or a new record.
Attempting to use EditMode:

I create three drop down of ddlname,ddladdress,ddlaccount and two
textboxes name txtdate1,txtdate2. My original table name is customers
with fields:
1.serialno autonumber

Help! Nothing's locked.  I can add info through the table, but the form only
shows one record and it won't allow me to edit.

Fuction is Not Available for the expression in query expression. Why  do I
get this error message.

I have a vB code that updates a text box on a "status indicator" form with a
"§" for every 1 percent of text conversion completed via the code (it takes a
while to run the code, it's character-level editing in one field on over
30,000 lines of data, so I wanted to get a general ...

I have a form named [frm_DataEntry] with a subform called [frm_Inv] that is a
datasheet with a field [pmts].
I am trying to add a control to the form [frm_DataEntry] to sum the field
[pmts] in the subform but can't seem to get the fully qualified name just

I am wondering does someone know how to remove the FRAME from the Tab Order???
I am using Access 2K.
Newf

I've a client fond of the "binocular" search ; I'd like to call it from a
button on a form ; any method to do this ? A docmd perhaps ?

Unmatch Function "fomat" in expression, Error. Someone please help

,Our server was updated to Windows Sever 2003. Since then the forms designed
in Access that contain IIF statements in some TextBox began to behave so that
whenever we make click on thoseTexBox, the form begin to make a continuous
blink .Everything was solved putting iif in the ...

I'm trying to repair a user's Access database to the original
functionality.
Previously, when the Find Record button was pressed, the Access Find
feature (ctl+F) would be displayed. The Look In properties would also

I created a table in Access and a form, from the table.  I would like to add
an additional table in the Access form.  Can someone please advise me on how
to do this?

I have a form and subform where I would like to total number of hours for
each employee based on three categories: Vacation, Personal, Other.  I would
like to have three texboxes reflecting the sum for each category.  Any
suggestions on how to do this?