Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Export a Parameter Query to Excel…

It’s always tricky when you want export filtered data to Excel. You will get an error message if you put try to put the Forms Control in the Criteria section of the Query. Why? Because Access insists on having the value before it can execute the export and not from the Form but directly in […]

138 total views, 1 views today

To Few Parameters Expected n…

…while using db.OpenRecordset with a Parameter…

Change this…

Set rst = db.OpenRecordset(“qryYourQuery”, dbOpenSnapshot)

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

Or, if your field is NUMERIC…

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

Or, if your field is […]

932 total views, no views today

Queries really can’t do everything…

que-ry [kweer-ee] noun, plural que-ries verb, que-ried, que-rying

an inquiry a computer language used to make queries into databases and information systems A way to view a subset of information from one or more tables in a database Queries return records from one or more tables according to the parameters set in that query

However, […]

68 total views, no views today