I have not played with 'Type's before, but want to use the same code to
combine Boat IDs, Boat Names and Class of boat where one person has more
than 1 boat
The code is below, and I type into the Immediate Window

When i send a report as a pdf and prompt for editing, I then send the
email, an additional window then opens behind
How can I prevent this window from opening
Thanks

I have a shared Access mdb that was originally written in A2000.  The
database is large, around 40 tables, 40 forms (many with multiple
sub-forms), and 100s of reports.  The database is not split, but runs off of
the LAN in the office with about 5 or 6 concurrent users.  Recently ...

Hi.  I am stumped.  I have a form that when opened via logic (VBA
OpenForm) the screen appears to flash but the form does not appear.
I've traced and it certainly goes to the form's module and the Form_Open
and Form_Load routines...but it doesn't appear.

Hi, i've created a linked table in my access database (with
DoCmd.TransferDatabase). But how can i retrieve the info about that
table? i'd like to know where the path of the original database source
is.

Using Access 2003 front end; SQL Server 2005 Back end:
I have a complex form that has lots of data fields including about
thirty or so checkboxes storing Yes/No data that I would like my users
to be able to use the Filter by Form functionality with to create a

Wholesale Rolex Yacht-Master Watches Replica - Fake Rolex Yacht-Master
Watch Wholesale
Wholesale Replica Watches : http://www.wholesale-watches.org/
Wholesale Rolex Watches Brands : http://www.wholesale-watches.org/rolex-watches.html

Wholesale Rado Coupole Watches Replica - Fake Rado Coupole Watch
Wholesale
Wholesale Replica Watches : http://www.wholesale-watches.org/
Wholesale Rado Watches Brands : http://www.wholesale-watches.org/rado-watches.html

I try to transfer PO data from SQL Server into my MS Access
Application.
The following SQL works fine:
SELECT * INTO purchase_headers FROM [ODBC;DRIVER=SQL

I'm having an issue with Tony's Auto FE Updater I was hoping someone
could help with. I need to use UNC instead of mapped drive letters her
in this shop drive letters are mapped differently for different people
and therefore I can not use drive letters in desktop shortcuts. Using

Is it possible to back up the data.mdb file when the user exits the
executable (.mde)?  How would I do that?  And also perform a compact
and repair on exit.
The code and data are in separated into data.mdb and code.mde.  

Hello.  I need to search 6 different fields for a key word.  The way I
normally query data is in a single field with the critera: Like '*' &
[ENTER Keyword] & '*'.  Is there a way to enter only 1 key word but
display the records that contains that word in any of the 6 fields?

The short version;
In short, given one date range (start and end dates) how can I find the
period that overlaps with another date range?
The long version;

I have a table with a string field that can store numeric field. How do I
make a query to compare this field with a numeric value.
Example:
Select * from table1 where field1="condition" and field2>1000

Somebody knows how to disable the combobox button in Access 2002.
I want to prevent the list be displayed.
Thanks.