Can anyone help me please, I am trying to code a command that I created (not
the usual Grey one) to back up my current database. I can't find a command
that will do that, anyone with a bright idea that could help me?
Thanking you in anticipation to whoever does come up with a ...

I'm using VBA to create a query, run it, open it, get a count of records,
and then enter that record count into the Description property of the query.
It works fine, except that occassionally I will get an error,
       "Item not found in this collection"

The DoCmd.CopyObject method does not have an argument that flags whether to
copy all the data, or just the structure.  Is there a way in VBA code to
copy only the structure of a table, and not the data?
Many thanks,

I have read, here and elsewhere, to avoid dlookup for a variety of reasons.
Then what is the alternative(s)?

Please give all Visual basic based programming codes for use of Access 2000
and XP.

A few days ago I noticed the following project in my Access Visual Basic
Window:
utility (UTILITY)
It contains 2 Microsoft Office Class Action Objects named:

I'm designing a Form in Access 2003 and where a given event takes place, I
call up a Function. Basically, the Function holds 2 arguments. One of them is
the name of the field in the form to change, the other one is the value.
Here's the function:

I have a datasheet form that has a text box named txtBalance.  I would like
the txtBalance default value in a new record to be the value entered in
txtBalance of the prior record.  Thanks in advance for your help!

I am creating a new database to use with Dr's and Staff to help with
recording labs and all their data. I have made about 26 tables for the
database and now I need to link them. Is there a faster way of est.
relationships between the tables or am I going to have to work on this ...

Looking for a way to determine number of rows in a QUERY...all i have found
is caouting a table or rows from a SQL statement---I need to do it from a
query (the query changes)
Thanks!

I want one of my fields to display "July 08, 2005" but I want to input it as
07/08/05.  What would the code be for this in the Input Wizard?
Thanks Jen

I have a split database with a folder of photos kept on a server.  In a
form, an image control's Picture property is updated when the user
changes from one record in the sub to another.  It all works very fine
on my computer and on some others. But some computers get errors.

I can access the container users for their names and internal telephone
numbers ( this is for a voip system ) but I need to be able to traverse
through all containers to seek users and their respective telephone numbers
regardless of the container they are in can anyone help ...

It's been awhile, but is there a way to find the path name for an Access MDB
app?
Problem:
I have an app that tracks items.  Each item has data and pics that appear on

Hello.  I'm a professional developer with a PC happily running Access 97,
2000 & 2002 from separate folders.  Starting two days ago, whenever I open
any code in an app in the 2002 version, it perpetually checks the code - and
I mean constantly.  With every key I press, it turns ...