I have a fairly busy set of forms (tabbed controls + sub forms) etc...
I would like to detect a special key combination,
(for example Cntrl/RtArrow) as a higher level.
Perhaps at the top level form.

In an earlier posting, I mentioned modifying NTSF security settings.  I found
the xcacls.vbs script by Microsoft that accomplishes the task.  
Is there a way to convert it to VBA?  Do I have to call it with a shell
command or is there another way to excute the vbs script from ...

I have the following sub which works fine to the immediate window, but now I
need to actually DO something with it <grin>. I'd like to populate a listbox
so that users can select the tables they would like to use, but I can't seem
to wrap my head around how to go about it - do I ...

My message box is this:
Response = MsgBox("Would you like to enter a new date?", vbYesNo)
How do I get the default value to be No instead of Yes?
Thanks

Hi.
With help from this Discussion Group, I have built a cascading combo setup
using cboSchools and cboMentors. This works fine but I wondered if it could
be modified to work in a slightly different way.

Dirk,  Remember me?  I ran into a little problem with the edit form named
f_PrimaryEntry.  For some reason it won't let me edit any of the data.  I
really don't want it set up to edit all data but I can't edit any of it.  The
subform is driven from a query but the query is only ...

I have an import button that imports data from excel to my access database
which is viewable in a form.  My form is in datasheet view.  There can be as
many as 900 records. Once the new data is in the form, I need to check the
SSN field against the exisitng table for duplicates and ...

I'm working with a code that allows users to modify the security rights of
files on our server.  We have been using the Win 2000 resource kit tool
xcacls.exe which is a command-line tool and thus requires you utilize the
shell command.

Here's my problem:
I have a form with a subform which WAS related by a common field (PIN).  I
deleted the relationship between the master/detail form & deleted the field
entirely (& the bound control on the subform)  from the table the subform is

I have a table with all sorts of customer information in it (name, address,
city, state, phone, etc.).  A main form can enter in the customer information
or search for records via the built-in search function.  However, the
built-in function can only search by one criteria though ...

Probs:
I want to make a dynamic form. Pushing the button + has to make new
textboxes on my form.
Searching the net tels me -adding control to a user form's Controls

I have a simple form that has several required fields in it.  I've made the
fields "required" in the table, but I'm not sure how to make them "required"
in the form.  Basically I want to make sure that when a user moves from field
"A" to field "B" that an error message occurs if ...

Hi Klaatu and Allen,
thank you both very much for your support yesterday.
I used the way Klaatu described yesterday (Allen confirmed the steps too
yesterday)

Here is my setup. I have a form that when it opens, it shows 3 columns.
Quantity1, Quantity2 and Total. When you enter a value in Quantity1 it
multiplies the values already in Quantity2 and then the Total is displayed.
I have another text box, txtBox3, that shows a target number, ...

Is there a way to take an existing query and set the criteria by VB?
I have a query named ppo1 with a field named vendor, when the form that uses
the query loads, it shows all vendors, which is fine.
But when a user selects a vendor from a combo, I am wanting to set the