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 Chriss Miller 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: tonyA1DL
  • Content: Threads
  • Order by date
  1. 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
  2. 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)...
  3. 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 !
  4. 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...
  5. 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...
  6. 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?
  7. tonyA1DL

    Modification Formula

    I have a field called "tax point" which is populated with a date from another field called "function date" when boolean field "account customer" is set to "y" Problem is sometimes we need to change the tax point to a date earlier than the function date...
  8. tonyA1DL

    Google DNS Problem

    am getting the following redirecion when loading Google any ideas - is this a genuine message from Google? how to fix ? Are you trying to get to Google? Your computer is running software that doesn’t allow you to use Google. You’re seeing this page because your computer is trying to send you...
  9. tonyA1DL

    Sound with Terminal Server

    Since going over to a W2K Terminal Server environment we have lost sound on the desktop (i.e. no beep when new email arrives). We are using locked down PCs as thin clients in this environment. I'm sure this is something very simple, any ideas would be much welcomed.
  10. tonyA1DL

    Scheduled (Timed) tasks

    does anyone know if there's any way of automatically running reports within Approach. We currently have a view containing macro buttons for Daily Reports, Weekly Reports and various ad-hoc reports, but these have to be requested manually. Ideally, I would like the daily reports to run, say, at...
  11. tonyA1DL

    registry error 2

    We have a Dell PowerEdge 2400 running NT4 Server SP6a The box has a single onboard NIC and we have just installed a second card (Intel PRO100) When updating bindings and when trying to go into TCP/IP Properties, am getting a Windows TCP/IP Registry Error 2, therefore am unable to assign an IP...
  12. tonyA1DL

    Cisco 1603 Router Setup

    We have inherited a 1603R Router minus software/manuals There is an IOS IP/IPX smartcard with the router, however when I connect it to the hub and power it up I cannot see the router on the network. I am not using the WAN card as I want to use the ISDN BRI interface only. How do I set up and...
  13. tonyA1DL

    Cisco 1603R Software

    I have inherited a second hand Cisco 1603R router - minus the software. Where can I get the software so I can get this router up & running?
  14. tonyA1DL

    data retrieval using the FIND button

    to access database records 95% of the time we search on a 6-digit URN field and have to: - mouse & click FIND button - mouse & click "URN" field - key 6-digit URN - mouse & click OK button - found set is displayed I want to simplify this to a macro, for example - press assigned...
  15. tonyA1DL

    Preventing Duplicate Records

    the "unique" function prevents duplicates on a single field basis, however how do I prevent duplicates across two fields the particular example is a six digit customer number must be unique at each site, however the same customer number may co-exist at a different site. any help...
  16. tonyA1DL

    Relational database problem

    we have one database for "jobs" (allocated and to be allocated to suppliers) and another database for suppliers. in the main view of the "jobs" database, we select the "supplier" who will be allocated the job within the suppliers database there is a...
  17. tonyA1DL

    W2K Terminal Services - Application Server Mode

    we recently installed a thin client LAN solution, running Windows 2000 in Application server mode on a dedicated server (separate to our back office box) on the client PCs we are getting weird and wonderful colour refreshes - how can this be overcome? (the servers are in the same building as...

Part and Inventory Search

Back
Top