Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Saving changes is not permitted (SQL Server tables)…

You upsize your tables up to the SQL Server but you used some BIT fields and/or you want to make some other table changes.  So, you navigate to the first table and uncheck the *Allow Nulls* for your BIT field and make your other adjustments and you go to Save.  Instead of the table saving you […]

57 total views, no 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 a DATE…

[…]

842 total views, no views today