Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft access and groupwise

Forum home » Delegate support and help forum » Microsoft Access Training and help » Microsoft Access and Groupwise

Microsoft Access and Groupwise

ResolvedVersion 2003

Nicola has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course

Microsoft Access and Groupwise

Does Access automatically connect to Groupwise (my companies choice of email account) from a hyperlink?

RE: Microsoft Access and Groupwise

Hi Nicola, thanks for the query. The short answer is yes. Your internal email client should be set up to capture hyperlinked email address. In Access, you need to set the data type of the field to hyperlink and you may need to alter the url to read:

mailto: youremail@address

The table should display the hyperlinked email address and when clicked on it should open up an instance of Groupwise with the email address in the "To:" field. Try it out and let me know how you get on.

Hope this helps,

Anthony

Thu 17 Dec 2009: Automatically marked as resolved.

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.