@vbaInet No I want it to be on all pages except for the fourth I want nothing on it and i want the header not to appaear on the first page of each records report . and @boblarson I will move it to the format event thanks.
Hi I am ran into a snag on one my of reports. I have a batch report packet by record that I do on a daily basis. The problem I have is one of the reports in the packet will not print dual sided properly. The report in question has 3 pages leaving the back of the third page blank. When I printed...
Done and it worked. Uploading new copy as well. Now to figure out how to get it to display aa, bb, cc, after the letter z then this young access Jedi will be happy. How may I proceed next....other than the cosmetics of course. :)
here is the sample when you launch the report you will get 3 prompts
the first one just type in your name
the second one type in 1
third one type in 3
the last 2 have to do with the page numbering. There is some vba involved with this report as well feel free to check it out if you like...
OK did that. Apparently you have to change its name in the property sheet and not just change the label name. Prompt went away and it sorta works now but once it it passes z it displays other weird symbols and it only works when I change the running sum to over all. I may have to check my...
I do with a contol source of "=1"but when I made the second text box with the =Chr(96 + txtCount) and ran the report it prompts me with a parameter with txtCount as its name and if I don't enter a varible in it I get #ERROR when the report opens up and if I do enter a variable lets say 1 it...
Yes,
I need it to reset at the beginning of a each group. If it goes past z then it should start as aa, bb cc dd etc. Each group is going to have 40ish records in it.
Hi,
I am attempting to "letter" records on a grouped report to look like this
a. house
b. car
d. tree
I tried tweaking the numbering version of it but it was a fail. I attempted this and only got 1 forty times instead of 1-40 this was by using a textbox and entering =1 into its control...
Mine uses vba but when you click yes it opens a form and when you click no it just closes. my issue is when it opens the form it opens it in normal view which is cool but I would like it to open in add mode instead. Any ideas?
here is my lovely message box
Private Sub DailyReportmsgbox1()
Dim...
I don't know if you are checking this thread anymore or have found the same solution
but here is the code i used and i will include the link to where i found it with step by step instructions on how to place it in your report
Option Compare Database
Dim DB As Database
Dim GrpPages As...