Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sngsng
  • Order by date
  1. sngsng

    Default value for Combo Boxes! Can it be done? Probably!

    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...
  2. sngsng

    Sorting Order

    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
  3. sngsng

    printing 3 different reports with 1 click

    execute the docmdone after the other eg. docmd.openreport "rpt1" docmd.openreport "rpt2" docmd.openreport "rpt3" msgbox "end of 3 report"
  4. sngsng

    Anybody know anything about Printer Properties?

    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
  5. sngsng

    Is There A Way?

    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...
  6. sngsng

    invisible problem

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

    Breaks in Reports

    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

Part and Inventory Search

Back
Top