Saturday, March 27, 2010

PDF Printer + VBA TIP

  1. PDF Printer
PDF Printer works as a Microsoft Windows printer and allows you to write PDF documents from virtually any Microsoft Windows application.
Yes, BullZip is the software that we are talking about here. Any of the windows application just give Ctrl+P to open print dialog box and choose the bullzip PDF printer then click OK. It will ask for a path to save. Choose the format and save.  It also supports Multiple output types like BMP, JPEG, PCX, PDF, PNG, and TIFF.

Click here to download

CutePDF printer is also another tool which does the same job and this is also a freeware.

You can create professional quality PDF files from almost any printable document using CutePDF.
Click here to download

Let’s have a coding tip also in our blog, what you say?
Yesterday my friend asked me a MS-Access question like how to check if a table or a query is already there or not using VBA?
Let me give you a simple code that I have got after long search. Use the below code to see if a query is existing or not. This code will give you 1 if it’s exist else it will be 0.
Public Sub inQuery()
Dim qrytest As QueryDef
Dim exists As Integer
exists = 0
For Each qrytest In CurrentDb.QueryDefs
If qrytest.Name = "Abbu_Batch" Then
exists = 1
Exit For
End If
MsgBox (“Found:” & exists)
End Sub

Make this handy for Access programmers.

No comments:

Post a Comment