Search results

In order to print the report to PDF with bullzip I need it to be open before entering the PrintInvoice routine, but very possible that I misunderstood you. To be honest I'm very unfamiliar with this and I'm not very sure I understood. So I could use access to make the PDF files without bullzip...

Just yeah 😅 🙈 If I don't manage to, guess I will have to use the access export again 😁

You would be surprised about the quality actually. Zipping doesn't really reduce the size. I just tried it now, from 345KB it reduced it to 336KB Also, printing to PDF and saving the report as PDF makes a difference in size too, printing is smaller (it's size is 250KB, the same report used)...

I'm really not sure. I was thinking about killing the process before starting a new print but not sure if that's the right way to go. I could suppress the error but then I won't know when does it mess up the files. After closing that error box everything seems to be working fine until after some...

Because of the file size. When I do it with bullzip its about 50-60 KB per PDF file, while with access its about 250-300 KB.

Hello, I have a rather odd problem with MS Access and bullzip. Im converting one by one report (invoice) to PDF with bullzip. The whole process in Access goes without any errors. However, sometimes I get the error message from the title in bullzip with the next text: "Error -2147024864: The...

For now I have put back Access 2007 because its way faster, up to 20 times in this case. When I find more time I might try more options with Access 2010

Using just a query is way too slow in my case. The backend has more than 6 million records and I take data from another table also, depending on the date.. So thats why the use of the temporary table. The union query would be just too slow when it merges data from a .mdb database and a SQL...

Im not quite sure I understood. Im only opening it in print preview to check it out and the printers seem to be alright, I mean I can see them they are available.

I run into a weird problem. Im building my front-end in .accdb with Access 2007 and the back-end is a mixture of SQL Server and .mdb. However, in this particular case only the .mdb database is being used. Running a simple append query from VBA, (Im copying records from the back-end .mdb table...

Hello guys, Recently I came across this problem and couldn't really find a solution on the internet so I decided to share my experience about it here. I made an invoice access report which contains a memo text field in the report footer. However, whenever the text would be longer than 255...

I didnt have the chance to compare yet. Its not that I want to go with pre-printed forms but I have to :D Once I manage to complete the Output/Print procedure I will compare one to another in terms of speed. I had some success with a program called Printfil after sharing my printer and using...

It was, sorry for the confusion. Could have wrote it more precisely but its been a long day 😅

Hello guys, I came across this thread and now I want to print directly from VBA without first saving the text to a txt file. Send Text Directly To Printer In the thread at the end the creator of it ended up with exporting text to a txt file and then printig, however, I saw this post there...

Thank you all for the answers, it helps to know more :) They will do actual printing to paper, which this is most about. Some invoices will be exported to PDF which then will be sent with email to another companies and they will print and deliver the invoices to customers. However, my main...

@Gasman I will check it out more, I did a little but it didn't seem like the option I'm seeking for. Thanks for your reply

@CJ_London thanks for the reply. I'm not quite sure which printer is it but I do know that the capacity is 500. The user would usually print 2k pages, not 20k at once. Yes they will have to restock (they are doing it now also), however, they will havea pop-up form which I'm planning to put...

Thanks for all the suggestions guys. Im sorry that I wasnt specific enough, I will try to be more specific, now that I finished analyzing. So it seems like I will have to work with a "template". On the paper they will already have the template printed out like the picture in attachment. What I...

Hi, no, not yet. Doing so I would have to make a report? I am actually trying to avoid making a report at all

Hello guys, Im looking for the fastest way to print text data. Instead generating 20000+ pages in a report (with logos and stuff), what would take quite a while, is there a way to print text data directly from VBA? I would include only text data, logos and other images, if any, would already be...