Search results

  1. S

    What is the best way to get data from website

    Not that I'm aware of, but pleny of references out there if you google something like vba webbrowser.Document
  2. S

    What is the best way to get data from website

    You know I've never had the need to hide mine before, your right you can't set visible to false without an error. So I have reworked it a little and am re-posting it, hopefully the correct way. What we have now is two forms, one contains the web control and is a sub form on the main form. The...
  3. S

    What is the best way to get data from website

    Your welcome, glad I could help.
  4. S

    What is the best way to get data from website

    I have put together a very quick and nasty access2000 db for you to have a look at. It has one form that contains a web control, a button, some text boxes for the data to be placed in and a country list (Although the list is limited to Australia and United States only you could easily add more)...
  5. S

    Else Without If error

    If the program quits if the first rule is found to be true then you don't really need the else statement, just test for the second rule afterwards if the program has not quit. Private Sub Form_Timer() [FrmDashBoard].Requery [FrmDashBoard2].Requery If Time() > #11:30:00 PM# And...
  6. S

    update table based on radio buttons

    If you absolutly must use radio buttons then the answer would depend on how you want the data saved. You mention you want A1 in the location column if the user selects A1. If they also select A2 do you expect A1,A2 to be in the location column or would you expect a separate row for each...
  7. S

    Fixing a csv File Before Importing Data

    vbaInet, if OP means original poster then it would be nice if the OP also posted what the data should look like at the end. boblarson. I open the csv files with notepad and not excel, the user does not need excel to run this, and the quotes appear to remain within the second file. It does...
  8. S

    Fixing a csv File Before Importing Data

    Forgive me if this is not correct, or not the correct way to do this, it is my first time posting. This should help you grab the text from your original csv, allow you to manipulate it, then save it back to a different csv, it works in access2000. Very messy though as I have borrowed bits and...
  9. S

    Morning All

    Hello all. I have, from time to time, gained some great tips from some great questions and answers from this forum and as such figured it was only fitting to become a member. Our organisation will be changing from Access2000 to Access2010 over the next 12 months so I'm sure I will need the...
Back
Top Bottom