Modules & VBA :: Setting Hyperlink To Open Different Forms / Reports Dynamically?

Oct 18, 2014

I am trying to add a feature in my database dashboard that shows a list of hyperlinks that are the most frequently used forms and reports based upon the user. I can figure out how to capture the event each time the form or report is opened and update a record to increase the count, and build a recordset that will query the table filtering by user and order by frequency...

However, I am stuck on building the hyperlinks that will point to the correct form or reports dynamically.

Specifically, I am not able to update the subaddress using VBA. I get an error that the hyperlink cannot follow to the new form...

Here is my code:

Code:
Private Sub Form_Load()
Dim strUser As String
Dim strApp As String
strUser = Environ("username")
strApp = "frmTest1"
Me.txtUser = strUser
Me.txtLink3 = strApp
Me.txtLink1 = strApp
Me.hypTest.Hyperlink.SubAddress = strApp
End Sub

View Replies


ADVERTISEMENT

Forms :: Dynamically Setting Recordsource For A Form

Mar 25, 2014

I currently have a Job Management System where the Customer Order Form displays all jobs via a main form and an order details subform. This form is used for inputting new jobs and for viewing existing jobs via links from other reports such as a job schedule or customer orders report. It is always reached via a clicking of a "New Customer Order" Button where the form is filtered to new record or via double clicking on an order number in another screen and filtered via the order number.

I am now in a position where the database is growing too large and I want to archive the data in the Orders / OrderDetails Tables into Financial Years and put them in a separate backend database. However the jobs will still need to be viewed via the customer order form in order for them to be duplicated the following year.

I have created a union query of the PreviousFY and Current Orders to allow the "search jobs by customer" query to work. This works fine, but I now need to make the record source of the Customer Order form dynamic.

I have created a CurrentFY query to feed the form if it is a current job and a PrevFY query if it's from the previous FY.

I have written code to check the OrderDate against the financial year to work out which database the job is from and set recordsource according to that result. This is currently in the OnCurrent event as I also have other code there that checks details of the order to determine if fields should be editable.

However I am finding that when I parse the order data between the forms the "new record" command or the order number is not being retained or checked. If this because I don't have a recordsource set when it opens?

I tried setting the recordsource as the currentFY on open and then do the check but that didn't work.

View 1 Replies View Related

Reports :: Can't Open Report In Preview If Opened By Hyperlink

Sep 11, 2014

I have a report that will open by clicking a hyperlink and I want it to open in preview mode.

I tried using:

"DoCmd.RunCommand (acCmdPrintPreview)" or "Report.CurrentView = 5"

in the On Open event but, no success, I only get an error message.

View 1 Replies View Related

Modules & VBA :: Creating Hyperlink On A Button To Open Up A Webpage

Jan 17, 2014

I am trying to create a button that opens up a webpage. I get how to create a hyperlink on a button. The problem is, I need to open a specific page depending on the information in a text box.

The text box displays the tracking number for the current record. That number is populated automatically via a control source. The problem is that I need to open different web pages depending on the tracking number displayed. For example, UPS has a specific start to their number (1ZX....). Other trucking companies have a specific format, also.

So how do I tell it to look at the tracking number and then open the corresponding web page?

View 2 Replies View Related

Modules & VBA :: Email Hyperlink / Attachment To Open Access File?

May 15, 2015

I have created an action log database that sends an email when a new action is entered. I would like to launch the database using a hyperlink in the email, but can't seem to get it to work. All users have a copy of the front end on their desktop, so whatever I add to the email needs to launch the front end for any user signed on to their own desktop.

This is what I have and it sends a hyperlink but I click it, I get an error saying it can't find the file. I don't know how to word the path name for any user?

With obMsg
.subject = "New action request for " & team
.To = people

[Code].....

View 14 Replies View Related

Forms :: Use A Hyperlink To Open A Folder Within A Specific Directory

Nov 26, 2014

I have 3 attachment boxes in my table that appears in a form.each attachment box contains specific files (not specific as in extension such as PDF, JPEG, etc.) but specific as in Company Documents, Certifications, Resumes. The issue is there's a lot of document and I see my database growing (fast)...My question finally is....

Can I use a Hyperlink to open a folder within a specific directory where multiple file are located so i can open the specific file need there RATHER than attaching them in the attachment box individually?.?.....If not how this can be done (no SQL) unless that route is very simple and basic coding.

My thinking would be to place the file path to the documents in the table and hyper link that column in the table, but not knowing exactly how Hyperlinks work I don't think it would actually work..

View 6 Replies View Related

Forms :: Create Hyperlink To Open Access Form

Jul 10, 2015

I am investigating on the possibility of setting up an approval process for our employee intake procedure by using MS Access and Outlook.

The idea is for the requester to open an intake form in Access and fill in the new employee's information and send an Outlook email to the manager for approval. I know how to trigger off an event on the form to send an email to the manager but my challenge is how to create a hyperlink in the email for the recipient to directly open the intake form with the specific record, without the need to open the database and find the specific intake form.

The intake form is built in a frontend .mde file on a shared drive where all users have access to.

View 14 Replies View Related

