I have a sub form that I would like to hide until the user fills out all the
required fields in the parent form.  At this time that is the Fname, Lname
and the Phone Number. I would like to so that after the user puts date in the
three required fields the Sub form becomes visible ...

I am using a treeview to display data and want to display a customised popup
menu when the user right clicks.
I cannot get the MouseUp event of the treeview to work. It shows in the
Object Browser that it does indeed have such an event. However, when I

I've created a number of shortcut menus for some of my forms. Now I
want to delete them.  When I go into customize toolbar mode, bring up
shortcut menus and access my shortcut menu from the "Custom" menu pad,
there's no "Delete" command.  Looks like you can do anything BUT

I am trying to get it so that if someone pledges ?5 on one table then with a
click of a button 5 tickets are added to another table linked to the person.

I am trying to filter or limit the contents of one combo/list box based on
the selection from another combo/list box.  Both are on the same form and use
different rowsource types and row sources.
The combo/list box that lists staff names and their level is the one I want

Would someome please help me find the gray color number that is the deafult
background color for Access command bars, close,minimize and so on?
Thanks
Martin J

I have searched all over this site, and many others looking for a code or a
way to hide object in a form based on a user-lever security. I have found
sites that show me how to hide an object in a form but not how to hide it
based on a password that a user types in. I don't want ...

Hi, there! I am trying to sling a couple bits of code
together, but am not really sure what I'm doing or what
order to place things.  I want to have an input box form
open, get user input while pausing main code, and then

I searched here for an answer, but did not see anything posted.
I wish to transport the results of a query to ms excel to a location defined
by the user.  I would like a dialogue box to be displayed, that asks the user
where they wish to store the file and the file name, similar ...

Hello,
I have 2 list boxes, one from which you choose something,
then I send it over to another list box to indicate that
it was chosen (just like a wizard).  Here's my problem,

when u open the first form(of 17 forms in total) i want it to open at the
first unused ID#???????????ID is a field on all 17 form pages(its a
survey)

The user needs the ability to choose names from a combo list which can be one
of two products.  Each product has a different set of names associated with
two perspective tables.   I currently have two forms that links to two
different tables.

i have a survey form....its actually 17 forms, that follow each other,
corresponding to 17 tables, each a different section of the survey.
i want each entire survey to have an ID#.
so there is an ID# field on each form.

using a subform to delete entries from a table -
the parent form also uses a query of this same table to populate a cbobox
whenever i delete a record from the table - using the subform - where should
i use requery so that the cbo on the main form will not include the record

After much work  have got the following Dsum to work on
the code event of a combo box change:
intRemainingPayment = DSum
("Ammount","tlbPayments","BookingID = " &