Search results

Can you give me the code?

Thank you June7 One last help if it is possible . If I want to add new button but instead of saving report in specified folder , I want to attach the report pdf automatically in new email message. I know "EmailDatebaseObject" macro can do that . However, I want the file name on attached email...

Perfect. However, I have small problem . The approval number is autonumber with format . The format is "2020-EXP-"0000 . So, if it 196. The number will show on report like "2020-EXP-"0196". However, when saved it will save as 196. How I make the file name to be including the format.

Sorry for late reply: C:\Users\user\Documents\Applications

This is the macro of the form button that open the report of the specific record.

so, I meant I choose output format to be pdf not output file. what shall I write on output file?

Hello The button are on the report itself.So, after the report is opened , I clicked on the button then I have to name it manually with the approval number and I have to select the folder where it to be saved manually as well. I did not use VBA code. I use Macro Builder specifically "...

To make things clear. The report has approval number field. So, each record has different approval number. How I make the file name of the report( in pdf) to be the “ approval number “ .

Can you explain further please?

Hello I have one report linked to specific record in form by using "tempvar" property which is applied to a button on the form. So when I click on the button I will get report for that record only not all the records. When report is opened , There is an other button that will export the report...

How I can do it Can you explain Further?

If I have query that give me specifc date from table . How I put row number for that data. for example , if it give me data of 5 rows , I want to add column for the rows ( from 1 to 5 ): 1 —— —— 2. —— —— 3. —— —— 4. —— —— 5. —— ——

no you misunderstand me. for example , If I select “England” from Combobox , I want thr default value of textbox to be “ london “. If I select other than England , I want the textbox to be empty

where I put the default value? for example if the default value is “ London “ , how I put it on the code?

Hello I have one form . I want one of the text boxs default value to be depends on combobox selection. How I can do it ?

where I put this code?

Hello, as you know when adding buttons on forms you can add many “ ready-make” buttons including duplicate record button. However, the duplicate button will duplicate all the values from the last record. Is there a way I make the duplication occur only for selected fields and make the other...

Thank you so much , I really appreciate it ! God bless you ! One last question , how I change the background of report table to white . Because at the moment is alternating ( white & grey ).

It works but I have one problem , headers of the sub report are not showing. see below: