I have created a database that users will enter data using an entry form. I
want a blank form to show up each time a different user wants to add a
record. I don't want the record that they entered viewable to other users.

i use this code:
DoCmd.TransferDatabase acExport, "Microsoft Access", "\\server\pcg\pcg.mdb",
acTable, "Kunder", "Kunder"
1. Can i in this code have a password to \\server\pcg\pcg.mdb so i don't get

I am trying to use DoCmd.CopyObject to copy a table from a database tha
has a database password. After the path to the databse, I've trie
adding:
;Database Password=MyPassword     and

I have several class modules created from selecting modules on the menu.  I
need to now link them up.  I don't quite understand how to call them without
having them linked to a command button.  
I am pulling several queries and sending them via lotus notes to various

Good evening.
Is it possible for me to integrate my access 2003 into outlook 2003? I have
an order database and I want all the ship/delivery dates stored or go into my
oulook calendar automatically. And if it is possible, how? Any workaround on

Hi all, i searched for code in this forum for checking of existence of table
before deleting, i found the code shown below but i don't know how to use
functions, do i place this code in a module then invoke it in the form i want?
if yes how do i invoke it? i would probably want to ...

I am having trouble an email module. When i run this it says that there
are too few parameters.  That it was expecting 4.  I assume that these
are the criteria that is feeding my query.  Right now i have a form
with 4 comboboxes that provide the criteria for the query.  I have a

If I use the code :-
   Set dbsAdmin = CurrentDb
   DBPath = dbsAdmin.Name
The full path name should be say, c:\Folder A\Folder B\Mydatabase.mdb but

I want to slect 3 of the 12 months.  how can I query at any time to
give me 3 months and allow me to choose which months.

I need to copy an ADO recordset to an Access Table.
How can this be done?
Thanks!

Hi, everybody!
I know ac97 does not provide direct binding of an ado rs to a report. I want
to do it manually.
I have a form with a textbox and a button. On the button click event, I

I have Office XP and Outlook 2003.  Here is the following code in Access:
DoCmd.SendObject acSendReport, "rptOutServiceAreaAudit", acFormatXLS
When I run this, I get this error:
The format in which you are attempting to output the current object is not

Im working with two fields:
doc_num= format 05-01-1
The first 2 digits represents the year. The second two represent the month.
The last part is just a record number.

I have a form with 16 checkboxes.  Each one Q01 through Q016 represent a
quarter of a quarter of a square mile.  They are layed out in a square with 4
checkboxes in each quarter of the grid.  The description will be built for
each quarter of the grid. For example, the upper ...

Hello, how do I count the number of records in all tables in a certain
database.  I need a list with table name and count.
Thanks in advance.
George