Tag Info

New answers tagged


I recently had this exact problem and fixed it by setting the report's .Printer property to the default printer (or desired printer) before printing as below. 'need report open in order to set .Printer property ' so open report in PREVIEW mode but HIDDEN DoCmd.OpenReport "<ReportName>", acViewPreview, , , acHidden 'Assign report's .Printer property ...


Yes you can define foreign key relationships in Access. As long as you aren't doing anything particularly unusual SQL Server relationships normally translate just fine to MS Access relationships. Here are some excepts from this link: Microsoft: How to define relationships between tables in an Access database A one-to-many relationship is the most ...

Top 50 recent answers are included