Hello, how can I programmatically hide all my custom toolbars without having
to specify each toolbar name? In my database, I am showing toolbars based on
the user credential, (Admin, user, guest, etc.)
I know I can do this:

having a brain freeze
Private Sub Command48_Click()
CurrentDb().Execute "UPDATE QBTerms SET [date] = 'Smile' WHERE record = 4;",
dbFailOnError

First,  I am not an Access lingo person so please forgive me if I do not use
the correct terminology.  My apologize to all who are well-versed.
I need to INSERT records into into multiple tables that can be driven from a
SELECTED SET from one single table.

I need to programme my marketing database to create a pop-up to appear on
certain dates for records to be reviewed, can I do this in Access 2000? if
so, how???

I want to run the following command using VBA...
db.QueryDefs.Delete("query1")
But I want to test for existence of the object (the Query) before I do.
How do you do that ?

A simple one (I think).
How do I get the results of a query to be placed in a text box on a form.  
The Text Box is called 'Txt_Color' and the query is called qry_colors with
one field 'color'.

Say I have a 5 by 5 array.  I would like to find the highest value in
each column of that array and also its position.  For example in the
following example I'd like to get return the following data:
0, 2, 3, 4, 1

Hi, in Excel you can use the line application.displaystatusbar to check
whether the status bar is visible. What is the Access equivilant?
Many thanks
Jonathan

Is there a way to change all items in a listbox to selected or de-selected
via code in one step? i.e. without looping through the ItemsSelected(I)
collection and changing each item to true or false?

in order to export in a format acceptable by QuickBooks I need to plug values
in txtBoxs of Form into specific fields in a fixed 5 record QBExport table
made exclusively for this purpose:
1 Header1a Header1b Header1c Header1d

I enjoy the ability proposed with transactions but it seems they actually
cause my vba to FAIL.  This code works great IF I don't have the transaction
code, adding the begintrans etc cause it to fail on the SECOND customer with
odd errors like no current record or can't commit ...

I Have a Hire Dates Table, and to keep things simple, the car has hire dates
booked between 01/01/07 to 10/01/07 and another between 20/01/07 to 30/01/07.
How do I test by querying the table that the dates are free for a further
booking on the 11/01/07 to 19/01/07, i.e. prove the ...

all,
I'm trying to figure out how Access implements error handling.  The function below has two possible areas where there can be an error.
First the delete table section could cause an error if the table doesn't already exist, secondly, the function should throw an error when it ...

I want to open a map in a mdb with vba which is linked to a result of a
field in the active form
Field on the active form shows 3 the map to find is P_3
The path is C:\wilfried\Stamps\P_3

Is it possible to write a function to return array?
I've tried to get some records from table and return them from function as
array:
Public Function Get_ZC_CURVE(paDATE As Date, paCURRENCY As Long) As Variant()