In an MS-Access application, I need to save the user's current default printer before changing it to a Pdf-Writer to email a report. On completion I must restore the user's default printer.
I have the code:
Dim stUsersPrinter As String
stUsersPrinter = Application.ActivePrinter
However I get a compile error:
"Method or data member not found"
I am using MS-Access 2003.
Under Tools/References I have:
Visual basic for applications
Microsoft Access 11.0 Object library
Microsoft DAO 3.6 Object Library
Microsoft Visual Basic for Applications Extensibility 5.3
Microsoft ADO Ext.2.8 for DDL and Security
Microsoft ActiveX Data Objects Recordset 2.8 Library
Adobe Acrobat 9.0 Type Library
Find Printers type library
Microsofoft Office 11.0 Object Library
Windows Script Host Object model
Acrobat Access 3.0 Type Library
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved. W…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works
The attack works by targeti…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…