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 gkittelson 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. NoBugs

    Access locks up (not responding)

    No I have; however, I did update all the sevice packs for Access 2000 on Monday, but the problem is still happening. I'll re-install Access tomorrow to see if that helps.
  2. NoBugs

    Access locks up (not responding)

    What causes Access 2000 to just lock up after you modify code, or doing some copy and paste functions. I'm thinking maybe My memory (1 gbyte) runs low or something. I have to kill Access with the task manager to shut it down. Once the program locks up there must be a flag set because I can't...
  3. NoBugs

    Does as400 support sql stored procedures

    I need help in setting up a procedure in an access program to execute IBM as/400 (Client Access data transfer .dtt script) from the PC (Excel files) to the IBM as/400 library.
  4. NoBugs

    exporting a table from access to excel

    Could someone give me the syntax for exporting the results from a access2000 query to an excel sheet and drop the header row in the process. I'm have to delete the header row manually. Thanks in advance, Troy
  5. NoBugs

    WHAT CODE SHOULD I USE TO FIND RECORD IN VBA CODE

    How do I setup a macro to export part of an Access table based on a query to an Excel format? I'm trying to use records modified on a laptop out in the field to update an AS/400 data base on a weekly process. I will be transfering the Excell file(through data transfer--Client access) to a...
  6. NoBugs

    WHAT CODE SHOULD I USE TO FIND RECORD IN VBA CODE

    I NEED SOME CODE EXAMPLES TO SEARCH THE DB FOR A PARTICULAR RECORD AND KNOW IF THE SEARCH WAS SUCCESSFUL. ALSO ADD A NEW REC IF NOT FOUND IN VBA. Thanks, Troy
  7. NoBugs

    Control Array

    Thank you for your quick response. I found another way to do what I was trying to do
  8. NoBugs

    Control Array

    I can set up a text box control array in vb. I need to set up one in access. I'm loading a public defined array with data and would like to fill a control array on a form from that public array. [Private Sub ClearArray() Dim intIndex As Integer For intIndex = 0 To Ir1...

Part and Inventory Search

Back
Top