{"id":485,"date":"2013-01-23T00:24:08","date_gmt":"2013-01-23T00:24:08","guid":{"rendered":"http:\/\/regina-whipp.com\/blog\/?p=485"},"modified":"2013-11-02T19:16:02","modified_gmt":"2013-11-02T23:16:02","slug":"openrecordset","status":"publish","type":"post","link":"https:\/\/regina-whipp.com\/blog\/?p=485","title":{"rendered":"To Few Parameters Expected n…"},"content":{"rendered":"

…while using db.OpenRecordset <\/strong>with a Parameter…<\/p>\n

Change this…<\/strong><\/p>\n

Set rst = db.OpenRecordset(“qryYourQuery”, dbOpenSnapshot)<\/p>\n

To this, for TEXT…
\n<\/strong>
\nSet rst = db.OpenRecordset(“SELECT * FROM qryYourQuery WHERE tblYourTable.ytYourField= ‘” & [Forms]![frmYourForm]![txtYourTextBoxOnForm] & “‘”)<\/p>\n

Or, if your\u00a0field is NUMERIC…<\/strong><\/p>\n

Set rst = db.OpenRecordset(“SELECT * FROM qryYourQuery WHERE tblYourTable.ytYourField = ” & [Forms]![frmYourForm]![txtYourTextBoxOnForm])<\/p>\n

Or, if your\u00a0field is a DATE…<\/strong><\/p>\n

Set rst = db.OpenRecordset(“SELECT * FROM qryYourQuery WHERE tblYourTable.ytYourField= #” & [Forms]![frmYourForm]![txtYourTextBoxOnForm]”#”)<\/p>\n

Make a copy of *qryYourQuery* first\u00a0and, then, remove the Parameter from your *qryYourQuery*.<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

…while using db.OpenRecordset with a Parameter…<\/p>\n

Change this…<\/p>\n

Set rst = db.OpenRecordset(“qryYourQuery”, dbOpenSnapshot)<\/p>\n

To this, for TEXT… Set rst = db.OpenRecordset(“SELECT * FROM qryYourQuery WHERE tblYourTable.ytYourField= ‘” & [Forms]![frmYourForm]![txtYourTextBoxOnForm] & “‘”)<\/p>\n

Or, if your field is NUMERIC…<\/p>\n

Set rst = db.OpenRecordset(“SELECT * FROM qryYourQuery WHERE tblYourTable.ytYourField = ” & [Forms]![frmYourForm]![txtYourTextBoxOnForm])<\/p>\n

Or, if your field is […]<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,29],"tags":[64,65,22,21],"class_list":["post-485","post","type-post","status-publish","format-standard","hentry","category-access-tips","category-error-messages","tag-access-tips","tag-error-messages","tag-queries","tag-vba","odd"],"_links":{"self":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/485","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=485"}],"version-history":[{"count":9,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/485\/revisions"}],"predecessor-version":[{"id":846,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/485\/revisions\/846"}],"wp:attachment":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=485"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=485"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}