Search results

  1. J

    Newbie looking for help with button linking to website:

    The email issue is something else. I have another table for coaches and Athletic Directors that I will need to link there email address to a button. I will deal with latter. I just hope I can learn more by then. I need to spend some time learning more of the coding end of this.
  2. J

    Newbie looking for help with button linking to website:

    What was going on was I first tried doing this on the subform linking to tblwebsite. Couldn't get it to work so created the test form, but made the mistake of using existing data that was hyperlink where the subform was URL. The subform is what I was trying to get setup, Test Form is just that...
  3. J

    Newbie looking for help with button linking to website:

    We have a winner. This works on my "frmWeb_Sub" but not on "frmTest" I'm guessing that is because web-sub is using a URL and Test is using hyperlinks. This will work because I haven't commented to using one or the other. Recently I posted the question as to use hyperlink's or URL's and most...
  4. J

    Newbie looking for help with button linking to website:

    Unfortunately that won't work. in the test form with the 3 fields it might. but for the website form each line will be a different line and will vary for each entry.
  5. J

    Newbie looking for help with button linking to website:

    I looked at this and tried it. changed the "Links=cmbLinks" to "Command6" when I ran it got an error Run-Time error '438': Object dosn't support this property or method
  6. J

    Newbie looking for help with button linking to website:

    Thank you for this, I will look at this in the morning. I have been looking at my screen for 12 hours and my eyes are really tired. Maybe my mind will be more clear then too. I haven't spent this much time at the computer sense I retired.
  7. J

    Newbie looking for help with button linking to website:

    Not sure what you mean by post your code, but here is a stripped down copy of my DB. The "frmTest" is what I have been working on. The "frmWeb_Sub" is close to what the end result will look like. I thank everyone for there help.
  8. J

    Newbie looking for help with button linking to website:

    I need to get this correct because the end result will have 18-20 hyperlinks or URL's for each school and there are 150 schools. I can use either a hyperlink or the URL in a text field. But just getting frustrated, that I cannot make it work. Just wish when I found the YouTube Video I would have...
  9. J

    Newbie looking for help with button linking to website:

    I am not real sure I understand what you are saying. [Location] should be listed as something else? I was able to get one link to work but 2 others follow the same link.
  10. J

    Newbie looking for help with button linking to website:

    Not sure what I did different, but am now able to click button and go to google map for the hyperlink. However I have 2 other websites on 2 different fields, and they also go to the google map, and not the hyperlink that they should go to. I am not seeing where the button is connecting to the...
  11. J

    Newbie looking for help with button linking to website:

    Most likely my stupidity. I am getting a "Run-time error '2465': School Sports Database can't find the field 'I1' referred to in your expression. Private Sub Command6_Click() Application.FollowHyperlink [Location] End Sub I added what you marked above, I still get the same error, but...
  12. J

    Newbie looking for help with button linking to website:

    I am looking for a YouTube video on how to set up a button to open either a hyperlink or website. Can find a bunch of videos on adding hyperlinks and buttons but nothing linking one to the other. I have done it once but now cannot figure out how I did it of find the video I watched to do it...
  13. J

    Hyperlink or URL In Table and Forms

    Not sure if this should be here in "Tables" or "Forms" but here goes. DB I'm creating will have quite a number of web addresses, and will be sorted by "Team Type" Sport Type" Gender Type" and "Level Type" (ie: Varsity, JV, Freshman) These will be in a table. Would I be better off storing as a...
  14. J

    Hide Selected table rows in a form combobox

    I downloaded then extracted to a folder then opened in Access. Had to close the popup window to be able to click the trust. then I can click one of the three options. Once it opens the form I can right click to open in Design View. other than that I cannot do anything else. Jim:
  15. J

    Hide Selected table rows in a form combobox

    I must be missing something, when I open the demo DB I am able to get to the Design View but am not able to click on anything. All I get is the windows chime. What I downloaded is "theDBguySortReOrderDemoV1.1.accdb" am I doing something wrong? Yes my table has a sort order field. Jim:
  16. J

    Hide Selected table rows in a form combobox

    The second or middle example is close to what I am trying to get to. Now the question is how to go about it. I am still very early in the learning curve. Jim:
  17. J

    Hide Selected table rows in a form combobox

    Screen shot of one of my forms. For each school there will be 1 and as many as 18-20 depending on how many sports teams each school has. More if I start adding JV and Freshman teams. I would like the ability to change the sort number if needed. Jim:
  18. J

    Hide Selected table rows in a form combobox

    Good point, I am wanting to add this mostly as an exercise. I may not really need it but want to learn how. Thank You Jim:
  19. J

    Hide Selected table rows in a form combobox

    I will start by checking your website. That will be tomorrow, right now I'm having problems focusing on the screen. In the event I need to post a screenshot, just what would you need to see? the form? Thank You Jim:
  20. J

    Hide Selected table rows in a form combobox

    I have a similar problem I haven't spent a lot of time on yet, but I think it will be an answer close to this one. I have a few forms that have up to 19 web addresses for the same contact. I have added a field for order sort. Am I going to need to create an event? If so would it be "After...
Top Bottom