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 Rhinorhino 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: slackboy
  • Content: Threads
  • Order by date
  1. slackboy

    calculate in Excel query

    Im extracting data from Sage L500 using excel and query. My order table holds credit notes as a positive value, it just marks them as 'CN'xxxxxx So what I want is, val*-1 if Order_no begins with 'CN' else val Anyone know if this can be done via msquery criteria?? Cheers Slacky
  2. slackboy

    Outlook Dials up a connection

    When offline in Outlook my computer dials up the network, sends/receives mail and then disconnects - Fine. 30 Secs later it redials and connects again automatically. Have checked send receive settings in Outlook it is not set to redial after set time etc, where else could be relevant settings pls?
  3. slackboy

    Router attached to 2nd NIC

    On SBS4.5 We are attempting to connect ISDN router to a 2nd NIC in server. After using the wizard we have experienced problems with DHCP and internal network browsing from Server. We can ping external ip addresses but not internal addresses from server. Nodes on network are able to ping the...
  4. slackboy

    Defer Page Headings on Report Footer

    Previous artricle almost gives me this by... If me.page < 5 then pageheader.visible = True Else..... as above = False This is fine if you know how many pages in report, My report will be diff each time ?How do I amend to make this dynamic. ps I need Page Headings on all pages but Report Footer...

Part and Inventory Search

Back
Top