469,277 Members | 2,062 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,277 developers. It's quick & easy.

Go To Specific Record Via Shortcut

Is there a way to create a shortcut to open a MS Acccess DB and have it
go to a specific record?

In my DB, when a user delegates a record to another users, I currently
send out an email to the personing saying they been delegated to
followup on an item.

I list the reference number, but was thinking that it would be really
cool if I could attach a shortcut in the email that would go to the
record.

TIA.

Oct 11 '06 #1
4 2728
On 11 Oct 2006 03:40:39 -0700, "BerkshireGuy" <bd*****@yahoo.com>
wrote:

Sure. Use the /x command line argument to run a macro of your choice.
For example you could write a macro that calls a VBA function that
finds out who's logged in, looks up in a special table what ID value
to go to for that user, and opens the form to that value.

-Tom.

>Is there a way to create a shortcut to open a MS Acccess DB and have it
go to a specific record?

In my DB, when a user delegates a record to another users, I currently
send out an email to the personing saying they been delegated to
followup on an item.

I list the reference number, but was thinking that it would be really
cool if I could attach a shortcut in the email that would go to the
record.

TIA.
Oct 11 '06 #2
Tom:

Thank you. I was hoping to pass the reference number via the command
line since a user can have many records. I want to be able to go to a
specific record, not a set of records.

Any ideas?
Tom van Stiphout wrote:
On 11 Oct 2006 03:40:39 -0700, "BerkshireGuy" <bd*****@yahoo.com>
wrote:

Sure. Use the /x command line argument to run a macro of your choice.
For example you could write a macro that calls a VBA function that
finds out who's logged in, looks up in a special table what ID value
to go to for that user, and opens the form to that value.

-Tom.

Is there a way to create a shortcut to open a MS Acccess DB and have it
go to a specific record?

In my DB, when a user delegates a record to another users, I currently
send out an email to the personing saying they been delegated to
followup on an item.

I list the reference number, but was thinking that it would be really
cool if I could attach a shortcut in the email that would go to the
record.

TIA.
Oct 11 '06 #3
On 11 Oct 2006 09:31:20 -0700, "BerkshireGuy" <bd*****@yahoo.com>
wrote:

You can use the Command function to retrieve the entire command line.

However, I think I would still use a table in the back-end, which
would indicate which primary key value the form should jump to when
the special /x macro executes.

-Tom.

>Tom:

Thank you. I was hoping to pass the reference number via the command
line since a user can have many records. I want to be able to go to a
specific record, not a set of records.

Any ideas?
Tom van Stiphout wrote:
>On 11 Oct 2006 03:40:39 -0700, "BerkshireGuy" <bd*****@yahoo.com>
wrote:

Sure. Use the /x command line argument to run a macro of your choice.
For example you could write a macro that calls a VBA function that
finds out who's logged in, looks up in a special table what ID value
to go to for that user, and opens the form to that value.

-Tom.

>Is there a way to create a shortcut to open a MS Acccess DB and have it
go to a specific record?

In my DB, when a user delegates a record to another users, I currently
send out an email to the personing saying they been delegated to
followup on an item.

I list the reference number, but was thinking that it would be really
cool if I could attach a shortcut in the email that would go to the
record.

TIA.
Oct 12 '06 #4
But more than one user may go in it. So how would the macro know who
is coming in?
Tom van Stiphout wrote:
On 11 Oct 2006 09:31:20 -0700, "BerkshireGuy" <bd*****@yahoo.com>
wrote:

You can use the Command function to retrieve the entire command line.

However, I think I would still use a table in the back-end, which
would indicate which primary key value the form should jump to when
the special /x macro executes.

-Tom.

Tom:

Thank you. I was hoping to pass the reference number via the command
line since a user can have many records. I want to be able to go to a
specific record, not a set of records.

Any ideas?
Tom van Stiphout wrote:
On 11 Oct 2006 03:40:39 -0700, "BerkshireGuy" <bd*****@yahoo.com>
wrote:

Sure. Use the /x command line argument to run a macro of your choice.
For example you could write a macro that calls a VBA function that
finds out who's logged in, looks up in a special table what ID value
to go to for that user, and opens the form to that value.

-Tom.
Is there a way to create a shortcut to open a MS Acccess DB and have it
go to a specific record?

In my DB, when a user delegates a record to another users, I currently
send out an email to the personing saying they been delegated to
followup on an item.

I list the reference number, but was thinking that it would be really
cool if I could attach a shortcut in the email that would go to the
record.

TIA.
Oct 13 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Salad | last post: by
reply views Thread by Marcel | last post: by
4 posts views Thread by I_AM_DON_AND_YOU? | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.