I have a form that has option buttons on it.  I have code on the form that
determines whether a option button has been pressed and if it has I want to
requery the form.
Here is the code I have so far.

I have a field ([otherstaff]) in a table (tblCompanies]),
containing 0 to several staff names, separated by a comma.
I'm trying to create a query which will display all of the
individual names, but in one column, not as many as there

I need to programmatically (VB) hide or show the database window. How can I
do this please?
Access2002.
Thanks!!

Per the instructions detailed here...
http://www.fontstuff.com/access/acctut08.htm
...I created a parameter query in the form of a drop down box that uses a
command button to produce a query.

I'm sure I must be missing something simple but I cannot set the focus on a
combo box on a main form control with an event from a subform control at
gotfocus.  Run-time error  '438':  Object doesn't support this property or
method.

I think that this is something that should be quite simple to solve,
but I
don't know how to word it well enough in a search to find a solution.
Basically, I have data that's dependent on two keys in a table.  E.g.

I have made a query in VBA code to update the records of a table triggered
by the After Update event of a combobox. The query is designed to update any
record that has a field value equal to the string value of the combobox and
set the field “Shared” checkbox to True.

I have used this code over and over again but never on date fields.  Now I
am trying to use on date fields (Start Date, End Date) and I keep getting
'Data type mismatch in criteria expression'.  Now I have used m/yyyy fields
with no problems, why is the entire date giving me a ...

Before  user have enter a valid value
I have
Private Sub KundeNr_Exit(Cancel As Integer)
And i have read somewhere that if i set the value to true en the psocedure

I wish to make my own navigation
but then i Miss how many post are there in may tabel
an what post are i am now
CAn someone help me please?

Is it possible to hide a page based of a field in my table?  and if so, how
do I accomplish this

I need Help!
Is there a way to autogenerate a number on a form? We have a form that
populates the orders table.  O_Num(order number) has to begin with a T
or G, so that would need to be a drop-down I guess.  Then they want the

I am using the menuing objects (CommandBar, CommandBarControl, etc.) to
customize the "Menu Bar" menu for my app.  The problem is that is Access
crashes (before my code reverts menu back to the standard Access menu) or if
a user opens my app and then MS-Access afterward, they see ...

I used the tool box to inset a command button into Form A. The command button
opens another form, Form B. This works fine. I then dragged Form A into a
third form, Form C. Form A works fine from within Form C, except the command
button in Form A does not work under these ...

Using Access 2000 SP3
I've got a calendar form with 365 labels on it. I would like to be able to
click on one of them and have some code determine which label had been
clicked (i.e. I don't want to have to write 365 OnClick subroutines). Is this