I have 3 tables - Customer, Brand and Item. Each table is associated to a
form. the field Customer Code is on each table and provides the relationship
between the three tables. On the Item table, the brand name is selected from
the brandname field on the Brand table (i.e. the ...

I hope this is the last post I have to do for awhile.  Everyone has been so
much help.
I have 3 fields: Item #, Sequential #, and Year (they want it to by in 2
digit format).  I've done this with 2 variables before, not with 3.

I have the following sql:
DIM TodayDate as DATE
TodayDate=Date
"UPDATE taDEFENDANTS SET SummonsGeneratedDate=" & TodayDate & " WHERE

I have the results of 2 queries that I want put on 1 form, my questions are;
can I do that, what is the correct type of display device, should I be using
a “list Box”, a “Sub form”, Tab Control?  I’m using 2 list boxes, the first
one works, the second does not format the decimal ...

I have a form with listboxes that allow me to click values that are then
added to records.  Whenever I close the form, a 'do you want to save' prompt
occurs, even though I don't make any changes to the form design.  What code
can I use to save the form when it is exited?

I have a date field that I use the pop up calendar for.  It works fine,
except that I also open that form in read only.  When I open it in read only
I the date field is changeable, how can I fix this.  I tried this command but
it shadows out the field. Is there another command I ...

In my mainform I have 2 subforms linked by child/master field to the mainform
and control button wich toggles the Enabled property of the 2nd subform.
The 1st subform is datasheet, not updatable, shows records entered thru the
2nd subform.

I need to display in formation in military time. hh:nn, ie, short time.  I do
not want the text box to change to "normal" view when the field is entered ,
with AM / PM showing.  No matter what I do, it still displays with 03:46:01
PM when the field is entered.  Help?

Experienced on Access, very very very newbie on code.
In order to learn (step 1 of 100 of figuring out Allen Browne's multi-field
form filter example) trying to do the most basic example of setting a filter
criteria; filter for exact match between  user input into an unbound text ...

Suppose a database where several tables are linked to a sort of top
level table: other tables 'feed' keys to the top one. I would say
almost all databases must work this way.
Now,

Is there a way to modify the Phone Number Input mask from the Input Mask
Wizard to allow the user to enter an extension number at the end of the
usual 10 digit phone number?  I find it much more convenient to enter the
extension in the phone number field rather than create ...

I am currently converting code from using DAO to ADO.  I am having trouble
with loading a treeview recursively.  Microsoft has a good DAO sample code.  
Any code examples out there for ADO?
SC

Has anyone ever incorporated GMT (Greenwich Mean Time) into Access?  Didn't
know if it is possible, since most of the time / date values are based on the
computers clock.

I want to use one independent Combo box that is used to limit two dependent
Combo boxes.  How do I accomplish this?

I've created a form with a drop-down list, command button and subform and
would like to connect the three together.  So that when name1 is selected
from the dropdown list and a command button "Go" is clicked name1's subform
opens as the subform in the form or if name2 is selected ...