473,396 Members | 2,036 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Create a link to an Access DB - opened to specific form and record.

Scenario: Access DB sits on a network drive (available to all users by simple path) When a user creates a new test, they press a button and it creates an email with some information that is sent to another group.

What I need it to do: In that email, I need to create a link that will take the user (reading the email) to that access Db and have it open to a specific form and record based on the link. Essentially, how would one pass a command like:

Expand|Select|Wrap|Line Numbers
  1.  DoCmd.OpenForm Forms!FormName
to a DB using a hyperlink?

Thanks for your help.
Oct 14 '11 #1

✓ answered by NeoPa

You may find some helpful tips in Invoking a Database From the Command Line on how to start a database from a command line. How you design the database to handle opening a specific form within the database is not covered directly but there is stuff in there that shows how it could be managed.

Do what you can with that and come back with specific questions if you have any.

1 2845
NeoPa
32,556 Expert Mod 16PB
You may find some helpful tips in Invoking a Database From the Command Line on how to start a database from a command line. How you design the database to handle opening a specific form within the database is not covered directly but there is stuff in there that shows how it could be managed.

Do what you can with that and come back with specific questions if you have any.
Oct 14 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: intl04 | last post by:
How do I create a data input form in Access that is external to the Access database to which it's connected (if that's possible, which I believe it is)? For example, if someone clicks on an Access...
3
by: Phil | last post by:
I am looking to set up a hyperlink control on a form to retrieve letters that correspond to a record on a form. That is, there may be 100 form records, and I would like each of those form records...
1
by: John Michael | last post by:
I have created some password routines to protect certain forms from access without a password. This allows me to create some security for apps that will be used on diff machines for users that...
0
by: mstanley71 | last post by:
Hi All, I have a problem, I'm using Access 2002 SP3. and am trying to use a button on each form to link back to a hyperlink on a table based on a combo box selection on the same form record..ie...
16
by: usenet | last post by:
I want to be able to use the record numbers of a sub-form, are they available anyhow in VB (Access 2003)? I want to use the sub-form record number as *part* of the primary key for the table...
4
by: gary.cobden | last post by:
Hi I have a form/subform where a new record is created on the subform by a button click. After the new record is created, I then need to go directly and display the new record in the subform....
3
emandel
by: emandel | last post by:
I am an armature access programmer trying my best to design my own database so your patience and detailed instructions is much appreciated. Here is my question: How do I get a command button (on...
3
by: SM | last post by:
Hello, Im trying to access elements in my XML file using the JavaScript DOM but i'm not sure how. I use AJAX to access the XML and then use the responseXML property to access the XML file data. I...
3
by: Derbin | last post by:
Hi All, I just located a discussion that Stephen posted back in January and Baz was responding; I actually have the same issue as Stephen. The specific need is for a Document Management Tool, you...
1
by: thread | last post by:
Hi i built a form that getting dynamic SQL string,the SQL string is placed in the record source when the form is opened. i notice when trying to reduce some proccess time from the form that it...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.