I am looking for some code that will allow me to lock the current record
(i.e., prevent future changes to any fields on that record), once  a
'Monitored' check box is checked.
I have some code that works great for forms that  have the 'Single' instead

I am trying to create a subroutine that will set some properties on
the specified form.  Can someone help me with my forms collection
syntax?  I want to be able to pass the form name to the subroutine.
This subroutine will be used multiple times which is why I don't want

I have a form with a combo box with a list of names (queried from a
table) and a command button I want to be able to select a name from
the combo box, then click (or press "enter" on) a command button ,
which will open a seperate form that corresponds with that individual

We have a form which the operator enters data in a text box. Currently we
have a 'done' button on the form that the operator clicks to send the text
box info to a vba program. How can we send the text box info to the vba
program when the operator hits the enter key @ the end of ...

I have a multi-row form where I want one of the columns to be a bound
checkbox if the data is one thing, and a bound text box if the data is
something else.  If "conditional formatting" allowed me to set the controls
to visible/invisible that would be great, but it doesn't.  ...

I have an event procedure for after update that I got to work on one text box
by experimenting on one field in a blank database.  Now, how do I modify that
code so that I can call the routine for any other field that has the focus?
Private Sub field1_AfterUpdate()

I'm an oldie to access and very new to access programming
I have the file name of pictures stored in a field, and then a
"PicturePathAndFile" expression in q query that prefixes the file name with
it's path.  

Does anyone have any simple instructions to implement a password form to
allow access to a restricted subform?
Thanks.
Iram/mcp

I created a continous Form in Access to enter our AWB# and Adhoc#. I'd like
to add AdHoc# automatically (like autonumber) when we move the cursor to new
record (without pressing any botton).
How does Vb recognise this is a new record or not? Is anyone can give me an

I have a form with a combo box called username.  The user selects their name,
enters a password, and clicks OK.  Upon clicking OK, my second form opens.
On that second form I want to show the username selected in a field.  
Any help is apprecaited.  Thanks.

I have a module that finds the windows user id.  I want to be able to call
that module and have it populate a text box on a form with the user id that I
use for data entry.  I have tried:
Private Sub Test_1_AfterUpdate()

Ok this partically gets me what i need. now i face a new issues.
The control i am entering in the data too has a control source of a table
column. this table column is a number field. Because of this it will not let
me put in the '-' even though the code takes it out. is there a ...

I'm thinking what should my approach be, to do a simple data edit
correctly. I've got a table with 1500 jobs, User can scroll throufgh
the list, filter, etc, etc, and I want to enable him to edit details
of a particular job. Because the data is quite vulnerable and users

I'm getting the error too few paremeters, 1 expected with the code below.
I'm getting the error at "
   Set rst3 = dbs.OpenRecordset(strSQL3)".  Any help would be much
appreciated

hello friends, i am using ms access 2003.
i am displaying a table values on a form by form wizard.
i want to filter those values.
suppose i am displaying table that has fields,