Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Add your Report Name to Page Footer…

Put the TEXT box on the Report and in the Control Source put…

=[Name]

OR to get the Report Name and the Date/Time

=[Name] & " Printed on " & Now()

OR to get the Report Name and the Date

=[Name] & " Printed on " & Date()

…now if you change the Name of […]

 1,309 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 […]

 2,287 total views

So you’re ready to upsize…

Here are a few tips when upsizing tables to an SQL Server that I have picked up along the way…

Make a Back-Up of your Database… (added 7.26.2013)

Need I say more?

Just say *NO* to…

…Special Characters or Symbols

These characters have meaning when used in Access and on an SQL Server. While wrapping […]

 2,747 total views,  2 views today

Happy New Years to me…

Once again, I’ve had the honour of being re-awarded the MVP Award for Access by Microsoft! Yippee and thank you!

 752 total views,  1 views today

 752 total views,  1 views today