User Profile

Collapse

Profile Sidebar

Collapse
drsman
drsman
Last Activity: Nov 9 '08, 01:31 AM
Joined: Jul 16 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • drsman
    replied to INSERT INTO question and problem
    in Access
    Solved, was not dim'ing or executing query... thanks for the help.
    See more | Go to post

      Leave a comment:

    • drsman
      replied to INSERT INTO question and problem
      in Access
      Hi, thank you for the help!

      I've found that me.MyPath is not the correct usage because it's not a form. But it's still not working...

      This is the code below for what is in the Module. Below that is what is now in the onclick event of the button... It is correctly doing the transfertext to tbl_temp_import but then on the next line

      Code:
      strquery = "INSERT INTO tbl_ImportFileName (filename) Values ('"
      ...
      See more | Go to post

        Leave a comment:

      • drsman
        started a topic INSERT INTO question and problem
        in Access

        INSERT INTO question and problem

        Hello!

        I have the following code that opens a "browse for file" box and imports through TransferText the path and filename (called MyPath in the code) that I select.

        I'm trying to put that variable MyPath (for example, "C:\import\what ever.csv") into a table (tbl_ImportFile Name). But I keep getting the error, "Compile error: Sub or Function not defined" and VALUES is highlighted in the VB...
        See more | Go to post
        No activity results to display
        Show More
        Working...