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!

Recent content by tonyA1DL

  1. tonyA1DL

    Problems with Date Formula

    Create a status field as a calculated field dependent on another keyed date field. We use the formula below to flag up whether electrical safety tests are current returns blank, retest due, expired or awaiting first test. I'm sure you can easily modify this formula to achieve what you need...
  2. tonyA1DL

    Approach 97

    we use Approach 97, probably quite an old version nowadays, the only problem is the screen handling during design, in particular reports and forms, where objects and screens jump about all over the place! Is this fixed in a later release? If so we will upgrade. Any help welcomed please
  3. tonyA1DL

    Database design query

    Many thanks Paul
  4. tonyA1DL

    Database design query

    Many thanks Paul, as always excellent advice, have developed, tested and implemented this afternoon! Just one small point, the repeating panel is sorted by date (descending) I.E. most recent communication at the top, HOWEVER the blank row to key a NEW communication is under the bottom (oldest)...
  5. tonyA1DL

    Database design query

    We have an events database on Approach currently 85MB with circa 22,000 records and growing rapidly every month. Our admin function is soon to become a twin site operation, using a VPN based WAN, therefore our customer communications logging (currently a manual process outside of Approach)...
  6. tonyA1DL

    Instant Messenger over TS

    I tried this once and it didn't work, remember the TS has a single IP address, so logically it can't work, or it would get confused with multiple users trying to log on.
  7. tonyA1DL

    PAF File

    Once again Paul, many thanks for your help on this Tony
  8. tonyA1DL

    PAF File

    The PAF software runs minimised and whenever it identifies a text string which matches a valid postcode on the post office address file, a window pops up with the option to accept (press enter) or reject (press minimise) Typically a user would press enter, it then populates the address fields...
  9. tonyA1DL

    PAF File

    Thanks Paul, however if I set the fields to Read Only, they won't accept the data populated by the PAF software. Tony
  10. tonyA1DL

    PAF File

    We have recently installed AFD Postcode (Post Office Address File Software) and populate address fields in Approach using same. How can I lock these fields down so that they can only be populated by the AFD software? I want to prevent users overkeying good PAF validated data with rubbish data !
  11. tonyA1DL

    Report Titles

    I have a report called "Advertising Analysis" and run/print various named find/sorts using it. I need to print the title of the report according to the named find/sort on the report, for example "Advertising Analysis - 2002 Brighton" when the named find/sort called...
  12. tonyA1DL

    Count function

    many thanks Paul
  13. tonyA1DL

    Count function

    I want to record in the database of subcontractors how many jobs they have been assigned (from the jobs database) I think I need a calculated field in the subcontractors database with a formula to count how many times they appear in the jobs database. However I am struggling as to the formula...
  14. tonyA1DL

    Google DNS Problem

    thanks all, Norton have now picked up on it too http://securityresponse.symantec.com/avcenter/venc/data/trojan.qhosts.html
  15. tonyA1DL

    How do I suppress Server Messages?

    have just changed a Laserjet from LPT1 to Jetdirect, how do I suppress the message sent from the server after every print job?
See more

Part and Inventory Search

Back
Top