Hello, I'm trying to retrieve a value from a particular sheet and cell in an
existing spreadhsheet which has 3 worksheets.  My current code is as
follows...
Dim objXL As Object

I have 261 table that are linked.
When I do maintenance on my db, I use a local copy.  In the linked table
manager, I see all the linked tables.
When I implement my changes to the server, I copy my local copy of the db to

I want to send email with 2 report attachments. My coding is below. The
problem I have is this coding only attaches the first report. How do I add in
the 2nd report into the coding. I only want one email sent with both reports
attached.

Is there a way for me, using the sendobject command, to send an email to a
"group" using lotus notes?

I'm trying to allow the user to load another file by using the following
code, but I get type miss match on the first line.
  Do While VbMsgBoxResult = vbYes
   With Application.FileDialog(msoFileDialogFilePicker)

Can anyone tell me how to create a switchboard in Access so that when the
database is opened the form opens automatically instead of the usual page
which has the table names etc....
Thank you

I would like to display what  database a table is linked to using code.  What
is the easiest way of doing that?

Is there anyway of finding orphaned code behind forms and reports.
ie. Control was named txtDesc with various code attached to events.
Control was changed to a combo box and renamed to cboDesc.
All of the original code still refers to txtDesc.

Hi again,
In a listbox, I have the Column Heads property set to Yes. How do I get the
table column names to display vertical rather than horizontal?

I have a listbox on a form that holds about 53 columns. How do I
"progammatically" fit each column width to the width of the data coming in
with out manually setting them in the COlumnWidths property?
Currently I have the ColumnWidths property the looks like this:

I'm getting all kinds of nonsense in this linked workbook. Text fields are
showing 0's for several rows, and #NUM! where there should be text. Other
text fields are showing text for several rows and #NUM! where there are 0's
in the linked excel spreadsheet.

I have created a form in Access 2002 when the user clicks on either of the
buttons on the form which both open new pagesi would like the page to close.
i looked at the coding attached to the button and this is what it read.
Private Sub Enter_pg1_Click()

I am using MS Access 2003. Sysinfo reports the versions as follows:
Access: 11.6566.8132 SP2
Jet 2.0:  4.00.7328.0
Jet 3.0:  4.00.6508.0

I have the same problem that Mike has on a previous post. My code quits Excel
on the screen but leaves Excel running in the Task Manager. My project is to
transfer an Access Table to Excel and convert it to a Pivot Table. To do this
each time

how can i be able to use tab key to indent entry instead of going next field
thank you in advance