Hyperlink to open access?
- Thread starter Hydex
- Start date
- Local time
- Today, 05:41
- Joined
- Feb 28, 2001
- Messages
- 30,310
I'm not even sure this is possible as a hyperlink. However, if you use URL/URS path styling (as opposed to drive letter path styling), you could create an ICON file that links over a network to a specific database and includes the options you want in the icon's properties.
Create a shortcut icon to your database. Right-click on the icon to bring up the drop-down action menu. Click Properties. Select the Shortcut tab. Now edit the Target: field in the icon to use the URL/URS format for everything. NO DRIVE LETTERS - unless, for example, you know that ALL intended users map to the same drive in the same way.
Two wrinkles: Access will be on each user's C drive. The shortcut icon will want to start Access from a folder on that drive. If you want to include the command line options, you cannot omit the reference to Access itself (or at least I think you can't.) The workgroup file's reference will ALSO have to be either URS or predefined in some other way such as being on the shared drive.
OK, once the icon works, sent it as an attachment to the desired users. I have serious doubts about a hyperlink, but we have used icons through e-mail many times with pretty good success.
Create a shortcut icon to your database. Right-click on the icon to bring up the drop-down action menu. Click Properties. Select the Shortcut tab. Now edit the Target: field in the icon to use the URL/URS format for everything. NO DRIVE LETTERS - unless, for example, you know that ALL intended users map to the same drive in the same way.
Two wrinkles: Access will be on each user's C drive. The shortcut icon will want to start Access from a folder on that drive. If you want to include the command line options, you cannot omit the reference to Access itself (or at least I think you can't.) The workgroup file's reference will ALSO have to be either URS or predefined in some other way such as being on the shared drive.
OK, once the icon works, sent it as an attachment to the desired users. I have serious doubts about a hyperlink, but we have used icons through e-mail many times with pretty good success.
boblarson
Smeghead
- Local time
- Today, 03:41
- Joined
- Jan 12, 2001
- Messages
- 32,059
Unless an alternate installation was chosen to stick it on D: or some other internal drive.
Is it possible to create these icons dynamically and attach them to a mail?
for instance if I put a /cmd A_10000 in my target, Access opens the form A on the 10000th record. This works if I manually create a shortcut.
But can Access do the same, then send them with an email (through Outlook). All with vba code ?
for instance if I put a /cmd A_10000 in my target, Access opens the form A on the 10000th record. This works if I manually create a shortcut.
But can Access do the same, then send them with an email (through Outlook). All with vba code ?
boblarson
Smeghead
- Local time
- Today, 03:41
- Joined
- Jan 12, 2001
- Messages
- 32,059
Just so you know - 100000th record really means nothing to Access. Access doesn't really store data in the tables in any meaningful order, with the exception that if you have an indexed key and the database is compacted it will be ordered by that index but with records being added and deleted it soon will not be. Access really doesn't care what order the records are stored in and it is false to assume that you can access a certain record based on the order in which it was entered.
I'm sure that The_Doc_Man will chime in on this and actually make sense of my drivel as I have a hard time explaining this.
I'm sure that The_Doc_Man will chime in on this and actually make sense of my drivel as I have a hard time explaining this.
Nah, This is not the problem, my CheckCommandLine does this :
Divide the command entered (with a left/right, as I know the number of letters possible), then if the first part is A, check the second part. Then do an OpenForm A with the second part as argument. I use this in my OpenArgs in my form_open. Or at least, it should work (I'm still coding).
But I'm wondering how I can send an icon by mail. I have a function which creates a mail and send it to a number of people. For instance, as an hyperlink seems impossible, I want that when someone click on button B in form A on the 1000th record, Access creates an icon with the command parameter in it (like /cmd A_1000), then attach it to the mail which will be sent using the function above, so that when they reecive it, they just have to click on the icon to open access on form A, 1000th record.
Divide the command entered (with a left/right, as I know the number of letters possible), then if the first part is A, check the second part. Then do an OpenForm A with the second part as argument. I use this in my OpenArgs in my form_open. Or at least, it should work (I'm still coding).
But I'm wondering how I can send an icon by mail. I have a function which creates a mail and send it to a number of people. For instance, as an hyperlink seems impossible, I want that when someone click on button B in form A on the 1000th record, Access creates an icon with the command parameter in it (like /cmd A_1000), then attach it to the mail which will be sent using the function above, so that when they reecive it, they just have to click on the icon to open access on form A, 1000th record.
- Local time
- Today, 05:41
- Joined
- Feb 28, 2001
- Messages
- 30,310
The only way I could see this working for opening to a different record for each user is to include your /CMD option at the end of the Target: element in the icon file (.ico file). But that requires you to be able to EDIT the Target: element of the icon. Which means you need a utility that CAN edit the target.
Offhand, I don't know of any utility that does this in batch mode. If you had any third-pary icon editor program AND it supported the Component Object Model method of doing things, you MIGHT get this to work. But I've never seen a utility that would do this. (Not that I've looked, you understand...)
The last icon editor I ever bothered with was for Windows 3.1, at which time Access 2.0 was the greatest thing since sliced bread for PC home use. (And even then, it wasn't THAT great of an icon editor...)
Offhand, I don't know of any utility that does this in batch mode. If you had any third-pary icon editor program AND it supported the Component Object Model method of doing things, you MIGHT get this to work. But I've never seen a utility that would do this. (Not that I've looked, you understand...)
The last icon editor I ever bothered with was for Windows 3.1, at which time Access 2.0 was the greatest thing since sliced bread for PC home use. (And even then, it wasn't THAT great of an icon editor...)
