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

    navigating websites through VBA

    I'll experiment with it. thank you. that may be causing the problems as well? I had no idea..
  2. dick606

    navigating websites through VBA

    here is a snippet of my code:set ie = createobject("internetexplorer.application") ie.navigate me.website while ie.busy do events wend ie.document.forms(me.formnumber).item("username") = me.username ie.document.forms(me.formnumber).item("password") = me.password...
  3. dick606

    Opening Multiple Files in Vista MS DOS

    I think this has something to do with me having multiple versions of excel on my machine. This will work for me:q: cd DIR start excel.exe "file1" "file2"But get this...ONLY IN THE DOS PROMPT. If I write the same thing in the text editor and save it as a BAT file, only the first file will open...
  4. dick606

    Opening Multiple Files in Vista MS DOS

    Here is my batch file: Q: cd DIRECTORY "FILE 1" "FILE 2" "FILE 3" "FILE 4" "FILE 5" "FILE 5" "FILE 5" "FILE 6" i AM GETTING the first file to open in excel, but the rest of them will not open. It will freeze on the first one, and not open the next one in the list until I close excel first...
  5. dick606

    Navigating IE through the DOS prompt

    thank you for all the replies. I will try them all, but I'm afraid I'm already ahead of most of them. sorry! and thanks for the help once again you guys.
  6. dick606

    Navigating IE through the DOS prompt

    Hi Folks. Here is some code to navigate automatically through IE in Visual Basic:Function FillGoogle() Dim ie As Object Set ie = CreateObject("internetexplorer.application") ie.Navigate "http://www.google.com" ie.Visible = True While ie.busy DoEvents 'wait until IE is done...
  7. dick606

    VB timer problem

    I would assume you can assign a variable to part of the image name as an integer, and then loop them. say for example you have 3 pictures, then name them: pic1 pic2 pic3 then maybe write something like this with the on timer event: dim i as integer timerinterval = 500 i = 1...
  8. dick606

    SaveAs file dialog and filters

    I wonder if you could just popup an input box and get the user to input the name of the file they want in that? That way, you could assign the file extension yourself and not even let them know that you are doing it. Take it out of their hands. That is one way to do it I suppose, which is the...
  9. dick606

    Filter with If then else statement does not work

    puppy, you do not need a filter to do this. All you need in your subform is an SQL statement with a WHERE clause in it as your recordsource, and then one line of code when you select the combo value. Like this:SELECT [whatever] FROM table WHERE [state] = forms!mainformname!comboname;Then...

Part and Inventory Search

Back
Top