Background:
I have a report which is set up to where each page of the report is dedicated
to one particular publicly traded stock (primary key is "Ticker" in all
tables that are linked to report).  For example, each page contains the

I have a form with the fields AR, LA, OK, TX, MS, Other... I enter miles in
each field. Somedays I wont enter anything in the field. How do I add all of
the entries and put them in the "Total Daily Mileage" field. I have it
working now by entering =[AR]+[LA]+[TX]+[MS]+[OK]+[Other]  ...

I would like to open a form so that it goes to a new record. However, I also
need to be able to search and display the other records using the same form.
This means that I can't use the "Data Entry" option on the Form Properties.
I am sure that I have used a function called ...

Hi everyone, I have a question about using subform. I will be deeply
appreciated if any one could give me any suggestion as I have been searching
for a long time for this and just can not figure it out.
I am trying to set up a database for our special agreements with customers.

I have a field call "Status". The content can be "Active" or "Non-Active".
If it is set to Non-Active, I want another field call "Reason" to be
displayed so the user can put an answer in that field, otherwise "Reason" is
not displayed. How can I do this in my form? Thanks very ...

I need to find a user-friendly way to select specific records from a query...
Place these records in a form, then sort the resulting list by selecting a
record and using up/down arrow on the form. There OUGHT to be an Access tool
to do this, but I can't find it, anywhere. For ...

Greetings...
How would I create date created and created by fields?

I have a database which has various tables, queries and reports running
within it. I have tried to create a input form which will allow me to click a
tick box, so that once the tick choice has been made it relates the
information being put in to the correct table. I am trying to ...

This is a very random question but I am throwing it out there in hopes that
maybe someone will have an idea.
Basically, I have a main data entry form that the processors on my team enter
data upon receiving a client statement.

I want to create a macro that closes ANY form opened when I open a new one.
Is it possible?
Thank you in advance.

I have a form which displays to the user some helpful information about the
main form navigation rules, when the main form «Form1» opens. However, he
doesn't need to read that information everytime he opens that form.
That is why I would like to add a checkbox in this information ...

Hi, and thank you for any help.
I put this section into the load event on a form:
Private Sub Form_Load()
ACT_TRVL = DLookup("[GTotal]", "qryTravel", "[SSN] = '" & [SSN] & "'")

I am using the following code in a button on the form to clone a record in
the subform.
With Me![Employee subform].Form.RecordsetClone
    .AddNew

I have put this code into the afterupdate event of the field [dept] and I
want to populate [subdept]. What is wrong with the following code?
If Me.Dept = "ALS" Then Me.Subdept = "ALS"
ElseIf Me.Dept = "Finance" Then Me.Subdept = "Finance"

How to lock column width in a subform in gridview mode: I don't want users to
change its width.