Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Sherri726

    Active application window problem

    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...
  2. Sherri726

    app.Activate - 424 error

    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...
  3. Sherri726

    Need to Hyperlink to URL from form query

    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...
  4. Sherri726

    Need to Hyperlink to URL from form query

    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...
  5. Sherri726

    Subform development - Selecting a subset of the database

    Thanks stix4t2, I will give it a try and let you know how it goes. Sherri
  6. Sherri726

    Subform development - Selecting a subset of the database

    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...
  7. Sherri726

    Subform development - Selecting a subset of the database

    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...
  8. Sherri726

    Subform development - Selecting a subset of the database

    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
  9. Sherri726

    Subform development - Selecting a subset of the database

    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...
  10. Sherri726

    Subform development - Selecting a subset of the database

    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...
  11. Sherri726

    Continuous Form as a SubForm Problems

    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...

Part and Inventory Search

Back
Top