|
||||||
Access MVP (2010-2015) |
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 […] …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 […] 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 […] Sometimes when creating a new Module in Access it does not show up in the Navigation Pane. So you’ve pressed new and went off to do something else and now you’re ready to use your new Module but where is it? Well, it’s still there but for whatever reason it is not showing. (Yep, it’s […] 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, […] |
 |
||||
|
Copyright © 2025 Gina's Coffee Shop - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
