I have a database that does an auto backup of some data before
closing.  I also have it set up to delete all backup files older than
5 days.  I can't figure out how to check if the file is there and to
keep from getting the "File not found" error.

Hi, All
 I try to trigger tab key press when enter  a string in "customer ID" if
its length is six, but I cannot find command to simulate TAB KEY press.
PLease help.

Is there any program (MS Access or another one that can emulate it) that I can
use on my Pocket PC to run my databases?  Including all codes, etc

I am curious as to whether there is a way to use ZOrder or SetChildIndex
in MS Access (VBA) to place one control at the top of the Z order for
the form (or its layer within the form) at runtime.  I've been scanning
online documentation for an API to add to my code to access ...

Access/Word 2000
I am trying to merge a word document with an access query that has a
parameter attached to it.
Could someone please suggest how to stop the parameter from appearing

Is there a function that will take a name from a table and convert it to
title case? ie the first character of the name in upper and the rest lower.
The strings in the table have been input in either lowercase or uppercase
and some as titlecase.

I currently have a subform that displays four fields from a query.  I have
the subform's properties set as follows, so that the end users can not
accidently change the data.
Allow Edits = NO

Does anyone know if this can be done?

I know this is a strange question, but I have inherited a system where files are copied
and records re auto numbered (as an index field) )frequently, and I am wondering how high
the number can go without the system crashing.
An ancillary question is how one resets an auto number so ...

I am updating a table with an SQL statement in a VBA module when you click a
command button on a form that closes the form after doing some background
stuff.
When it updates the table, it then pops open a form asking if you approve of

My database have 20 tables and many users. I wish to store encrypted
data in 3 tables and have only 3 users have access to them, walking
into tables or using forms.
Can someone point me a direct help or something to read?

I have created a query that examines qarterly sales for 5 regions in
the country.  The query contains data for the past 6 quarters for each
region and calculates the perecentage of total sales for the quarter
fo each region.

yes the week commencing column is the unique column date

I have a question about declaring variables. I do a lot of re-querying
of controls in my database and I use the Set statement with a variable
set to the name of the control to tell the program which control to
requery. This makes it easy to requery controls on a different form.

I'd like to have a couple of buttons on my form so I can quickly access
some Access (97) features:
A) The relationships window;
B) Tools - Analyze - Documenter (for relationships).