Setting A Filter On Dynamically Created Table?

Apr 23, 2015

I am currently working on a Database to automatize some process.

The User can import a CSV (Text) File via a DialogBox, which gets imported into a Table. After this, the content has to be filtered, setting conditions on 4 different rows. The new Table gets exported into a new CSV (It has to be CSV, since it later gets imported into SAP)

How can I set a Filter on a dynamically created Table (using VBA)?

Best case would be to save the filter into my Import spec, but Access doesn't seem to have this option (?)

View 3 Replies View Related

Modules & VBA :: Setting Filter Property Via On Open Event Of A Report

Dec 15, 2014

I have a report, on a control tab, on a main form.

On the form are two buttons: one to show all items, and one to filter them based on a boolean field called showitem.

The buttons work with the code below.

What I want to do but cannot seem to figure out is to have the report default to no filter.

The bound query has no criteria.

I'm trying to set the filter property via the on open or on load event and even if I isolate the report, cannot seem to reach it.

Code:
Private Sub b_hide_items_Click()
Me.Profile_Timeline_wNotes_subreport.Report.Filter = "timeline.showItem <> 1"
Me.Profile_Timeline_wNotes_subreport.Report.FilterOn = True
Me.Profile_Timeline_wNotes_subreport.Requery
End Sub

Private Sub b_show_all_Click()
Me.Profile_Timeline_wNotes_subreport.Report.Filter = "timeline.showItem = 0"
Me.Profile_Timeline_wNotes_subreport.Report.FilterOn = False
Me.Profile_Timeline_wNotes_subreport.Requery
End Sub

View 14 Replies View Related

Modules & VBA :: Bulk Update Of Hyperlink Text To Display Not Hyperlink

May 29, 2014

i have thousands of data records with hyperlinks that are correct. Each data record shows the actual link (google.com, foxnews.com, espn.com, etc.). However, i want to change all of the records to just say "link" instead of saying espn.com, etc. How can i do this automatically without having to manually right click, edit, and changing the text to display?

View 6 Replies View Related

Hyperlink To Open PDF

Sep 16, 2005

I have a form with a textbox on it that is populated with the path of a pdf doc associated to the form. How do i get the pdf to open when i click on the path?

thanks..

View 3 Replies View Related

Hyperlink To Open Doc.

Dec 14, 2006

I have the following code to open a specific file:
Private Sub OpenDoc_Click()
FollowHypelink "C:Documents.......
End Sub
The name of the file is written in the code, for every record on my form I have a different file to open so I have a field called "DOCN" wich is the name of the file I have to open. How can I put a extension on the code to read the file name mentioned in the field on my form?
Thanks
Marco

View 2 Replies View Related

Hyperlink To Open Access?

Jun 6, 2007

Is it possible?
I want a link that can be put in a mail (to someone in our network) and clicked. It should open Access on a specific database and I should be able to use parameters (like /cmd and /wrkgrp).
I'm lost... :confused:

View 7 Replies View Related

Access Dynamically Reports Related Topic

Oct 14, 2005

