Results 1 to 10 of 10
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using forms on websites in conjunction with Access (2000)

    I want to run a search on a website from within access and then bring
    the resulting data back to access. I have two straightforward
    questions:
    1. Is this possible?
    2. If so, how?

    I need to fill in a form on a site (which does not belong to me) then
    "submit" the form and somehow tell access to take the data which comes
    back and use it to update a table in the db.

    Thanks in advance for any help any of you can give.

    M

  2. #2
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using forms on websites in conjunction with Access (2000)

    You can use the WebBrowser control (on the Tools menu click on the additional tools button and scroll down to "Microsoft Web Browser").

    This control allows you to access the web a page, enter data and submit forms.

  3. #3
    New Lounger
    Join Date
    Jun 2002
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using forms on websites in conjunction with Access (2000)

    Sounds great but it isn't on my tools menu. In fact, I don't have "additional tools". I'll search the MS download site but have I missed something?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Using forms on websites in conjunction with Access (2000)

    Cpod must have meant the Toolbox. The last button is "Additional controls".
    Attached Images Attached Images

  5. #5
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using forms on websites in conjunction with Access (2000)

    Yes, HansV is correct. I did mean to say the Toolbox not Tools on the menu. Sorry for the the error.

  6. #6
    New Lounger
    Join Date
    Jun 2002
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using forms on websites in conjunction with Access (2000)

    Thanks for the clarification.
    Now I have it but I'm still clueless about what to do with it. Where can I get a tutorial or some details on the functionality and use of this?

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Using forms on websites in conjunction with Access (2000)

    Try and download the Developer Solutions database (Solutions9.mdb) here. The Access 97 version contained two demos of the browser control. Perhaps the Access 2000 version still has them.

  8. #8
    New Lounger
    Join Date
    Jun 2002
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using forms on websites in conjunction with Access (2000)

    Okay, there's a really great reference section on the MS site which those of you who are interested can see here: MSDN WebBrowser Reference

    The trouble is, now that I have looked through lots of this material I'm beginning to think it's not what I need! My original question was not specific enough I now realise. The form filling in is to be done behind the scenes and not via a browser interface. The plan is to bring up a simple Access form with a couple of search criteria. I then want these to be entered into the correct fields on a website and 'submitted'. This search will return results which then need to be brought back into Access to be directly (and automatically - i.e. not by the user) entered into a table.

    Now I can ask again! Can it be done?

  9. #9
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using forms on websites in conjunction with Access (2000)

    Yes, you can do this. I'm not saying it's easy but it can be done.

    Essentially, the webbrowser control (through the Document property) exposes the webpage HTML, and by changing elements of the page (through code), you can enter data into textboxes on webpage forms and submit those forms. The data returned can then be downloaded. All this done automatically without user action. I've done this in Excel but it should also work in Access.

    You would need to have knowledge of Visual Basic for Applications and some knowledge of HTML would be helpful.

    This is not documented very well (at least I never found much on the subject). I learned by trail,error and dumb luck.

  10. #10
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Using forms on websites in conjunction with Access (2000)

    Do you want to do something along the lines of Data Access Pages. These in fact are Access forms (in HTML) which are aligned to an Access database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •