I'm hoping someone can help me troubleshoot this problem. I have a form using a text box linking to a URL within another table. I have no problem launching a browser when clicking on the text box but the browser window opens behind the Access window. I've looked into the app.Activate function...
I have the following working, the link opens and the Internet Explorer window activates but I receive a runtime error 424 object required - Any suggestions.
Private Sub SchedNoSubItem_Click()
Application.FollowHyperlink (HyperlinkPart(Me.[tblURLs.URL]))
InternetExplorerApplication.Activate...
Thanks. The FollowHyperlink works, but the path has a "# in the front and behind the path. I know this is related to the setup of the hyperlink field.
How do I call out the address only to get rid of the "#?
I also get a warning message about "hyperlinks can be harmful etc". How do I stop the...
I have a form generated by query using a text both with an expression which is a combination of two fields. I want to give the user the ability to click on the text and go to a url. The urls are stored in a another table.
tbl1
schedno
URL
qry (tbl2)
expr [schedno][subitem]
I just don't know...
Stix4t2,
This is truly a standalone, we are providing a tool using Access and distributing it but sharing support on the network isn't supported, regrettably.
Something tells me in the long run the code solution is better but my skill set and time contraints say I want the easier Access stuff...
stix4t2,
Here are the answers to your questions. It is a all in one db and we will be distributing the database rather than sharing it.
Just some additional information. Tbl1 has 161 records tbl2 has 532 with the many-to-many relationship 599 and tbl3 (one-to-many between tble2 and 3) has...
Stix4t2,
I think this would actually work for me, if I'm envisioning it right and have the skills to program it. Can you guide me a little on how you use the listbox selections to "build filters" for the subform?
Thanks so much!
Sherri
stix4t2,
Possibly, I'm not sure I follow all of it or know enough to do this. I've tried something similar to this I have the table But when you say build a subform the show the table what would be the main table? Also, a number of my records have the same titles which need to be suppressed if...
I need help suggestions for the best development approach for a form. The database is loaded with a master set of records. Tbl1 contains a master "record filing structure" related to tbl2, a set of "record schedules" (note many-to-many) each schedule then has separate possible dispositions tble3...
I don't have a response to your question exactly but... I was browsing this site trying to find a thread with a solution to the type of problem you seem to have started to solve. I am trying to develope the same type of code that you appear to have figured out, that would make the changes to my...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.