When I save the existing record, I want to pass the first field, SalesRep, to
the new record.  Currently, all the fields are blanked out in the next
record.  It would save my data entry folk some time if the Sales Reps name
would pass on automatically to the next record.

i want to use if function to fill in one field.i.e
if Currencycode=USD then Roe =1
i want the system to automaticaly show "1" in the Roe field in case i choose
the currency e.g.USD. is it possible

Good Day,
 I have a frmcheckingacct that is based on qrychecking, with the following
relevant fields: Debit_CreditDescription, Catagory. Currently the field
Catagory is a lookup for the user to select the type of charge the

I have set my startup prog to run "formA"
FormA runs some VBA procuders on opening.
Then when it has finished proc  would like to open formB and close FormA
What would the best way of doing this.

Hi. I am currently using a form to enter new sales orders.  I am using a
filter to include all products ordered on a specific sales order.  I can
print the form showing all filtered records - great! Now I want a "Totals"
record added for that specific filter when I print it.

I have a data form using a record source based on a linked table in an Oracle
database.
I would like to have a logon form where users input their username and
password and then to pass them to the data form, in order to avoid the ODBC

hi,
i am trying to build a continious forms for task management within our
stsyem.  there are several stages of tasks and a client can be at any stage a
particular time.

Access97
We use a pc with Access97 and Outlook Express to send out automated
reports to a number of different email addresses each day. That works fine.
I would also like to be able to send out an email to the list of

I need to add to following code a wait statement while file is busy.
I am running an external program through access which writes to file.
After written I do following:-
DoCmd.TransferText acImportDelim, "", "tbl Directory Info temp1",

I am very new to this, but this is what I would like to do.
I have a combo box that has for a control source a query that selects
customer names.  An extended part of my form then contains unbound text
boxes.  I have been trying to, upon the change of the combo box, change the

I have 2 forms - 'New Instructor' and 'New Course' which are linked.
The first form has the following fields - InstructorID(autonumber
primary key), Instructor First Name, Instructor Lase Name and
Department, all of which are linked to an 'Instructor' table. The 'New

I have an option group "Radio Buttons"
"Protect" and "Un-Protect". I would like the user to have this option so a
msgbox can red flag and Remind them about Changing an Animals name.
I have a form where I enter Animals. Once the info is entered I would like

This is the first time that I am using Access for development. I have a very
large Table, so large that when saving I kept getting a error that it
exceeded table size so, I had to take some fields out. I had all Validation
and error Text in Table. To give me more room in Table I ...

Let me say first of all I am a newbie and know little about actual
coding, mostly self taught.  I have developed a database that I use to
track employee records. I use this database among other things to
record attendance and to track staff paid time off that is based on

Does anybody know how to make a text field in a form non-editable?
Thanks
Shal