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.
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 “ .
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...
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