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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by KrogerKommandeur

  1. KrogerKommandeur

    Update form with bound controls from other form

    Hello, all. I changed the code a bit and here is the full code as I have it for the function that is called when the button is pressed. Note that the cmdAddNew sub at the bottom is only designed to try to force the form to add a new record, after which the values I want are added. Public Sub...
  2. KrogerKommandeur

    Update form with bound controls from other form

    Hello, I am trying to populate a form with bound controls based on a variable from another form. On the Click event from the main form, the value of a control (called SirNo) for the current record is taken in and passed to a function. This function will check the table for a value of SirNo...
  3. KrogerKommandeur

    Import File macro problem

    Thank you, Skip! The second solution worked great. The Add method apparently needs to know exactly what the format of the datasource is before it moves on. Point is it worked fine. Thanks! Wally - The Gahndi that eats
  4. KrogerKommandeur

    Import File macro problem

    Hello all, I am trying to use the code below in a macro to import a file by first opening the Open File dialog box, allowing the user to select the file that they wish to use and then passing the file path to the Connection property of the Add Method. I have gotten run-time error 1004, which...
  5. KrogerKommandeur

    Save Excel file according to name of imported text file

    I had actually tried that, which was why I had asked. It hadn't worked, and I thought that I had done something by mistake to make it not work. Wally - The Gahndi that eats
  6. KrogerKommandeur

    Save Excel file according to name of imported text file

    Dan, Thank you very much! It is always very helpful to know how applications like Excel, Word, Access, etc. perform basic operations like importing. Makes automating things a lot easier. I really wasn't aware of how Excel stored data on imported files, although I suspected that it had to...
  7. KrogerKommandeur

    Save Excel file according to name of imported text file

    Hello all! I have looked for an answer to this question and, to my knowledge, no one has explored this specific issue. When you import a text file into Excel, does it store the file information anywhere? If so, is there a way (through VBA code) to tell Excel to save the file using the...
  8. KrogerKommandeur

    Save Excel file according to the name of the Text File

    Hello all! I have looked for an answer to this question and, to my knowledge, no one has explored this specific issue. When you import a text file into Excel, does it store the file information anywhere? If so, is there a way (through VBA code) to tell Excel to save the file using the...
  9. KrogerKommandeur

    Creating dynamic append/delete query form

    Bill, I'm sorry I forgot to answer your question at the bottom of this post. I tried it and it does not work. Just as a test to see if I could find any records in the database. I tried the following code: Dim strSQL As String strSQL = "SELECT * FROM bryan WHERE...
  10. KrogerKommandeur

    Creating dynamic append/delete query form

    Actually, bill... I had to change and do another form, but I am having trouble with it. In this form, I have two text fields(Table1 and Table2). When I press a button, I want to run a query that will use the name put into these fields as the table names. First part: If these are dropdown...
  11. KrogerKommandeur

    Creating dynamic append/delete query form

    Thank you for your help. I am implementing it right now. I am not sure if it has worked, but can I use the same ([]) to indicate where a form-inputted value can be entered into a query? Thanks! Wally - The Gahndi that eats
  12. KrogerKommandeur

    Creating dynamic append/delete query form

    Hi This is my first writing here, so go easy, will ya? I am trying to archive a large database, but I am willing to assume that I am going to have to do this more than one time. I have archived all records for 2001, but I want to be able to make a form where I can put in the date and click a...
See more

Part and Inventory Search

Back
Top