I'm trying to lock three text fields: SS#, Name, and ID to prevent them from
being typed into.  I want to create a command button that you click to unlock
the fields for editing.  When clicked the name on the button should change to
"unlocked".

I have a Yes / No message box but I don't know what the code is from the
results.  I think I need to use vbMsgBoxResult within vb but I'm not sure
where it fits into the coding!
Help!

I currently have a form which I navigate through forward and back buttons
(not default navigation buttons), but also with the help of a list. In the
list I have all the names of the persons in the header and when you press the
name you will jump to the corresponding record.

I have an access database which is in 2000 format. I use Access2003 for
development. I have a form with a Tab Control. The color of the control is
white (not the usual grey color)  I want to change the backstyle to
transparent. When I change the property from normal to ...

I have a combo box which displays values based on a table's index,  namely
"Cname".  On a match, other fields on my form are  populated.  When there is
no match, data from the first record in the table is displayed (which I
don't want).  The form layout has the combo field, followed ...

Okay here goes.
I am very new to access and am building or attempting to build a video
archive for a company.  I have made a start up form that allows the user to
choose to either add records, search for particular footage, and print labels.

How do you add a new record to a subform base on the value of a text box on
the main form?
Floyd

Does anyone know of the dimensions to set up for a label so I can print a
query on an envelope? I'm getting tired of guessing. Thanks. I have the
query down, I just need to figure out how to print an envelope from my
database. Thanks in advance.

I converted an Access 97 mdb to Access 2003 and am getting undesirable
behavior when debugging.  I have tried it on three different computers with
same result.  I have a form with a single command button. and two procedures
as shown below:

In Access 2003, I have a one to many relationship in which an Order ID is the
primary key in one table and the foreign key in another table.  In a form I
want to allow users to be able to either select a current Order ID (so
related information will appear in the form) or input a ...

Can someone suggest a way to capture more than one response to a given data
element. For instance, let's say on the form you want to capture the
addresses for a given person. Due to various reasons, in my situation, a
person might have any number of personal, business and leisure ...

I built a dialog box for users to choose a report from a group of them. I am
given “Type Mismatched” error message every time I try to open the report
using this dialog box. Anyone of you has any ideas what could be the problem?
Followed is the macro to open the report.

When converting an Access 97 Database to Access 2003 I receive the following
message. " You can not convert or enable an MDE file". Does anyone have any
information on this message. Thanks Kelly

I have a database with several fields - 2 of them are OLE for adding
pictures.  This has worked fine, however, it is now 1.7 Gig. is size.  This
is getting out of control.
I need another solution.  I tried DBPix, however, their technical support is

Ok, I've tried the syntax a billion different ways, and I can't figure it out.
Main form = FrmBatchControl
Subform 1 = SubFrmTotalComplete
Subform 2 = SubFrmBatchWorkSubform