Search results

  1. Y

    run-time error 449 Argument Not Optional

    Dear isladogs, Thank you for your kind reply! I'll try to explain it in as much detail as possible! I'm really thanksful for everything you've done and will do to help me on this issue!! Best, Jessica
  2. Y

    run-time error 449 Argument Not Optional

    Dear isladogs, Sorry I didn't get to send you the Access file last Friday, was caught up with another task!! I will try my best to send it to you today, do you think you'll still have some time to debug it? Thank you so much I appreciate you! Happy Monday :)) Best, Jess
  3. Y

    run-time error 449 Argument Not Optional

    Dear isladogs, Sure thing! No rush at all I'm sorry to bother you this late!! I did check the references list and everything seems fine and it compiles normally, and I'm using Access 2007-2010 Have a great night! Best, Jess
  4. Y

    run-time error 449 Argument Not Optional

    Dear isladogs, Omg noo I'm so sorry for mistype your name this whole time!! Sure thing I'll create a copy now, how can I send it to you tho? Best, Jess
  5. Y

    run-time error 449 Argument Not Optional

    Dear islandogs, Thank you so much for getting back to me! I'll PM you the API token, and I'm not sure what you mean by the copy of my app, but I can email you all the functions and sub involved without the confidential data. Also I have checked the supplied date, it's the standard time that...
  6. Y

    run-time error 449 Argument Not Optional

    Dear Jiri, Thank you for your reply! I tried to comment it out and still have the argument not optional error.. Best, Jess
  7. Y

    run-time error 449 Argument Not Optional

    Hey there, here is the Qualtrics API documentation reference link for the function "Create Survey Distribution Links & Send Emails": https://api.qualtrics.com/reference#distribution-create-1 This is the URL to call the API: https://az1.qualtrics.com/API/v3/distributions Nah it's not the send...
  8. Y

    run-time error 449 Argument Not Optional

    Hi islandogs! Thank you so much for taking the time to help me with this! This is my code, I'm using Qualtrics API to generate survey distribution links and send emails to participants over Qualtrics. In other words, I'm using HTTP request to send information to the qualtrics server with...
  9. Y

    run-time error 449 Argument Not Optional

    Omg thank you so much for doing this I really appreciate it! The Qualtrics API documentation isn't much help tho.. Here's what they have on the page: curl -XPOST -H 'X-API-TOKEN: <API Key>' -H 'Content-Type: application/json' https://co1.qualtrics.com/API/v3/distributions -d '{...
  10. Y

    run-time error 449 Argument Not Optional

    Hey there, please don't say that you've been very helpful!! Here is the strBodyJson...
  11. Y

    run-time error 449 Argument Not Optional

    Dear MajP, I tried to declare a collection named colBody to add "dicHeader" and "dicMessage" and the error is gone! But now I run into a different error, here is the error message: {"meta":{"httpStatus":"400 - Bad Request","error":{"errorMessage":"Expected param not found...
  12. Y

    run-time error 449 Argument Not Optional

    Hi hi again! Yes you're correct when I follow your method and debug each line, the error is in dicMessage("header") = dicHeader and not on the call line anymore Best, Jess
  13. Y

    run-time error 449 Argument Not Optional

    Thank you again for your reply!! I'm debugging each line of code and yes they are passed as strings and dates. I delete the Cstr() function, try to run the code again and still have the same issue, this time the error message pops up on this line of code: dicMessage("header") = dicHeader I'm...
  14. Y

    run-time error 449 Argument Not Optional

    Hi there, thank you so much for your reply! I put some stops and tried to debug my function, the error message shows after this line of code: dicMessage("header") = dicHeader I've changed the dates back to dates instead of converting them into strings, and still have the same error...
  15. Y

    run-time error 449 Argument Not Optional

    [/CODE] Public Function createSurveyDistributionLinks(strSubject As String, strMessageID As String, strRecipients As String, strSurveyID As String, dtSendDate As Date, dtExpirationDate As Date) 'note: this function does not contain message feature as it is not used in 1KS. Can add for other...
  16. Y

    run-time error 449 Argument Not Optional

    Hi MajP, thank you for your reply! Just tried to pass them as dates and still run into the same error..
  17. Y

    Hi everyone!

    Thank you!!:)
  18. Y

    run-time error 449 Argument Not Optional

    Dear Ranman256, thank you so much for your quick reply! I copied my code in the following: UG Added Code Tags Public Function createSurveyDistributionLinks(strSubject As String, strMessageID As String, strRecipients As String, strSurveyID As String, dtSendDate As Date, dtExpirationDate As Date)...
  19. Y

    run-time error 449 Argument Not Optional

    Hello all, I'm new to Access and currently work as a data system manager at an HIV research lab. We use Qualtrics to create surveys for participants to take online, and we use Access to call Qualtrics API to add participants to Qualtrics contact panel, automatically generate survey links for...
  20. Y

    Hi everyone!

    Hi everyone my name is Jess, I'm new to Access and I'm a data system manager at an HIV research lab, nice to meet you all!
Top Bottom