Hey guys. This is probably an easy question for you access programmers but I have no idea what to do. I am trying to make a pretty simple database in access 2007 that will allow me to add new employees to a database from a form that I have made. This form is pretty simple and has fields that ask for their first name, last name, etc. Once I save their information to the back end table, I want to find a way to create a "hyperlink" of some sort so that when I click someone's first name, their record would show up in the form again so I can make edits and change anything I need to. This "hyperlink" can be seen in action in many of the default databases that access 2007 comes with such as the Faculty database. I am assuming this "link" will need some code embedded into it. I have no idea how to code or anything like that since I am pretty new to access and a newbie. Any suggestions would be greatly appreciated. I also have tried searching the forum but I have not had any luck with this.
How to open records in form view
- Thread starter Boweezie
- Start date
the_net_2.0
Banned
- Local time
- Today, 15:24
- Joined
- Sep 6, 2010
- Messages
- 812
Bow,
You simply have Access confused with web-based technologies.
As simple as someone can say, every single database window object in Access is the same exact thing. Are you familiar with scripting languages? For instance, machine language is low level, then you have assembly language, etc, etc, etc...until you get all the way up to visual basic and stuff like that, which literally translates english sentences into machine code boolean values.
Access is the same way, basically. Tables are at the bottom, followed by queries, forms, then reports. They are all the same thing. The difference between the low levels and higher levels is the display properties and interface look that has been written into the program's source code.
does that make sense?
In other words, Forms and reports are tables. That's really all they are. And what MS did, is they wrote objects like properties into those object so they were integrated, which makes them look like different objects, literally. I like to call forms and reports different displays for tables, which they are, to a competent programmer's mind.
so if you want to add data to your database file via a form, all you have to do is use the wizard to create a form based on a table that already exists. That will automatically create the link between the table and form that is necessary for your form to accept data and append it to the table, just as you want to do.
Hyperlinks in Access are, for all practical purposes in your case, irrelevant. And further more, so is the term "link". It really has no place in Access, unless of course you have another program's lingo on the brain.
There are literally no "link" objects present in Access.
You simply have Access confused with web-based technologies.
As simple as someone can say, every single database window object in Access is the same exact thing. Are you familiar with scripting languages? For instance, machine language is low level, then you have assembly language, etc, etc, etc...until you get all the way up to visual basic and stuff like that, which literally translates english sentences into machine code boolean values.
Access is the same way, basically. Tables are at the bottom, followed by queries, forms, then reports. They are all the same thing. The difference between the low levels and higher levels is the display properties and interface look that has been written into the program's source code.
does that make sense?
In other words, Forms and reports are tables. That's really all they are. And what MS did, is they wrote objects like properties into those object so they were integrated, which makes them look like different objects, literally. I like to call forms and reports different displays for tables, which they are, to a competent programmer's mind.
so if you want to add data to your database file via a form, all you have to do is use the wizard to create a form based on a table that already exists. That will automatically create the link between the table and form that is necessary for your form to accept data and append it to the table, just as you want to do.
Hyperlinks in Access are, for all practical purposes in your case, irrelevant. And further more, so is the term "link". It really has no place in Access, unless of course you have another program's lingo on the brain.
There are literally no "link" objects present in Access.Hey Net 2.0,
Thanks for your reply and I am somewhat beginning to understand what you are talking about. But I think if I give you a screenshot, you would probably understand exactly what I am trying to ask. Here are a couple of screenshots that I have attached with this:
img340.imageshack.us/i/afterclick.png/
After I click one of the blue highlighted numbers from the Faculty List form, all of that employees' information will pop up in the Faculty Details form like this:
img340.imageshack.us/img340/2010/afterclick.png
This is what I am trying to do. I would like to be able to click on one of my employees' name and have all their information pop back up in form view.
I clicked on the property sheet for this "ID" field in layout view and saw that there was an embedded procedure under the Event tab "On Click". It is a macro and it looks pretty complicated. I have tried messing with this macro in my database but it does not work seamlessly. So I hope this clarification helps.
Thanks for your reply and I am somewhat beginning to understand what you are talking about. But I think if I give you a screenshot, you would probably understand exactly what I am trying to ask. Here are a couple of screenshots that I have attached with this:
img340.imageshack.us/i/afterclick.png/
After I click one of the blue highlighted numbers from the Faculty List form, all of that employees' information will pop up in the Faculty Details form like this:
img340.imageshack.us/img340/2010/afterclick.png
This is what I am trying to do. I would like to be able to click on one of my employees' name and have all their information pop back up in form view.
I clicked on the property sheet for this "ID" field in layout view and saw that there was an embedded procedure under the Event tab "On Click". It is a macro and it looks pretty complicated. I have tried messing with this macro in my database but it does not work seamlessly. So I hope this clarification helps.
Hey guys. I just wanted to let you guys know that I was able to figure out a solution to this. The problem was that I needed some VB code that I was able to find in many of the access templates. Although it doesn't do exactly what I want, it gets the job done so far. Anyways, thanks for your help guys.
darkstar257
Registered User.
- Local time
- Today, 13:24
- Joined
- Jan 6, 2011
- Messages
- 77
The way I was able to do this was by opening the default Faculty Template that comes with Access 2007. I opened this database and made about 3 fictitious names and entered random information about them. I did this by opening the Faculty Details form and just made up some random names along with their information and saved them.
Once this was done, the names appear in the Faculty Details form and if you notice, the first column named "ID" is highlighted as if it were a hyperlink. And if you click the one of the ID numbers, it will pop up the Faculty Details form along with all the information that was entered, which was exactly what I wanted to do in the first place.
So, after poking around and trying to figure out how this link was created, I figured out that in the Faculty List form, in layout or design view, if you select the one of the ID's, and go in the property sheet under the event tab, you will see that there is an embedded procedure On Click. This embedded procedure is a macro which I cant paste because for some odd reason it won't let me (probably because I am slow at things).
Now that I had this figured out, I copied the exact same macro and pasted into my own form under the ID column and tried to replicate the Faculty Template with some minor alterations. Like I said, this isn't exactly what I wanted to do, but this definitely works and let's me create a link from one form to another in different views.
I hope this clarifies what I did. I like to be as detailed as possible so a lot of things that I did were are common sense, but for someone that is completely new, they would definitely be extremely confused.
Once this was done, the names appear in the Faculty Details form and if you notice, the first column named "ID" is highlighted as if it were a hyperlink. And if you click the one of the ID numbers, it will pop up the Faculty Details form along with all the information that was entered, which was exactly what I wanted to do in the first place.
So, after poking around and trying to figure out how this link was created, I figured out that in the Faculty List form, in layout or design view, if you select the one of the ID's, and go in the property sheet under the event tab, you will see that there is an embedded procedure On Click. This embedded procedure is a macro which I cant paste because for some odd reason it won't let me (probably because I am slow at things).
Now that I had this figured out, I copied the exact same macro and pasted into my own form under the ID column and tried to replicate the Faculty Template with some minor alterations. Like I said, this isn't exactly what I wanted to do, but this definitely works and let's me create a link from one form to another in different views.
I hope this clarifies what I did. I like to be as detailed as possible so a lot of things that I did were are common sense, but for someone that is completely new, they would definitely be extremely confused.
