Search results

OK, this is what I have done, Private Sub PrintInvoice() Dim strfullpath As String Dim varfolder As String varfolder = "S:\NATIONAL HOTELS\99 Project Database\Files\InvoiceApprovals\" strfullpath = varfolder & Me.InvNo & ".pdf" DoCmd.OutputTo acOutputReport, "rptInvoiceEntry"...

Thank you sir, what I have done is, as I have no control over vendor names (quite possibly they will have /,& etc, I removed that portion of strFullPath, I will test again this morning, will update later

I'll test this tomorrow, but both machines do print to MS PDF under printer options Very frustrating......

Yes, other save functions work normal, only this one is the issue

Doesnt work on another PC as well...... Is there any alternative for this? DoCmd.OutputTo acOutputReport, "rptInvoiceEntry", acFormatPDF, strfullpath, True

Nope, didn't help...... Very strange.......I will try on a different PC later on to see if the current one has issues

Let me try.... Thanks

Yes, first thing I checked

Good morning chaps, Small Issue came up....... Private Sub PrintInvoice() Dim strfullpath As String Dim varfolder As String varfolder = "S:\NATIONAL HOTELS\99 Project Database\Files\InvoiceApprovals" strfullpath = varfolder & "\" & Me.VendorName & " " & Me.InvNo & ".pdf"...

HI JUne7, Thanks for the input, In the above attached DB, only look at query1, other ones are workings, testbeds etc AS you can see from the form, I have 3 dropdowns for property, and the only way this form works if I fix the column headings in the query setup (check out query1 setup, you...

Following from my other thread, I managed to create the crosstab query Pat was suggesting, DB attached Now, issue is the column headings and filtering I have inserted the criteria based on the form variables, and fixed the column headings (only way I managed to make it work.. as propertyIDs) -...

We are talking Nissan Patrols and F150 modified trucks here... They don't care

Where I live, UAE - Flashing lights from behind means get out of the way or I'll drive over you .... COnsidering that speed limit is 140 kmh on most highways, locals pass with on average 200.....

Continuing on this thread, I think I managed to create the crosstab query Pat was suggesting, DB attached Now, issue is the column headings and filtering I have inserted the criteria based on the form variables, and fixed the column headings (only way I managed to make it work..) - when I...

Hi Pat, Would you mind explaining above as if you would do to a kid? Queries/SQL etc are my very weak points, and although I understand th eprinciple behind, in practise no idea

Bob, worked like a charm.... and again quote marks...I need to study and learn this quotes.....but these days feel like Homer SImpson, when I learn somethig new, old stuff gets pushed out ;)

Hi Gurus, Me again, trouble maker .... Yet another Dlookup related problem... This is what I am trying to achieve...A table with propertyID/Year/Department/Position/Salary details to compare 3 property's salary details by department and Position. Created the form, in header you select the...

Well, instead of kicking, I banged my head on the keyboard..... same same..... Thank you CheekyBuddha

Hi guys, Me again, Trying to Dlookup a numeric value with 2 text criteria Me.BillingRate = DLookup("Rate", "tblBillingRates", "Category = '" & Me.Category & "'" And "Position = '" & Me.Position & "'") With above I get type Mismatch Error 13 and for love or god, can't understand why...