Go Back   Access World Forums > Microsoft Access Discussion > Theory and practice of database design

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-10-2018, 05:03 PM   #1
Diamond-Leopard
Newly Registered User
 
Join Date: Oct 2018
Posts: 26
Thanks: 9
Thanked 0 Times in 0 Posts
Diamond-Leopard is on a distinguished road
Question Creating A Hyperlink When Editing A Query

So I sell things online and send them to all my customers. So when an order is placed I have set up a form to collect all the sales information. A few days later I get an email with the Tracking Code from Hermes or DPD or whichever courier I use.

When this information comes in I have created a Form with a Button Called "Add Tracking Information" and I have this button running a query for all existing orders which don't currently have Tracking Codes.

I am then able to add the tracking code into the design view Tracking Query which amends the order record and that's all gravy.

About 4 days Later I would like to go back into run a query with all orders which are not yet delievered and I know how to do that... but what I would like is a link I can click to take me to "parcelsapp.com/en/tracking/(INSERT TRACKING CODE HERE)" and that link will show me if the parcel has been delievered and I can update the order status.

So basically here is what I want...

When I type in a reference code into the 'Tracking Reference Code' Field I would like the 'Tracking Link' Field to auto populate with the correct hyperlink so I can click it in a couple days and Check the status.

In excell it is this >>

If('Tracking Reference Code Cell' ="","",Concatenate("parcelsapp.com/en/tracking/,'Tracking[/url] Code Cell')

So if the cell is empty then it does nothing... however if there is a tracking code it pops the code at the end of the link to create a clickable hyperlink to a page which shows me the delievery status.

I have done many hours of looking and I have found something like

IFF "Tracking_Reference_Code" is not null then "Tracking Link" = "parcelsapp.com/en/tracking/" & "Tracking_Reference_Code"

That is a pure guess based on all the pages I've been on to look for this.. but to be honest even if this code is correct I am not entirely sure where to put it ... I only want the record to be edited when I run the "Add Tracking" query and it shows me all the records not currently being tracked and then only when I paste the Tracking Reference Code ( Something like RY0845845CN) into the correct field, which then autopopulates another field to be a clickable link.

Phew... That was a long explanation.... Thank you if you read that far and thank you even more if you have the answer. I'm sure it's something simple but I am such an Access virgin I am really struggling lol

Anywho... Thanks in advance. x

Diamond-Leopard is offline   Reply With Quote
Old 11-11-2018, 05:48 AM   #2
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 9,293
Thanks: 105
Thanked 2,492 Times in 2,288 Posts
isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all
Re: Creating A Hyperlink When Editing A Query

Try adding this as a new query column
Code:
Tracking_Link:IIf(Nz("Tracking_Reference_Code","")<>"","parcelsapp.com/en/tracking/" & "Tracking_Reference_Code","")
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 11-11-2018, 07:21 AM   #3
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 2,732
Thanks: 33
Thanked 652 Times in 635 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Creating A Hyperlink When Editing A Query

Hi,

You could also try it this way.

Tracking_Link: "https://www.parcelsapp.com/en/tracking/" + Tracking_Reference_Code

However, if you are viewing this in a query, I am not sure if it will be clickable. If not, you might have to view it in a form.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 11-18-2018, 09:37 AM   #4
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,568
Thanks: 13
Thanked 1,458 Times in 1,389 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Creating A Hyperlink When Editing A Query

You need to use a form. Queries do not have events. In the double- click event of the control that holds the path, use the FollowHyperlink method (intellisense will help you build it).

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Tags
access , order , status , tracking , update

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Editing Hyperlink field access7 Forms 14 12-04-2013 05:41 PM
creating and editing record in the same form ga11ardo Forms 1 11-28-2007 12:42 AM
Creating/Editing Tables yeatmanj Modules & VBA 10 10-12-2006 12:34 PM
Creating a hyperlink davesmith202 General 2 06-07-2006 04:41 AM
Editing hyperlink field DAW Tables 1 04-06-2006 06:35 AM




All times are GMT -8. The time now is 03:40 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World