Consulting

Results 1 to 10 of 10

Thread: access is giving error 3709 on one button

  1. #1
    VBAX Newbie
    Joined
    Sep 2022
    Posts
    5
    Location

    access is giving error 3709 on one button

    I an noop on access and excel.
    I have received a access file from a person that is leaving the company.
    I did received the access file and the excel file.

    But when I try to insert the data from the excel file, it gives me the error "3709"
    and when i run debug it shows the error on this code
    Private Sub btnimport_Click()
    If MsgBox("Are you sure you want to import Date to Insert Table?", vbYesNo + vbQuestion) = vbYes Then
       DoCmd.RunSavedImportExport ("Import-insert")
       Else
    End If
    End Sub
    Not sure what and how to fixed this problem

  2. #2
    if you google Error 3709, you will find lots of hit and some solutions
    that you can try.

    if you are unable to solve it, you can attach your db and excel file (in .zip format)
    for analysis. just mention which form and button has the fault.

  3. #3
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    4,285
    Location
    Was there meant to be an alternative option? You have the basic construct of an If.. then.... else, but no option on the else section.
    Remember To Do the Following....
    Use tags when posting code to the thread,
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  4. #4
    VBAX Regular
    Joined
    Nov 2020
    Location
    Swansea,South Wales,UK
    Posts
    60
    Location
    Crossposted (with responses) at https://www.accessforums.net/showthread.php?t=86655

  5. #5
    VBAX Newbie
    Joined
    Sep 2022
    Posts
    5
    Location
    Here are the two files excel and database.
    try to use "Make new insert table to get dat" button
    Attached Files Attached Files

  6. #6
    VBAX Newbie
    Joined
    Sep 2022
    Posts
    5
    Location
    Here are the two files excel and database.
    try to use "Make new insert table to get dat" button
    Password = melandri

  7. #7
    VBAX Newbie
    Joined
    Sep 2022
    Posts
    5
    Location
    Quote Originally Posted by arnelgp View Post
    if you google Error 3709, you will find lots of hit and some solutions
    that you can try.

    if you are unable to solve it, you can attach your db and excel file (in .zip format)
    for analysis. just mention which form and button has the fault.
    did add files

  8. #8
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    4,285
    Location
    What were the results of the responses you received from accesaforums.net?
    Remember To Do the Following....
    Use tags when posting code to the thread,
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  9. #9
    VBAX Newbie
    Joined
    Sep 2022
    Posts
    5
    Location
    Did get the answer from the other form, and it is working.
    Ribbon>External Data>Saved Imports

  10. #10
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    4,285
    Location
    Thank you for the update
    Remember To Do the Following....
    Use tags when posting code to the thread,
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •