when i entered the field information in form it pop ups window titled
'Enter Parameter Value'
asking to enter the values which i have already entered in the form
why it asking again to enter the fields where i have already entered

I have a form I want to open as my first screen.  I want to have one command
button on the form that will open my main entry screen.  This is easy but my
question is I want a table to track each time that form is open with the
users name and date.  I know how to establish this if ...

Hey all
i was wondering if someone can help me tweck this code..i'm trying to make
the user enter infomation in a textbox (v_actual_source) if they click a
button (btnAchieved). I don't want the user to exit it the form without

I am trying to add a calculation field to a form in access.  Trying to
calculate total number of cases ordered times total pounds per cases
with a grand total.  The expression used is
=Sum([ORDER_CASE])*[JENPROD]![Gross Weight] but getting error message

Hey! I am wondering how to disable or get rid of the record selector on the
bottom of the page? I do not want the user to use the selector to scroll
through the records.
Thanks

I have 2 fields Status (List box) and Resolution Date (text box).  I have
been able to write the if statement =IIf([Status]="resolved",Date()) in the
control source of resolution date fiel to capture the day the status changed
to resolved.  How can I get that date to be stored in ...

Im alittle stuck, can someone help?
I have a form with required data entry - once saved, i dont want them to be
edited/deleted...does anyone know how this can be achieved?
I've tried: [CustomerText is set to Locked Yes and i've tried it with Locked

I would like the default value to equal the previous record, except if a new
value is typed over it. How do I write this expression?

I have field A on form A.
The notinlist event is opens a new form with: DoCmd.OpenForm "Form B", , , ,
, acDialog .
I need, after closing form B, the value of field A (which is comum to both

I have a form where employees enter their time as well as their task.  Once
they print their timesheet report, if they find any errors they can go back
and edit the form.  However, to avoid any future discrepancies, we don't want
our employees to be able to go back and edit their ...

How do you display multiple columns in a combo box and use only one of the
columns as the control source for a field in a table?

I have a combo that goes through and selects all projects from a table that
are being worked on by a particular employee who is selected from another
combo. Now this is working as expected however I seem to be getting 3
occurances of the same project in the drop down menu. say ...

We are currently moving a paper based work system to access database, I
have created the tables and linked them to forms, but I am struggling
to make a field that will continue our numbering system automatically.
We currently use a system of month/year/unique number from 001

I have a combo box on a form.
This combo has a lot of records.
I want to add a botton where the user may lookup for a value and this value
be transfer to this filed.

I have seen Pat Hartman's solution for this and would work well except what
happens when something is not in List and we need to add it?? any help would
be greatly appreciated