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!

Register Log in
  • Congratulations Mike Lewis 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: *

  1. EmptyMind

    dont print report if field1=null

    silly question, have you tried: stLinkCriteria = "[RMA nr]=" & "'" & Me![RMA nr] & "' AND '" & Me![field1] & "' <> Null" otherwise couldn't you base your report on a query that evaluates this from the form for you?
  2. EmptyMind

    Text Field and Report Calculation

    Try: =Avg(MakeMinutes([IWR NRwkly].Duration)) You may need to have the field name in square brackets because of the space. Also, if there are any null values you can convert them using the nz() function since the original format is text. ie: nz([IWR Fatwkly].Duration, "00:00:00")...
  3. EmptyMind

    Placing an object independant of report sections

    That's perfect dhookom, nice one. I wonder then if it is possible to use the same idea to place an object instead of text? Perhaps you could create the object from within the on_page code ? Flag works great though, thanks. ;o)
  4. EmptyMind

    Placing an object independant of report sections

    I have a report with various sections. It has a background image which is a map whose filename is decided by a query on another form. The report's 'On Load' event code tells the report to look on the form for the filename. All of the data on the form then prints over the top. Now I've got a...

Part and Inventory Search

Back
Top