is it possible to create a button on a form that will enter in a user's name
and the current date into a signature field?

Hi. I have a subform with a product, unitPrice, costPrice, and quantity field
in it. Also I have two columns LineTotal and CostLineTotal where I have
price*quantity. When I try Sum([LineTotal]) and Sum([CostLineTotal]) together
in the form footer, errors occur. Both work fine ...

Please excuse silly question.  Am proper newb at this and am slowly teaching
myself when I get the chance.
Well, have two questions.  Am putting together a small database for my wife
who works as a hearing aid audiologist.  It is so she can keep track of her

I currently have a combo box set up to filter records in all of my subforms.  
How would i go about using the combo box to show all records at the same time?

I have an order form with an OrderDetails subform. Within this subform I
have; Products, UnitPrice, CostPrice, Quantity, LineTotal, CostLineTotal
Products is a combo-box where I want the UnitPrice and CostPrice to come up
in their fields as specified within the Products table when ...

I have data extracted from a remote database using ODBC which has one field
of type MEMO.  In this field the data is formated using tabs (ie chr(9)) . I
store this field locally in my database however when I display it in a form
the formatting is lost (ie the tab character is ...

I'm working in Access2000 and am having trouble finding a way to take
imported "OLEPath" field values in my database and filter out or
eliminate all the alpha text so we only get numeral values, allowing
for number formatting. only the first and the last 4 of every value is

Okay, I have the following table:
STYLES_COLOR_SIZE:
STYLES_ID (fk)
COLOR_ID (fk)

I have created a form with a subform. I need to subtract a feild from the
subform from a feild on the form. Also the data from the fields come from two
seperate tables. 1. Can this be done? 2. If so, how? Thanks.

I have managed to get a text box to go between visible and not using:
If Me![ComboBox] = "Bad" Then
   Me![Label_TXT].Visible = True
Else

I have a form that has quite a number of fields that extend to the right...is
there a way for me to freeze certain fields (i.e. in excel, where i can
freeze column A-C) ? i know how to do it in datasheet view, but this needs to
be viewed in "Form view"

I have a Form with a command which runs a crosstab query and i want to
create a table with the Form output. is it possible to create a new
table from the Form output ......is this possible
any suggestions

My delete button just deletes the records with no warning. How do I get
it back? The event for my button is:
Private Sub DeleteButton_Click()
DoCmd.SetWarnings True

Does that make sense?  Let me put some meat on the bones of what I'm
trying to do, here:
I'm trying to keep track of my when my cases are on in court.  I,
therefore, have a form with fields where I enter the "Case Number," the

I enter service records into a form.  It contains a subform for parts and
hours.  The data in the subform needs to stay with that record only, even if
there are mulitple records for a particualr date.  What it's doing now is
applying that subform data to all records with the same ...