Recent content by PhilE

  1. P

    Print Multiple Reports

    If u use the wizard to produce a button to print a report, all u need to do is to add additional pairs of lines for each report. i.e. Private Sub Command43_Click() On Error GoTo Err_Command43_Click Dim stDocName As String stDocName = "Report1" DoCmd.OpenReport stDocName, acNormal...
  2. P

    Conditional REMOVAL

    Try putting the field to be tested (City?) in a section of it's own, then use the on format event of the section to hide or show other fields/sections...
  3. P

    "Advanced" report

    You could read the query joined to both tables in code, & as a duplicate is read, then the first name could be added to a variable containing the already read entrie(s). When finding a different household/surname (i.e. onto next line in the report), write the variable string to a new table. Once...
  4. P

    Forcing an Open Form Closed in VBA

    I know of no way of stopping the events firing on closing the form, however.... you could include a global boolean variable in the events you want to stop such that.. if bCancelThisEvent then exit sub is added to these events and then the variable can be controlled from other code or...
  5. P

    Check Box and Combo Box Blank

    This is the old problem of bound data being updated and there is little control over it. Going unbound would be the best solution but it's a lot of effort, so instead you could try doing this on the clickevent of the tick box.. OnClickTickA If me!TickA then Me!ComboBoxA.enabled=true else...
  6. P

    Pass-through query

    I seem to recall this may be caused by SQL svr returning a summary even when no data is requested in return. One way is to set an option in the stored proc to inhibit a return if no data is to be sent back. My memory fails me but it may be called something like 'NoShow'??? in the Stor Proc Sorry...
Back
Top Bottom