I would like to add several table fields from code. How could this be
implemented? What are my options?

I'm using the following code to validate (make sure a field has data) new
and existing records at the form level. My Contacts form has a listbox
populated with a select query and I'm only showing the Listing and Phone
data.

I have a data entry form.  On this form I need a link to take the user to
an attachment (excel or word) on the network drive.  Is this possible?
The name of the attachment may be different for each record, but the drive
and folder will be the same.

I am trying to save each record in a form, call it frmData, as a separate pdf
file with a name corresponding to a field on the master form. The purpose is
put pdf data on a web site with each pdf record accessible as a separate file.
Without getting into detail, I do this:

This is an embarrassing question.  I am using full screen forms and how do I
keep them full screen (maximized)?  I do know about the DoCmd.Maximize but is
there another way to keep all the regular forms maxxed?  The popups don't
need to be and those aren't a problem.

I was wondering if anyone could help me with the following 2 issues:
1- I have a mainForm that has a subForm which shows data in the datasheet
view. I would like to suppress the column headers to show on the Mainframe
when the subform data is displayed. Is ther a way to do this?

We have an application that after some form, report, and VBA code
modifications now fails to work on one machine.  It spews forth errors like
"the object does not support that property", to name just one.  Now, I had
seen this once before and the problem was a mis-match of versions ...

The line
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
brings up the find dialog.
How can I automatically set the option Match 'Any part of field' withoud

I'm working on an existing Access 2000 database which the client will not
upgrade to 2002.
I'm having serious problems with a form I want the user to search a table
with.

I have a bound Combo box with a value list as the row source. The drop-down
works fine but my default value doesn't appear in form view. I tried entering
the default value several different ways but to no avail.
If I change the Combo box to a Text box then the default value ...

I'm creating a wizard, and I'm wondering what the best method is...
I had separate forms that open each other, but the data I'm collecting are
difficult to pass from form to form (multiple arrays).  It works, but with a
LOT of coding.

I have a table that contains home visiting records by family.  I need to find
a way to number these records to indicate how many home visits each family
has had.  For example, Family #1 has had 3 home visits.  When the workers
adds the next home visit, I need it to be home visit ...

I need a bit of code that will search a table field for a certain value and
return a true or false. I don't need to see the value or record, I just need
to know if it is there so the code can then call up a msgBox if the value is
in the table.

In Access 2000 I have a form with a list box with a row source of "GetBoxes"
; a query.
I would like to  not have the box display any records unless the user clicks
a button on the form.

I have 4 fields in my form - I want to prompt the user with a message if
he/she doesn't fill out every field in the form. "You cannot continue without
completing every field."  Forcing the user to not be able to continue.  How
can this be accomplished?