Search results for query: *

Okay perfect. Thanks!

Thank you very much for your help. This does work, but at the end I do get a error message. But I also found that the PDF name is not generated from the report name, but from the CAPTION of the report. Do you know if I can change this to a certain field when opening the report? Thanks

Hi, Maybe a strange question, but I want temporarely copy and rename one of my reports and then delete it again via a button on my form. The reason for this is that I use Bullzip to print to the report to PDF. (http://www.bullzip.com/) Bullzip can save the PDF with the same name as the report...

[3eyes] ... Remou, your solution works perfect! I had put it on the Report/On Page event...[flush] Now I placed it on the Detail bar/On Format Event and it works perfectly... Thanks! (Damn I feel Noob [bomb])

It works! to good... [sadeyes] But thanks alot [sunshine] I'm a big step closer to were I want to be. The problem that I now have is: The report is as big as an A5 piece of paper, so it will print 2 on one page. Somehowe it now shows a page with or without 2x "scrap" even if one isn't scrap...

Hi, I'm using a report to print a label to put with defective parts we receive. Some of these parts need to be Scraped, if this is the case then I want in big letters "scrap" on the report. I want to use for this the same report that I'm also using for the non-scrap parts. The control of...

Cool!!! Thanks a lot! [pipe] Do you also know if there is an easy program to create a nice HTML for a Noob like me? [ponder]

Hello, I received an email of a customer and when you open it you see his name under the email "slide" in position... Is there an easy way to do this with my own footer? I copied this out of the sourch of the email, but I dont know if this is everything you will need to see what I mean...

I tested your cancel solution and IT WORKS! Thanks! [sunshine] Xiphias

Sorry roy, my fault! Here is it compleet: -------------------- Dim stDocName As String stLinkCriteria = "[RMA nr]=" & "'" & Me![RMA nr] & "'" stDocName = "Repair" stDocname2 = "NONCONFORMINGMATERIALFORM" stLinkCriteria1 = "Not [Serial number] Is Null AND" &...

You guys are quick [thumbsup] The monitor ID isnt the problem I think. But just now I also found something about the "No data" in the report. They advise to put "Cancel = true" when there is no data This works, but now I got an error box in the form that my report is canceled. Is there a way...

Hi, I have a little problem I cant fix, maybe one of you can help me. I repair monitors and made a form to fill in the details of the monitor. In a sub-form I fill in all the parts that I have used. For all the parts that have a Serial number on them there will be a separate form printed when...

Hi, If I use this ------------------------------------ Dim stDocName As String stDocName = "Repair" stDocName2 = Me.RMA_nr & ".SNP" DoCmd.OutputTo acReport, stDocName, acFormatSNP, stDocName2 --------------------------------------- to save my Repair Report, then it wil save all...

[spin] Yes its working!! This is going to save me loads of paper! I used the : stLinkCriteria = stLinkCriteria & " AND Not [field1] Is Null" I didnt checked the other solutions, but thanx anyway.. Have a very nice day! [wavey3]

Hi Cghoga Thank you for your reaction, but this isnt what I need. Because when I use the filter on the report( "[RMA nr]=" & "'" & Me![RMA nr] & "'") Then I got e.g. 10 records that are going to be printed, but a few of them have a...

Hi all, Im printing a report from a form. using a filter: Dim stDocName As String stLinkCriteria = "[RMA nr]=" & "'" & Me![RMA nr] & "'" stDocName = "Repair" DoCmd.OpenReport stDocName,acViewNormal, ,stLinkCriteria But I want to put an...

Hi, Sorry to bother you again, but I have a simuler question as above: After pushing a button on my form,a linked form(as dialogbox) opens where you can add a new name/address. After closing this box I would like to select the new record on the "main"form. It seems that that works a...

[rofl]YESSSSSSSSSSSSSSSSSSS!!!!!!!!!![rofl] Its working!! Thank you very much for your paticience!! [wavey2]have a nice day, Xiphias

I changed it and now I got a error on: rs.FindFirst "[Name]='" & nam & "'" Error is: Method or data member not found (Error 461) But I also changed: Me.Parent.Filter = "Name='" & nam & "'" And that is working perfect... CU Xiphias

Hi MakeItSo, [sadeyes]... it doesnt work... Just to be sure that I did it right: In the dubbel click event I put this: --------------------------------- Private Sub Form_DblClick(Cancel As Integer) On Error GoTo Err_Form__DblClick Me.Parent.Filter = "Name='" & Me![Name] &...