I just mentioned that because the code in the first response mentioned editing the win.ini file. I know the default printer settings are in the registry, and have found the key. I just need to figure out how to set the value now.
Thanks for the response, but this code doesn't seem to change the Windows default printer. It doesn't modify the win.ini file, and it doesn't throw any errors.
Hi everyone,
I am working on an application which prints both reports created in Access, and external PDFs. These documents are printed to a physical printer, but each document may need to be sent to a different printer than the previous one.
For reports created in Access, this isn't an issue...
Thank you for your help looking in to this.
The Access application creates other documents which are being printed, so I was just hoping to have one program print everything.
My company owns licenses of Acrobat and Distiller. They'd just have to allocate one of those licenses to be used for...
Hello!
I am using Access 2010, and trying to print out multiple external PDF files silently (without opening Adobe Reader or a print dialog). I am not generating the PDFs with the Access DB - they are created by another application and stored on a network drive.
I've done a bunch of searches...
I only changed two words in my original post. I didn't reply to anyone. :)
I think I figured out my issue, but if it doesn't work, I will have a look at your suggestion.
Thanks!
I am trying to read data from a table created by another application developer. In the table, there is a field for Part IDs. This field can have one or many Part IDs in it. If there are more than one, each Part ID is separated by a comma.
My issue is that we have similar Part IDs, and that...
Thank you everyone for your time and patience with this issue. I managed to find something that worked this morning.
I set up the application's startup procedure to refresh the link to the problem table by using the following code:
Declarations:
dim tDef as TableDef
dim strConnect as String...
Missed your edit until now. Thanks for the other suggestions.
I am not using the form to update data on this particular table. I am only reading data in this table.
It only works when opening the form from the database view. During runtime, it doesn't work on either form.
I thought it worked, but it didn't. I tried to edit my post quickly, but didn't get to it in time. I also tried using the query to connect to the linked table, but upon opening the query during runtime I receive the same error message.
I used the code changes that you provided above, and when that didn't work, I also declared the db as a DAO.Database. That ended in the same result. Error message is the same.