hy
i have a form called marketers and fileds called visittype,first,last and id.
i have following code to generate the autonumber for field id based on
condition of visittype.

Is there a way to automatically run the tool Compact and Repair when a user
closes out of the database?
Also, what is the best way to back up the database on a different drive?
I would like to put a command button on a switchboard that would allow the

quick question: how does one refer to a control by its tab index using VBA,
as oppose to using the control's name?
thanks in anticipation...

Help requested!
I am not a programmer but I have the following crude code that I want to run
in an Access 2000 database. Can anyone clean it up and tell me where to place
it in Access 2000.

Bit new to this, but how do you programatically bound the result of a query,
in this case a scaler to a textbox control when the form loads up?
Say
form name is frmmenu, control name is textboxincomplete, and query name is

Is it possible to set Access to automatically insert a postal code when the
town name is entered ? They are only town postal codes, i.e. 29719 covers the
town of Velez Malaga, 29713 covers Los Romanes etc..

I have a form that has a control form in which i open other forms.
Each of this new forms has a treeview.
when i press a botton i open a form to insert a new node.
but when i close the form i do not see the node inserted until i close de

Is it possible to Call a function with an argument, Open a form using this
argument and return the value from an options list while closing that form,
then return to the original form.
eg

I have created a simple procedure to assign values form various controls on a
form to an array and then update the data into a table, however, there is a
possibility that some of the controls will not contain data and therefore I
do not want the procedure to add null values to my ...

My programming skills are non existent and I need to write a small visual
basic procedure for our staff database.  Basically we need to calculate the
amount of annual leave a staff member is entitled to.
This is worked out on the WTE (whole time equivalent) and the start date.  

I know how to do a CommandButton_Click() event and I have a
CommandButton_KeyDown() event which checks to see if Ctrl was held down:
Private Sub Note_Toggle_KeyDown(KeyCode As Integer, Shift As Integer)
   If (Shift And acCtrlMask) > 0 Then

I am currently doing an Access97 project (unfortunate that it's not a later
rev, but that's what the client is using).  I have established some global
variables, but something is overwriting them at times.   For example, I have
an array that is global, I only assign values to it ...

We have 5 different computers using access applications. My computer
spontaneously stopped switching between apps even though everyone
else's was working properly. The code uses On Error to catch when
AppActivate fails and then launches a new copy of the app it's

I'm fairly new to Access programming and have a question.
My form needs to check for the presence of the data entered by the user in
another table and if it is not there, make a message visible on the form.  
The focus needs to return to the field and clear out what was entered and ...

on my website: www.mutedesigns.co.uk/bpubs
user: test
Pass: test
when logged in select the 25th February and you'll see it says: Jarv will be