Search results

Hi, Thank you for the suggestion. Currently, all clients have the same headed report. Based on one particular client, I want a report with a different header format just for him. Is that possible without any VBA? Thanks.

I don’t want other’s report to display this guy’s company logo. I’m thinking somehow distinguishing his from others using a tick box in form entry.

I have a single database producing the same report template for different clients. But one of the clients now wants his company’s name displayed in the header section for his reports. How do I do this without affecting other’s report format?

Thank you very much. The following code works perfect for me: DoCmd.OutputTo acOutputReport, "rptPrnTH1TH2", acFormatPDF, "C:\Users\Shree\Desktop\NKToEmail\" & Trim(Me.Firstname) & " " & Trim(Me.Surname) & "_TH1TH2.PDF" Many thanks.

Brilliant! I was missing the me.name How do I get a space or an _ between the first and surname? Thank you.

I have a form used to run a report. I have managed to output the report in pdf form by using the following VBA: DoCmd.OutputTo acOutputReport, "rptPrnAuto", acFormatPDF, "C:\Users\Shree\Desktop\NKToEmail\AutoAb.PDF" But I want to replace the generic AutoAb.pdf with the Firstname and surname...

The surname will be patient's surname. Each report is based on an individual query. Is there anyway saving the pdf of report with the surname of the patient automatically filled in.... eg: If patient's surname is Trump, then save this report pdf as Trump****.pdf?

Yes. Unique name solves the problem. The new code is as follows: Private Sub Command127_Click() On Error Resume Next DoCmd.OutputTo acOutputReport, "rptPrnAuto", acFormatPDF, "C:\Users\sreem\Desktop\RIC_RptToPdf\AutoAb.PDF" DoCmd.OutputTo acOutputReport, "rptPrnCyto", acFormatPDF...

So designate each report with a unique name?

I want to click a button and various reports are automatically saved to my desktop folder in pdf format. I can get to output pdf but have to manually save into the folder for each report. The code I had written isn't saving at all.... where am I going wrong with this code: Private Sub...

Hi, can someone please remind me how I can close a parameter query without having to close the entire database and reopen again? [Alt] [f5] ?? Many thanks.

Basal field, for example, can be 6. Then the Ctl50_1 field must be at least more than 8. If we say that the Ctl50_1 value was 9, then the Ctl25_1 field must have a value of 8. The Ctl12_1 value can only be 7. But I think I solved it by modifying the code of Ctl12_1 before update as follows: If...

Thanks for the reply pbaldy.Tried it but even when I type in the correct value in the Ctl12_1 field of the form, the msgbox appears and the curser stays on the field, thereby preventing me from going to the next field of the form. I am convinced the problem is the code below highlighted brown...

Please help: I have three fields in a form; Basal (this is the background reading of a blood test) Ctl50_1 (this should give the highest reading in all patients tested and must be more than basal) Ctl25_1 (this must be a value less than 50_1 but more than basal) Ctl12_1 (must have a value less...

Hi vbaInet, Please look at my post http://www.access-programmers.co.uk/forums/showpost.php?p=1140033 Any advise from you would be greatly appreciated. So far no luck in the forum for this.

Yes, that works. Thanks very much NickHa. Never came across the Nz function in any of the vba books. Once again, many thanks.

I have a database with a form containing three fields (Basal, ctl50_1 and ctl25_1). The user will have to enter blood test results(numerical) to all of the three fields per patient. I am bit of a novice at VBA, but here is the code I wrote to ensure that the ctl50_1 value is always higher than...

I did manage to use the validation rule on the filed property to get the desired effect. Thanks Dave. But can I perform the same with VBA script? I think writing code with VBA rather than altering validation rule on the property pane would prove more flexible in the database. I am at a loss as...

Thanks John. That works. But the problem is the form in question is one of seven tabs form. So even if there is no need to fill in that particular tab form, on saving any of the other forms, the msgbox appears asking to fill in a,b,c & d. Any help on how to avoid this?

I have a form where the user has to enter numbers in four fields. If we assume these number fields to be a, b, c and d. But I need to ensure (b-a) is higher than (d-c). So after update of the last input filed, I wrote the following vba: Dim a,b,c,d As Double If (d - c) > (b - a) Then MsgBox...