If the Comb_box data is from a file then use the
Default Value property to point to a record and field
eg.
Default value=DLookUp("mgtDOCTXT","MEMREG","mgtDOCNAME = 'MG01'")
you can easily maintain the default record "MG01" field value of file a General...
mthno:Format("03 jan 2003","mm")
mthno:Format([TRANSDATE],"mm")
use the mthno as a field in the query and then use this field as the sort and group break on mthno field
execute the docmdone after the other eg.
docmd.openreport "rpt1"
docmd.openreport "rpt2"
docmd.openreport "rpt3"
msgbox "end of 3 report"
you may want to add a new printer driver on you PC that has setting as the correct prefered paper/tray or as default setting.
So that you can set this new printer as default printer in you system before you run your application.
This may help
Use the Report header section
and place 3 Page break icon from the tool bar, one after another.
or create a 1/2 inches space in the report header section.
set you regional measurements to U.S. to get inches scale
dot matrix 1" = 6 lines
I do not know why you need to advance/page 3...
I coding hope this helps
' I assume -1 is on lazy to check
'---------------------------------
Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
me!LABOR.Visible = False ' default as invisible
me!Material.visible = False
If Form!frmprintselection!Check1...
Create a blank line textbox object and a line counter
Make the text box visible after every 5 line counter
use can shink can grow property at detail section
mvCNT = mvCNT + 1
If mvCNT > 5 Then
me!txBLANK.visible = true
mvCNT = 1
else
me!txBLANK.visible = False
end if
Hope that helps
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.