Hello,
I'am hoping someone in this forum can help me. I having some trouble with the syntax below.
I am using MS Access 2010 and I have a form which generates an email through using Outlook.Application. When I outlook generates the email and I click on the Link the website indicates it cannot find the tracking number: TrackingNumber. It appears that the syntax is pulling in the Name field instead of the actual tracking number for the control source from the MS Access form.
Does anyone have idea on what I am missing here. I have tried different variants referencing the name field such as:
=(trackingnumber)
=trackingnumber
strBody = strBody & "<a href=[TrackingNumber]>Track Here" & "</a>"
Any help you can provide is appreciative.
I'am hoping someone in this forum can help me. I having some trouble with the syntax below.
I am using MS Access 2010 and I have a form which generates an email through using Outlook.Application. When I outlook generates the email and I click on the Link the website indicates it cannot find the tracking number: TrackingNumber. It appears that the syntax is pulling in the Name field instead of the actual tracking number for the control source from the MS Access form.
Does anyone have idea on what I am missing here. I have tried different variants referencing the name field such as:
=(trackingnumber)
=trackingnumber
strBody = strBody & "<a href=[TrackingNumber]>Track Here" & "</a>"
Any help you can provide is appreciative.