Search results

  1. C

    Run-time Error 5 "Invalid Procedure Call or Argument"

    Yea, you guys are amazing! Thanks for being so patient ! I almost gave up myself! Do you know the reason why it worked on some computers but not on others?
  2. C

    Run-time Error 5 "Invalid Procedure Call or Argument"

    omg! This is a miracle! It worked！
  3. C

    Run-time Error 5 "Invalid Procedure Call or Argument"

    Both computers don't have any missing reference...or at least got the same reference as I do.
  4. C

    Run-time Error 5 "Invalid Procedure Call or Argument"

    I don't think there is a problem in the Connection part, since they can view, change data without any issue.
  5. C

    Run-time Error 5 "Invalid Procedure Call or Argument"

    SQL server 2008 R2 It is native drive all have the same setup.
  6. C

    Run-time Error 5 "Invalid Procedure Call or Argument"

    I know I don't have very standardized filed names, but I guess that shouldn't be the cause, should it? It works perfectly on 3 other computers.:confused:
  7. C

    Run-time Error 5 "Invalid Procedure Call or Argument"

    the problem occurs when they both are not empty
  8. C

    Run-time Error 5 "Invalid Procedure Call or Argument"

    This is what I'm using to call that function.
  9. C

    Run-time Error 5 "Invalid Procedure Call or Argument"

    I want to thank you first!:) but the problem is not going away! 1. Is this database split - backend with tables only and a COPY of the frontend on each user's machine? 2. If not, it needs to be. Yes. We use access as frontend, SQL backend. The access file is located on a network drive...
  10. C

    Run-time Error 5 "Invalid Procedure Call or Argument"

    Hi Thank you! I tested it. It works fine on mine(as always)...but it still gives the same error at the same line on my co-workers computers! This is killing me. sad face...
  11. C

    Run-time Error 5 "Invalid Procedure Call or Argument"

    sadly I can't even debug this thing on my own computers since they don't get this error. =(
  12. C

    Run-time Error 5 "Invalid Procedure Call or Argument"

    It runs perfectly on my laptop and my desktop, but always gives run-time error 5 on 2 of my co-workers computers. This is where it stops. Can anyone help please? Thanks! I have checked reference on all computers made sure they have the same order. just checked again, we have the same versions...
  13. C

    Schedule event - auto generate a report and send out

    how exactly do I do that? I created a Scheduled Task, it only opened Access program for you instead of the query/vba code in xx.mdb file. Please help. Thanks in advance.
  14. C

    Schedule event - auto generate a report and send out

    I need to send a weekly report at 11pm every Friday night to someones email. I think there are 2 things I need: 1. automatically generate a report at that time. 2. automatically send an email with that report attached. (maybe 3. attach the report to email, I've never done it:confused:) Right...
  15. C

    About getting external data - Link outlook to Access project

    I recently upsized my database to SQL server, after that I created a Access Project(.adp ) to replace the original one(.mdb). I thought that's the proper way to use Access as a frontend... My issue is that I had a table that linked to outlook inbox in my original one database(.mdb), but now...
  16. C

    How to read outlook inbox that's located on another computer(the server)?

    I've created a ACCESS database and upsized to sql server. Users run it from a mapped net drive, basically a shared folder. In this way users can access to this program without getting on the server, mainly because of safety issue. In my program, Access and Outlook are connected. It can...
  17. C

    Question Store blob data to SQL server

    I recently unsized my access database to SQL server. I will store tons of documents, pdf, mp3, pictures in the database. My plan is storing all documents in folders which categorized by document type, then store location of the document as hyperlink in the database. In this way I will not have...
  18. C

    run time error 3251, after upsizing to SQL Server

    Thank you buddy. I got it working.
  19. C

    run time error 3251, after upsizing to SQL Server

    Runtime error 3251: operation is not supported for this type of object. debugging says ".AddNew" is where the problem occurs. Can anyone tell me how to fix this? Thanks
  20. C

    How do I return a query result to form fields

    Thank you very much. I got it working
Top Bottom