If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Database Reports - display and access
We have used hyperlinks up until the switch from Access 97 to Access 2003 to
access our documents/reports from inside the database. Access 2003 doesn't seem to want that to happen. When we edit hyperlinks, we cannot browse inside the database as we once could to link to the report. IF we can do that, will someone explain how...please. If not, I need to know how to display a form with selected reports that can be accessed by clicking on the report name. Beyond that, how can I create a second form (side by side) that allows users to set criteria for that report such as start/end date, only open records or closed records, etc? If someone has a way to help me, it would be very much appreciated. Thank you. Bob |
#2
|
|||
|
|||
Database Reports - display and access
Hi Bob,
if you create a command button on the form, you still can set the hyperlink property to a database object. -- Kind regards Noëlla "Bob Waggoner" wrote: We have used hyperlinks up until the switch from Access 97 to Access 2003 to access our documents/reports from inside the database. Access 2003 doesn't seem to want that to happen. When we edit hyperlinks, we cannot browse inside the database as we once could to link to the report. IF we can do that, will someone explain how...please. If not, I need to know how to display a form with selected reports that can be accessed by clicking on the report name. Beyond that, how can I create a second form (side by side) that allows users to set criteria for that report such as start/end date, only open records or closed records, etc? If someone has a way to help me, it would be very much appreciated. Thank you. Bob |
#3
|
|||
|
|||
Database Reports - display and access
Noella - right now, we have a table that records the quality information
about the document - date created, title, number, etc. There is a field for a hyperlink to the document. In this way, I don't have to create 150 command buttons to the reports in the database. I can use the hyperlink to open them - and we can link the table to another Access database that allows users access to those documents as well. I need to know how to create a form that accesses reports - or how to get the hyperlink dialogue box to link to internal reports. Bob "NG" wrote: Hi Bob, if you create a command button on the form, you still can set the hyperlink property to a database object. -- Kind regards Noëlla "Bob Waggoner" wrote: We have used hyperlinks up until the switch from Access 97 to Access 2003 to access our documents/reports from inside the database. Access 2003 doesn't seem to want that to happen. When we edit hyperlinks, we cannot browse inside the database as we once could to link to the report. IF we can do that, will someone explain how...please. If not, I need to know how to display a form with selected reports that can be accessed by clicking on the report name. Beyond that, how can I create a second form (side by side) that allows users to set criteria for that report such as start/end date, only open records or closed records, etc? If someone has a way to help me, it would be very much appreciated. Thank you. Bob |
#4
|
|||
|
|||
Database Reports - display and access
Hi Bob,
in the form, show the hyperlink in a text box. To edit the link,, right click on the hyperlink field and choose the Menu Hyperlink - Edit Hyperlink -- Kind regards Noëlla "Bob Waggoner" wrote: Noella - right now, we have a table that records the quality information about the document - date created, title, number, etc. There is a field for a hyperlink to the document. In this way, I don't have to create 150 command buttons to the reports in the database. I can use the hyperlink to open them - and we can link the table to another Access database that allows users access to those documents as well. I need to know how to create a form that accesses reports - or how to get the hyperlink dialogue box to link to internal reports. Bob "NG" wrote: Hi Bob, if you create a command button on the form, you still can set the hyperlink property to a database object. -- Kind regards Noëlla "Bob Waggoner" wrote: We have used hyperlinks up until the switch from Access 97 to Access 2003 to access our documents/reports from inside the database. Access 2003 doesn't seem to want that to happen. When we edit hyperlinks, we cannot browse inside the database as we once could to link to the report. IF we can do that, will someone explain how...please. If not, I need to know how to display a form with selected reports that can be accessed by clicking on the report name. Beyond that, how can I create a second form (side by side) that allows users to set criteria for that report such as start/end date, only open records or closed records, etc? If someone has a way to help me, it would be very much appreciated. Thank you. Bob |
#5
|
|||
|
|||
Database Reports - display and access
The popup dialogue box doesn't show browsing inside the database. It only has
the following: Left side: Existing file or web page; Create New Page; and E-mail Address. Inside that, below LOOK IN it has: Current Folder; Browsed Pages; and Recent Files. At the top it has: Text to Display and Screen tip. The look in combo lets you browse outside of the database. The current folder - if you select the database, only hyperlinks to the database, but not to a form or report inside the database. That's the part that is no longer available. Do I need to re-install Access 2003 with a particular wizard or is it just Access 2003? "NG" wrote: Hi Bob, in the form, show the hyperlink in a text box. To edit the link,, right click on the hyperlink field and choose the Menu Hyperlink - Edit Hyperlink -- Kind regards Noëlla "Bob Waggoner" wrote: Noella - right now, we have a table that records the quality information about the document - date created, title, number, etc. There is a field for a hyperlink to the document. In this way, I don't have to create 150 command buttons to the reports in the database. I can use the hyperlink to open them - and we can link the table to another Access database that allows users access to those documents as well. I need to know how to create a form that accesses reports - or how to get the hyperlink dialogue box to link to internal reports. Bob "NG" wrote: Hi Bob, if you create a command button on the form, you still can set the hyperlink property to a database object. -- Kind regards Noëlla "Bob Waggoner" wrote: We have used hyperlinks up until the switch from Access 97 to Access 2003 to access our documents/reports from inside the database. Access 2003 doesn't seem to want that to happen. When we edit hyperlinks, we cannot browse inside the database as we once could to link to the report. IF we can do that, will someone explain how...please. If not, I need to know how to display a form with selected reports that can be accessed by clicking on the report name. Beyond that, how can I create a second form (side by side) that allows users to set criteria for that report such as start/end date, only open records or closed records, etc? If someone has a way to help me, it would be very much appreciated. Thank you. Bob |
Thread Tools | |
Display Modes | |
|
|