I have noticed that if you right click on a hyperlink field and edit
the hyperlink, you can set it to be an email address and open up
Outlook when it is clicked.
I have been trying to set this up the same way at runtime, but I

A fairly recent convert to Access I have succeeded in getting it to work
well on my current fairly simple requirements.
Can someone help me with another step?
I have three simple reports.

I need to set Access to use my local folder, and not my 'My Docs'
folder which is in a netwrok drive.
I did the setting thru' options, but when I logged in again, it was
pointing to 'My Docs' folder.

I have searched the groups and read ALOT of threads about the subject.
Though I have not found a single thread who has the answer on how to
exctract pdf's stored in an Access db to regular pdf's stored on disk.
I have successfully exctracted .doc, .xls and .ppt using the

I have a mailing list with multiple names going to the same addresses.
I need one address with all the names for that address on it. I checked
out the example on microsoft's site, but A: It doesn't work (error that
there is an extra parenthise (sp?) ) and B: Will only let in two ...

we have an Access 2003 app that is running just fine on several
thousand computers all over North America.  Recently, on ONE in
particular, we suddenly started see a startup error, something like:
"Unable to load JPEG.  Image too large.  Try a BMP of GIF format

I am trying to do some conditional formatting with a textbox and I am
not able to quite get it.
Here is the setup:
  My record includes a textbox called [Due_Date] and two checkboxes

I have created a SQL string the properly inserts a record in the table.
However, the insert does not occur at the end of the table.  Instead
it inserts a record after the last record that I viewed.  This would be
OK, except it assigns a autonumber to be one greater than the last

I am creating an application that will need to share data, to exist on a
company's intranet, and to be used by 50+ users.  The sharing consists of
only added data. Each user  will be able to see, but not change, data
entered by one of the other users.  The transaction volume is ...

One can view the SQL statremtn fora qry, can one view the SQL for a
pivot table in Access?
Am I missing it somewhere?
Jerry

I am building a database to track the maintenance records on a fleet
of cars.  I need to run a report on that will display data based on
whether a box is checked or not (i.e. all cars that have the oil
change box checked, or a report that shows all cars and lists all the

I have two tables, one consists of company info like name and phone
number.
Another table where I have to fill in the contact persons. Part of the
form is to choose the company he works for (From a list box). Then,

Hi, I have trouble setting up an access database on a wan because I am  using
dial up which charges per minute.  How can I get the database to be sharred
across miles with much stability and lower cost.  I have read all the wan
posting but still does not apply to my situation. Is ...

How can I program a command button on a form to bring up the standard "Find
and Replace" dialog on click?
Separate but related: how do you run menu commands (e.g. "Edit" "Find") from
VB?

I'm a newbie to Access and programming.
I used the wizard to create a command button to go to next record on a
form.The following is the code:
Private Sub Command135_Click()