Hi.
Is there a way to set the record source of a textbox control from an access report to something else then a field from a table or query ? I didn't found one.
I wanna to display in a report some processed and parsed data from a memo field (the processing and parsing is done in a function from a module). In the report, I wan't to display this data, BUT can't, because the only dinamically value that can be changed to a textbox is record source (I cannot change it's value when the reports opens), and the data processed isn't stored anywhere in a table ... so ... I'm stuck. I've also tried to display the data in report in a label (not in a textbox) and dynamically resize the label, but at some point, I riched the maximum label height :((

Is there a way to do this ???

Thanks,
Mihai.

View 1 Replies View Related

Reports And Changing Labels On Form Dynamically

Nov 24, 2004

I have created a report to display a bill of materials (boms). The report works as I have designed. I have also figured out how to filter the report using the docmd.openreport vbasic call with filters. This works fine. I use a form to select the filtering I need in the form of 2 Listboxes populated from tables. The form opens, the report generates and displays in preview mode. What I cannot do is the change the title text (Text Label on the report Header). I would like to use the selected items in the listboxes as sources of text for these controls on the report so I can use the report over and over for different boms. ANy help would be greatly appreciated! Vbasic I hope!

View 1 Replies View Related

Reports :: Dynamically Resize Text Box And Keep Them In Line

Apr 15, 2014

I am creating a database and need to produce a report that will form an itemised quotation.There can be up to 8 items on the quotation along with their associated costs to the customer. I am trying to make the "item" field dynamically expand if necessary when longer text is entered into it and then expand the corresponding "Totals" fields to match the new size.I have tried using the "Can Grow" property however for some reason the formatting does not cascade down to the fields below and the "Totals" fields remain the same size.

To try and explain better I have included a screen shot of the relevant part of the report and how it looks when printed. I should point out that the "QuotesQuote" box at the top of the screen is set to "Can Grow" and when that expands the boxes below automatically move to accommodate this.

View 2 Replies View Related

Hyperlink String Does Not Open File

Oct 14, 2013

I have a table has two fields: CompanyLocation , FileName

I have a form that uses and unbound field to create a file path string

="file:///s:/My Folders/" & [CompanyLocation] & "/" & [FileName]

In the form it looks like file:///s:/My Folders/My Company One/This Is My File.doc

I then set this to hyperlink in the form but when i click on it nothing happens.

When i copy the link it gives me and paste it into Windows Explorer it works fine.

View 7 Replies View Related

Creating A Hyperlink To Open A PDF File?

Jan 22, 2014

I have a form, and on that form I have a textbox called RefDwgNo (user not allowed to make changes...just for viewing). Displayed in this textbox is the name of a file (without the .pdf extension). I changed the textbox to 'is hyperlink' and added to OnClick- this code:

Private Sub RefDwgNo_Click()
FollowHyperlink "***private***engineering_data***Private***Des ignFitoutLabel Plate\_LATEST REV"
End Sub

The user needs to actually open the .pdf file, not the folder its located in. How do I add the file name from this textbox to the code above?

View 10 Replies View Related

Hyperlink In Form Will Not Open Outlook

Nov 16, 2012

I have a form linking to information in a query, and simply shows some client information. one thing the form shows is the clients email. from the query i can click on the email (hyperlink) and outlook opens a blank email with the clients email already inserted. how do i get the form to do the same?

View 1 Replies View Related

How Do You Fill A Reports Detail Section Dynamically In Access2000

Feb 12, 2008

Hi,

I want a user to click the report, and an input box appears asking for a product number. This product number is used in a recordset (VBA code in the report) to fill the text boxes in the Detail section.

Code:Private Sub Report_Open(Cancel As Integer)Dim rst As DAO.RecordsetDim db As DAO.DatabaseDim itemCode As StringSet db = CurrentDb()itemCode = InputBox("Enter the Item Number", "Complete Catlog Prices")Set rst = CurrentDb.OpenRecordset("SELECT * FROM [Catalog Prices Complete] WHERE Prefixprodno = '" & itemCode & "'", dbOpenDynaset)Do Until rst.EOF Me!txtCat = rst("Volume") 'error 02448 cannot assign to this 'Me!txtPrice = rst("Price") rst.MoveNextLooprst.CloseEnd Sub

I'm sure my text box is called txtCat though. Is it an array I should try to fill? If so, any suggestions :S

Thanks,

View 3 Replies View Related

Reports :: Dynamically Change Text To Time Period

Jul 13, 2015

Could I change my unbound textbox (txtperiod) on the Report to display the time period.i.e.

Weekly, Monthly, Quarterly

Criteria is BeginDate and EndDate on main form.

View 1 Replies View Related

Reports :: Dynamically Include Columns Based On Check Box

May 28, 2013

I have a report with many columns in the detail listing data, and their associated titles above in the page header.What I would like to accomplish is the ability for the user to check boxes off on a form which will remove/add specific columns to the report. The form will essentially be a "build your report" style, with a button on it opening the print preview of the custom report.

Im assuming this is accomplished by the "on load" part of the form through VBA. How is the sizing handled? If the user un-check's a box to remove a column of data, how is the header and detail data "moved over" or re-arranged to accomplish a relatively decent looking layout? Any example or example code to deal with one column/setup (which I can copy and modified)??

View 4 Replies View Related

Command Button Open Up Hyperlink From A Recordset

Jan 3, 2005

Hello all, I hope your hollidays were great!!

Ok I have a Continuous form that in one of it's fields contains Hyperlinks. The form is named [Song Info] and the field is [Play].
I want this field to be hidden and have a command button open up the hyperlink in that recordset. I think that all the info need
but if not let me know.



Thanks
Rich M

View 11 Replies View Related

Use Hyperlink To Open Form Based On Value In The Field?

Jun 12, 2014

I have a continuous form that lists all unapproved invoices. I would like to have a hyperlink at the end of each row that says Review and will open another form that queries the details of the unapproved invoice based on the invoice number in the current row.

View 9 Replies View Related

Reports :: Setting Filters - Updating On Multiple Sub Reports?

Apr 26, 2015

I have created a report which contains within it multiple sub-reports, which I use to generate a document for management meetings on a bi-weekly basis.

For each of these I have the subreports filtered to a unique number for consideration that period e.g. LIKE "88/00039" which relates to my data.

In order to change this I have to manually update each of the filter commands within the subreports but I assume there must be an easier 'catch-all' method of achieving this?

Ideally I'd be looking for a command prompt so I could enter just the number sequence e.g. "88/00040" and then enter this (via a corresponding macro or similar) to update the filter commands.

View 2 Replies View Related

Reports :: Dynamically Sort Report That Already Has Group By (XP / Access 2003)

Jun 28, 2013

I must use XP/Access 2003 to solve this problem for reasons I won't get into.

I have a report with a Group by on City.

The users need to be able to sort by Coordinator within that OR by Client Name based on a selection they make on the form that opens the report.

-- I have tried to set .OrderBy

-- I have tried to set .RecordSource to different queries with order by hardcoded in them (I only have 2 sort options fortunately)

Is there a way to dynamically change the "Sorting and Grouping" defined in the report? This seems to be the only sorting that the report is responding to.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved