I know how to manually alter the caption for a form, but how can I set it
dynamically????

I have a form in Access 97 which contains a field which pulls together data
from other fields.  ICB Tracking Number=[ICB Number] & [Region] &
Left([Vertical],1) & [Auto Number].  ICB Number is a dlookup field (julian
date - I couldn't figure out the sql to determine julian date ...

i have a form in microsoft access with buttons used to open tables and run
simple queries.  I would like to add buttons that would open specific word
and excel files.
excel and word are located on a local hard drive, while the files i would

Ok here goes.
I have an exisiting database that I'm trying to update.  All new fields onto
this report have to go by the following.
I have two Date fields, The first date field is for the current date so

I'm trying to enter a double click command in an item in a look-up form so
that it opens up an individual record, but I cannot figure out the command.  
I can go to a blank form, however, it's not going to the individual record.

I would like to make a list box in form. The form shows information of
different people. Each people can choose certain food from a list of them
(select the whole list available as the row source). I would like the listbox
display the food a person chosen as selected ...

Anybody who has filled out their share of forms in their life time will be
familiar with a section that says "Check all that apply." I have a paper form
with a field like that which I am trying to turn into an Access form feeding
into an Access table. Any suggestions on the ...

I have a list box that pulls up site numbers from a table.  Is there a way
to set the value of the list box to the first property in the listbox?
thanks
Brent

How could I set a Form or Table's Default date to prior the month in month
and yearformat  e.g.(May- 05)?
Thank you,
Gary

I have a form with a 5x8 grid of 40 different text boxes, each of which could
have a date in it, or it could be blank.  Each row represents a phase of a
program, so the grid looks like this:
A1   A2   A3   A4   A5

I want to view the code on one form but when I select View > Code from the
tool bar, every form  opens to "View" code.  Is there a way to prevent this
from happening.  Hopefully this is fairly clear.
Thanks for any help.

A very important subform is repeating records.  Users make a series of combo
box selections that determine what appears in the master field, which has 10
characters.  The child field is a primary key with up to 15 characters, the
first 10 being identicle to the master field.  The ...

Hi. Right now I am working with two tables. One has Employee IDs and Employee
Names. The other has Employee IDs, Annual Salaries, and the Year. There will
already be information in both. I would like the form to look like this:
Year: (Textbox)

I have a continous form based in a table, order by Field2.
Is it possible to order records in this form by Field2 too, please?
I have a similar situation in single form and work fine, but in continous
form... and I don't know why not.

I have a Subform base on a query that's on a main form. On the main form
I also have a Textbox for entering number of days. The Subform
has four Text boxes, frmName, frmCode, frmTime and frmdate. How can I
use a commcand button to look at the text box on the main form to check for