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 […]

 792 total views

August 3rd, 2013 | Tags: , , , | Category: Access Tips, Database Design, Error Messages | Comments are closed

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 […]

 2,323 total views

January 23rd, 2013 | Tags: , , , | Category: Access Tips, Error Messages | Comments are closed