I have some subforms that will not display until there is a record in
the table (which I went in manually and put in an ID) now the forms
are visible for that record.
I don't have any code to turn on or off the subforms but they are just

Need Some Help With A Simple Password Form
What a I Have Is Single Field Table, With One Record In It The Field
is Called [Password] table is also called "Password"
which ive created a form that represents this table, so the admin can

I have one module where I would like to launch 2 different forms (that
do exist), based on a form object and string that is passed into it.
(prmTable is a string, not a table object simply because prmTable is
only used in the form's caption)

I have a table that looks like:
A    B    C    D    New
2    5     3    B
1    7    11   A

Does anyone know of an add-on or other that can be implemented into an MDB
front end to allow its forms and reports to look the same at different
screen resolutions?

does anyone have tips what is the best way to document database system
of access
includeing all the tables and queries and the above mentained?

Ok, I know I've done this, but it doesn't seem to work
for me anymore.
I have a form based on a stored proc, usp_PubsAuthors
and it has a single parameter, @FilterState varchar(2) which

Ahhh... I can't figure this out, can someone help?
I'm using Access 2003.
I have 2 tables here:
One is for each person, called tblPartners.

I have an A97 application that is NOT split on a network.  It is used by
15+ folks continually.  It is quick and fast.
I split it several years ago and had to merge it together again after
the folks rebelled at the slow speed resulting from the split.

I have two .mdbs,
MyTestApp.mdb- front end for forms and
MyTestData.mdb-backend for tables.
While the front end is copied to the user's desktop via a batch file,

I have added code to delete a record (and records in related tables)
in the OnClick property:
MsgBox "Confirm delete. Once you confirm, record will no longer
exist.", vbOKCancel

I have a situation where I need to determine a specific table's
primary key, and then output it.
I have tried the Database Object, and the Record Object, but I've had
no luck.

On a bit of a no-brainer with this.  I have a field containing composite
data which is imported from another system.  Here's a sample:
TECH_ACT=2HL91002:TGT_START=12-NOV-07:CAM_CODE=AKJBA:DA=HL:WBS=DES071702:
I'd like to extract the element CAM_CODE=AKJBA but the string after the ...

I want to put the information that the user selects in my combo boxes
into a subform that lies on the same form as the combo boxes.
Thanks for your help already,
Dave

I have an Access 2000 database in which I display many pictures on
reports, the pictures are not embedded, the database just stores the
path to where the pictures are stored. When I select Gifs, Tifs, BMP etc
the pictures appear on the forms and reports. However when I select  ...