By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,222 Members | 1,095 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,222 IT Pros & Developers. It's quick & easy.

Go To Specific Record Via Shortcut

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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.