User Profile

Collapse

Profile Sidebar

Collapse
shenkel55
shenkel55
Last Activity: May 14 '08, 06:03 AM
Joined: Mar 5 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • shenkel55
    replied to Loop to delete record(s) in multiple tables Access 2003
    in Access
    Ok clloyd, maybe I didn't answer the wrong question yesterday. When you say "one to many records," are you referring to a relationship between the tables or the quantity of records you are wanting to delete in each table? Could you please post just a little more information? I may have a simple answer for you....
    See more | Go to post

      Leave a comment:

    • shenkel55
      replied to Access Can't Import An Excel File Unless It Is Open
      in Access
      I am having trouble with the code leaving an open instance of Excel today. I stuck an importspreadshe et line in the center of the open and close Excel, where the "find the last cell" code was. This is the line

      DoCmd.TransferS preadsheet acImport, acSpreadsheetTy peExcel9, strFileName, strPathName, FieldNamesInRow One

      So why is that stopping it from closing Excel in the processes screen of task manager?...
      See more | Go to post

        Leave a comment:

      • shenkel55
        replied to Access Can't Import An Excel File Unless It Is Open
        in Access
        I abandoned my old code a couple of months ago. I rewrote it today after reading your message, and it seems to open and close Excel instances as it should. If you see any gotchas coming, let me know.

        Also this is supposed to be an automated app... I don't want to be here opening and saving tables, and I'm not sure the end users want to go through that procedure... and the way the files are coming in isn't going to change
        ...
        See more | Go to post
        Last edited by shenkel55; Mar 6 '08, 09:48 PM. Reason: typo

          Leave a comment:

        • shenkel55
          replied to Loop to delete record(s) in multiple tables Access 2003
          in Access
          I'm new here... I answered the wrong question and I am trying to delete this post
          See more | Go to post
          Last edited by shenkel55; Mar 6 '08, 10:02 PM. Reason: deletion attempt

            Leave a comment:

          • shenkel55
            replied to Access Can't Import An Excel File Unless It Is Open
            in Access
            I just opened the .xls file in notepad and it is indeed an html file. I didn't know Excel could open that just like a workbook (it looks like it has an Excel namespace). Thank you. I will look into the file stream idea.
            See more | Go to post

              Leave a comment:

            • shenkel55
              started a topic Access Can't Import An Excel File Unless It Is Open
              in Access

              Access Can't Import An Excel File Unless It Is Open

              I'm using Access and Excel 2003. Using either the import wizard or code, I have the same problem. This problem only happens with Excel files automatically generated by Corp IT. If I try to do an import and the Excel file isn't open I get the following error: "The wizard is unable to access information in the file "...path info... "Please check that the file exists and is in the correct format." If the files are opened directly...
              See more | Go to post
              • shenkel55
                started a topic Access ImportSpreadsheet and Wizard Give Different Default Field Names
                in Access

                Access ImportSpreadsheet and Wizard Give Different Default Field Names

                I am using Access 2003. I've been importing Excel 2003 spreadsheets using the wizard in Access for some time now. The spreadsheet does NOT have the column names in the 1st row, so the wizard names them "Field1", "Field2", etc., by default. I decided to automate the process and I am using the following line of code:

                DoCmd.TransferS preadsheet acImport, acSpreadsheetTy peExcel9, strFileName, FileSpec, FieldNamesInRow One...
                See more | Go to post
                No activity results to display
                Show More
                Working...