Hi Jim,
I can print individual report.
When I tried to combined, pdfcreator got freeze..
Guess problem with the following code:
Do Until pdfjob.cCountOf Printjobs = 1
DoEvents
Loop
Thank you for your reply.
shimul
Last Activity: May 20 '11, 05:12 PM
Joined: Nov 5 '08
Location:
-
Access Reports and PdfCreator
Hi All,
I am trying to combine multiple access reports in one PDF using pdfcreator, however it doesn't work for me...
Can you please check the following code:
...Code:Sub PrintAccessReportToPDF_Early() Dim pdfjob As PDFCreator.clsPDFCreator Dim sPDFName As String Dim sPDFPath As String Dim sPrinterName As String Dim sReportName As String -
Merge PDF Report
Hi All,
I run several reports every week. I'm now using Win2PDF to convert
the reports and then merging them using WIN2PDF into a
single file. What I'm looking for, is there any way to do this with just the click of
a button. I'm using access 2000.
Thank you in Advance. -
Merge PDF
I am working on a project, in which I need to generate/save Access report to PDF. Then require merging the all pdfs into single pdf.
I am using Access 2000 and Acrobat Distiller 8. -
Access Chart
Hi All,
I really do not how to expain. As a result I attched file which will explain what I am looking for. Sorry for the inconvenience.
So can access produce a graph like this.
Thanks for your help.... -
Delete Statement
Can you please check the following delete code? It doesn't delete data from table.
...Code:Dim strSQL As String Dim strID As Integer strID = Me.SAIID.Value 'strSQL = "DELETE * from tblCOSL WHERE tblCOSL.SAID = " & strID & ";" DoCmd.SetWarnings False DoCmd.RunSQL ("DELETE * from tblAGWL WHERE tblAGWL.SAID = " & strID & ";") DoCmd.RunSQL ("DELETE -
Read Data from Table
Hi,
Have table with data ( like a,b,c,d in column 1), want to read data from table and put in text box in continuous form.
like tble name "tbltest" and textbox name "txtbox".
now want to read first data from table and put in text box, then read second one and put in text box .....so on unit finish data in table.
Try to write following code, but couldn't fiqure out ----"... -
Thank you for your reply.
My combobox and textbox in the same form.
Another question:
Have table with data ( like a,b,c,d in column 1), want to read data from table and put in text box in continuous form.
like tble name "tbltest" and textbox name "txtbox".
now want to read first data from table and put in text box, then read second one and put in text box...Leave a comment:
-
Combox Box -Help Please
Hello There,
I have combo box and getting data from table.
I wanna read data from combo box and auto fill the text box when form open or load.
For Example:
Combo have three value a;b;c and wanna display a,b,c in text box (Continuous Forms) when open or load the form.
Is it possible? If so, Can you please help me to do it?
Thank you in Advance. -
I got what I was missing.
Thank you.Leave a comment:
-
Syntax Error (Missing Operator)
Hi All,
Can you please check what I am missing here
Thank you for your help.Code:DoCmd.OpenForm "saidhazard2", , , "[FK_SAIID] = " & Me!SAIID & "[FK_Haz_Cat_ID] = " & Me!FK_HazCatID
-
Thank you for your help.Leave a comment:
-
Text box (Unbound) to Date Type
Hi all,
I have a text box in form and it contains date (get value from combo box). Now I want to convert/change this text box to date type.
Is the anyway I can do it?
Thank you so much.
Shimul -
Thanks for reply.
It doesn't work.
Can you please check it?
Thank you.Leave a comment:
-
By the way, Week start "Monday and Week end "Sunday".Leave a comment:
-
Rolling 52 week criteria
Hi All,
I have query where i am getting result
Week Number -----------------Start_Date ------------------End_Date
2 ------------------------------2008/01/07 ------------------2008/01/13 11:59:59 PM
.
.
52 ---------------------------2008/12/22 -------------------2008/12/28 11:59:59 PM
But I want something like
Week Number ----------------Start_Date --------------------End_Date... -
Using query where i am getting result
Week Number -----------------Start_Date ------------------End_Date
2 ------------------------------2008/01/07 ------------------2008/01/13 11:59:59 PM
.
.
52 ---------------------------2008/12/22 -------------------2008/12/28 11:59:59 PM
But I want something like
Week Number ----------------Start_Date --------------------End_Date
2 -----------------------------------2008/01/07...Leave a comment:
-
Calculate end date
Hi All,
If I set up a form with start date (choose from calendar) and end date. Each week Start date (Monday ) and want to automatically calculate end date (sunday each week) . how can I calculate an end date field and place it in the form,
It really giving me hard time, can someone help please?
As example start date : 2008/12/08, end date : 2008/12/14
Thank you.
Shimul -
Set Value of ComboBox in VBA
Hi all,
I have combo box where I can choose week number (but it show also start and end date(call week number)) and also have end date(called edate) combo box .
Now i want to something, when i will choose week number, end date will be show up in edate combo box.
Example: when i select "1" in week number combo box, otherbox (edate) will show 2009/01/04
is it possible?
... -
Thank you Nico.
I will check it and let you know.Leave a comment:
No activity results to display
Leave a comment: