In many procedures I  use the Set statement to set a variable MyDb to
DBEngine,Workspaces(0).Databases(0)
Example
In Module 1

I'm using Form and a subform control within that form. Main form is
getting data from one table(Buildings) and subform is getting data from
another table(BldgDataByFloor). but both the form and subform are
linked through a child field which is common in both the

I've read that the message argument in SendObject allows a max of 255
characters. Is this correct? If so, doesn't this render SendObject severely
restricted as a way to send emails from Access?
Regards,

This is my situation:
Backend: Oracle 8i
Frontend: MS Access 2k (ODBC driver support LOBs)
Q: How insert (upload) a CLOB (pdf or doc file) to an Oracle using MS

I have a report that I want to print for a product specification sheet
with a photo of the product. I have the photos stored in a separate
folder from my Access 2000 database. I have a form that when I choose a
product all the info for that product appears on the form

I am Access newbie looking for some guidance in putting together a
query that can output a table of max values in a given column grouped
by a couple of other columns. Here is an example of what I need the
query to do.

Ok...I'll first describe briefly what I've done.
Working from a paper form with over 200 fields - broken into 10 areas, I
created a database with 10 tables. I then created a form using those 10
tables, created queries and then reports based on those queries.  All works

Dear NG - I'm very new to Access and reports are completely foreign to
me.  I was hoping that I could get some general guidance on how to
proceed with the following:
I've got a form (8.5x11") that is completed by the deer hunter when

I'm working with joins, and i have made this DB
http://www.blackend.dk/061302_Elementlist.mdb
Problem is my T_Signals tabel. For every input, i need to link to
ElementID (In T_ELEMENTS) and TypeTemplateID (In T_TYEPTEMPLATES).

I'm trying to set up a contact list in MS Access 97.  I've looked
through a reference book and the program's help screens, but the light
bulb isn't quite coming on for me.  If one of you could take the time
to answer two very elementary questions, I'd appreciate it.

I've produced an Access application for a client. For one report, text
gets cut-off at the right margin when we print the report. It does this
only when we print; it doesn't happen when we view the report in
preview mode. Also, it occurs only at the client site; it doesn't occur

I'm working on a .NET project and I need a single query to return a
result set from three related tables in Access 2003, and I'm having
trouble getting the results I want.
The details:

When I enter a date in the textbox on my subform, such as
11/22/30...expecting the textbox to show the date 11/22/2030...instead
the date 11/22/1930 shows?! Why?
I checked the table for the specifics regarding this date field and

I am a comeback database developer using MS Access (last time was 1998).  I
kindly ask for your recommendation of a good book(s)  that can be used as
Jump starter, and reference.  (more than one book is OK)..
Thanks

I have a problem with recordset/SQL statement.  The following is the code.
Private Sub Command1_Click()
Dim SqlQuery As String
Dim RcdSet As Recordset