I have a table named "Estimate Template" in a closed database
named "Newdb.mdb", which is located in
"C:\Temp\Automate Office".
I create a new database with the following code, which is running

I'm trying to make a backup database button on my switchboard. Is this possible? If so, then what's the Back up Database run code command? Any help will be appreciated.

I am about to create a new database and I want to make
sure I create it properly at the outset so what I want to
happen can actually happen. Here's what I'm planning:
1.  Form (DEMOGRAPHICS) that will contain demographic

I have compacted an mdb which had user and group permissions associated with it. After compacting however, I was locked out of the original databse and the compacted copy. The message was "You do not have the necessary permissions to use the ...FileX...object. Have your system ...

Is it possible to open a form in a second database from
switchboard in primary database? I tried importing tables
and forms from second database but, after compact and
repair get many error messages. Databases work fine

I am documenting an Access application and I would like to insert pictures of some command buttons of this application in this documentation (because I have to describe their use)
I did not success with good old copy/paste (it copies all the form, not only the button) and I cannot ...

Not sure which group to place this question in.
Excuse my Duh...
I have a table whish has 2 text fields. I want to combine these
fields to make a unique ID field. Could someone explain please how I would

Is there a way to Remove all punctuation from a text string, without
identifying each type of punctuation, if not what is the best way to do it
with the text as a variable.
Thanks John

How do I run a SUB or FUNCTION that is located inside an
Access database (.mdb) from another application (such as
a web app or even an external VB executable)?  Pass-thru
queries don't seem to provide me with enough flexibility,

Is there a way to have a delete record command button on a subform only
delete the field(s) that are linked to the parent forms table? For example:
I have a table (misc_donations) with 3 fields: donation_type, donation_amnt,
donor; and another table (donations_types) that has just 1 ...

I was running a database that set menus to false and now when I start
access  the file and other menus are missing.
How do I reset to get full menus again?
Duffaukid

I'm hoping someone can help me out. I'm trying to setup a
database to enter some products and volume and price. We
buy the products from different sources. The different
vendors use different names but they are essentially the

Hi. I have this textbox on a report that is bound to an underlying query
fetching the values to the textbox from a tablefiled (text). Another
component is needing data from this textbox as a string. If I hardcode the
textbox's controlsource like ="123456-12345" then the component ...

Hi, I have tried the statement below but all it does is list the dates as
normal, the only way it seems to work is if i enter Date()+7 which advances
the current by 7, but im interested in advancing a date already entered with
a table.

I finally had time to sit down and go through this wonderful book I bought
called Access 2000 VBA Handbook by Susan Novalis.  In the book they have you
create a expenses db using the wizard.  I have both Access 2k and Access 97
installed on my machine here at work and for some ...