This doesn't make sense to me. Can you explain futher. Records don't automatically dissappear regardless if they are fields storing hyperlinks or not. Typically you store your hyperlinks into a field in a table. If records dissappear after clicking the hyperlink, you've got bigger issues.
or to open a webpage example:
Dim objXMLHTTP, xml
Set xml = Nothing
Set xml = CreateObject("Microsoft.XMLHTTP")
xml.Open "POST", URLAddress, False
There are also other ways you can utilize a hyperlink with parameters: for example (passing parameters to google to display a map):
If IsNull(Me!Address1) Or IsNull(Me!City) Or IsNull(Me!State) Then
MsgBox "You must first enter the Address, City, and State!"
Dim dAddr As Variant
Dim Addr As Variant
Dim SAddr As Variant
Select Case Me!CenterID
dAddr = "1930+Monroe+St+Madison+WI+(The+Monroe+Building+Su ite+200)"
dAddr = "+848+N+12th+Milwaukee+WI+(Parking+Garage+Entrance )"
'SAddr = Addr1 & "+" & Addr2 & "+" & City & "+" & State
SAddr = Me!Address1 & "+" & Me!City & "+" & Me!State
'SAddr = Replace(Addr, " ", "+") & "+"
strurl = "http://maps.google.com/maps?f=d&hl=en&geocode=&saddr=" & SAddr & "&daddr=" & dAddr & "&pw=2"
Also for example (to utilize the shell command to shell to a folder - not web related but thought I'd throw this in):
You can utilize the Shell command if needed to shell to a folder in windows explorer - for example only: Shell "C:\WINDOWS\explorer.exe """ & Me!ExportFolderName & "", vbNormalFocus
Last edited by pkstormy; 11-24-09 at 00:51.
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)