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
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)...
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 !
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...
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...
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...
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...
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.
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.