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 Chris Miller 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. lakers8176

    TransferText - Import file has multiple periods

    It's a 80mb file that is in a central directory and I don't want to premanently rename it. I tried to use the Copy command and it takes forever to copy across our WAN. I can't believe that VB and Access can't handle a file with multiple .'s in it.
  2. lakers8176

    TransferText - Import file has multiple periods

    Access 2003...I am attempting to import a file into access using the TransferText function but I receive a Runtime Error 3011, MS Jet db engine could not find the file. The file I am looking to import is named "wws070o.la.071016.003100.txt" (the numbers are a date and time stamp that will...
  3. lakers8176

    Pass Variable to Form Text Box in VB

    I don't insist on a macro solution. I am stating that, currently, this function is called by a macro. Does it matter how the function is called? The function PickFile works exactly how I want it to. I would just like the varFile variable to be passed a text box within my PickFile function...
  4. lakers8176

    Pass Variable to Form Text Box in VB

    The PickFile function is called from a macro.
  5. lakers8176

    Pass Variable to Form Text Box in VB

    I have a variable defined in my vb code and I would like to pass that variable to a text box on a form. I'm not sure how to go about doing that. Here is the code that I am currently using. I would like to pass the varFile. Function PickFile() Dim fDialog As Office.FileDialog Dim varFile As...
  6. lakers8176

    Windows ME "Safe Mode"

    I have installed Cisco VPN 3.6.3 on my home PC (running Windows ME) and when I boot up I have to choose Safe Mode to boot into Windows. I uninstall VPN and the PC boots fine. Is this a known issue? My company's Helpdesk has no clue. Thanks....
  7. lakers8176

    Variable Excel Macro

    My users are telling me that the macro to do this was origianlly in Lotus. A number of years ago they converted over to Excel 97 and it worked just fine. Now that we have moved up to Excel XP that macro doesn't work. That's why I'm under the impression that a macro can be be created to do...
  8. lakers8176

    Variable Excel Macro

    I don't use macros or VBA very often, but I need to create a macro in Excel XP. I need to start on a random cell, key in data, tab over two cells, key in data, tab over two cells, key in data, then go back to the cell I started in and go down four rows. I would like to have the macro wait for...

Part and Inventory Search

Back
Top