Recent content by dzirkelb

I have narrowed the issue to be specific to this report, and a plugin we use to generate bar codes. Thank you for all the help, but this is now a development issue that I need to figure out with the bar code company.

it prints fine, just throws the error, causing the rest of the automation to fail.

I get the same issue - sends the print job but gives same error.

I can see the job spooling in the printer queue, it appears to print, but i then get an error on access stating "Run-time error '2212': Microsoft Access couldn't print your object". The application then is stuck and can not move forward without intervention, and the rest of the code stops...

Thank you - reviewing now and hope to do something today. Had a guy quit on me last week so having to pick up his workload, sorry for lack of reponses.

I used the same drivers as installed on server 2012 to server 2022. The printers appear to be working fine when print jobs are sent to them manually.

I don't have any specific reason besides it works on the old server, so I left as is. Is this what you are suggesting i should change below? I'm not good with Access VBA (or VBA in general) outside of datra manipulation (calling data, updating, querying, etc). If intCountOfPackSlips >...

We are upgrading one of our servers, and when i simply copied the entire Access database (that has worked for years with no issues) to the new server, i get an erorr when trying to print: Run-time error '3021': No Current Record I have some code in place that runs a query to get the variable...

Anyone have ideas?

Ok, so I just figured out how to get the label to print, easy enough so far. I put a new row in my test table, label prints, all good. I push a new row of data into that table via web app, nothing prints. Is this a limitation where you have to have the table open and do the insert yourself?

Can anyone help with this? I want to insert a row into a table, then automatically print a report. Right now, I'm just trying to test the trigger. I know the trigger is happening as I tested with the SendEmail event, and it works fine. I just can not figure out how to print a report from...

I know how to print a report from a form and from visual basic; however, I dont' see how I can do that from an After Insert event from Access Table. I open the table, click on the table tab, click After Insert. On the list of available actions that appear, none of them, that I can tell, allow...

Using a data macro, I want to know how to print a report after the insertion of a row of data. I am able to create the macro, but there are no choices for reports on the actions. Also, I see an action for a DataMacro, however, when I create any macro, they do not show up in the list of...

They don't, but this is just a temp table, easy for me to convert the code to look at an Access table instead. However, I'm having trouble finding how to print something from a Data After insert event. The drop down options are limited compared to a regular macro, and there is nothing to...

I am printing labels, so no ink. The program will reside on a server, not the user's computer. Also, this table is just a temp table. I dump records in when the product is received in, then delete them when it is printed. If it doesn't print for some printer error, then they will just...