Search results

The first link was the solution that was posted in the first response. The second one did the trick! Thank you! :)

I mentioned in the original post that Application.Printer does not work, as the printing is happening outside of the Access application.

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...

Thanks - I tried this one, but it starts the PDF viewer every time i click print.

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.

I thought this worked, but looks like i spoke too soon. I am still receiving the same error message after trying this fix.

I am trying right now!

I understand where you're coming from. Have to check everything! No, the table is not called 'LINKED_TABLE'. I just called it that for this example to remove any proprietary information from the table name. The error message was exactly as included in the original post. The name of the table...

Hey thanks - I can't really make the form's source this query, as the form's source is already another table (which I can't link to this one). I did make a query, and called it instead of the table. I still receive the same error message.

Some updated info: I receive the error on my new form during runtime. I do not receive the error on any forms if i open the database view, then open the forms in design view and switch to form view.

I am using Access 2010, and have a linked table using an ODBC Machine Data Source. I can open the linked table in the database view, and view all of the data. I can create a new form, and connect to the table, and read and display the data. However, when I try to connect to the table from an...