I have a few queries which are transfered to an existing spreadsheet. Within
the spreadsheet, I have written code to reformat depending on the data which
is transfered.  Is there a way to run this module from Access directly after
my transferspreadsheet commands?

on my front page i have /body in yellow background also like a musical treble
cleff .could you please tell me how to get these off when typing

Is there any way to get information about a
OLE Object in a table besides clicking on it
to see what it is.  I would like to get the name
of the file that was imported or the name of the

Has anyone used this program (Wall Street Office) and make it talk to a ms
Access database. I need to put a mess load of info into the system and I need
to get a mess load of data out of Wall Street Office.
Thanks

I have a list box based on the value list of a subdirectory of a directory on
a network drive.  I seek to open the file (pdf, doc, xls) with
followhyperlink but keep getting the Runtime Error no matter what the method.
My preference is to build a string from a) the network drive ...

Thank you so much for this group, it is wonderful. As someone who
helps other, I�m always looking for great information and I can�t wait
to share this one to my contact.Thanks!--------------------------------
Henry Diaz ---business mlm network marketing

I have a MS Access 2003 application and the users need the ability to design
their own reports. I have 3 popup, modal forms...frm_main_menu,
frm_administration and frm_reports. On the frm_reports form I have a command
button with the following code:

I need to create a simple database to track the rentals of audio equipment:
12 Categories like Mixer, Cd Player, microphones
Several items per category, like Shure mic, Carvin Mike,
Quantity of items - 3,5

We use Office 2003 and Excel has that ~65k row limitation.
I have a table with 1 million rows of data.
Does anyone have code that can export the data to a new workbook and add 50k
rows to each worksheet until there no more data to export?

I'm looping every form and each control in it.
Then I'm looping the properties collection of the control.
Through code, I would like to know if a property of a control in a form is
an event one, or format or data or others (I need event properties only).

I am thinking about creating a document library database to store important
legal documents scanned in adobe pdf format. The project raises a number of
issues.
1) I want a form in Access to handle the upload. The user will browse to the

It looks like due to the way Access 2003 does early binding, it fails to
work with the same class library if the latter is upgraded, even though the
new version is properly registered. The solution is in late binding wherever
possible.

Own a small business you want people to know about? Got a service you
can offer? or got something to sell?
I created a NEW forum just for people to:
Buy/sell/trade their used items, promote their business, post events,

I'm encountering this message when trying to open a Word template from within
Access:  "The OpenDataSource method or property is not available because
preview mode is active."
I've been working this same code for about five years now, but never saw

I need to write a procedure to e-mail an open report thru Access.  I have the
following code that works except for the attachment.  I need to find a way to
attach the open report instead of the file "E:\Access\Accounts.rtf."
Function ap_CreateOLEMailItem()