I was forced into working with Approach a few years back(I wanted to use Access). I built a basic InventoryDB to track computer equip. My company became aware I had the best inventory system in use within the company. I was ask to install more functions. The DB tracks, POs, Invoices, Lease schedules, Loaned equipment among other items. I did not have help and could not find much available anywhere. I found out how to use macros and was able to establish some automatic functions. I started usingthe Mail macro, which will send out a copy of a form or report using email. I found the macro had limits and would not do everything I needed. I discovered the script coding and started doing simple scripts. I still needed functions like input form users. Example if a computer came back into the inventory room I wanted to make sure the inventory room location was updated on the DB. This done with script code. Same with input errors, one of my staff had a habit of hitting the space bar too many times so I added script to limit the number of spaces to one. I am presently working on a project to log all changes made to the DB. This information will be written to another file so I can review (and trace) any problems that arise. The scriptcode is not easy to work with at times because I am not a programmer but with some effort can be done. I really believe Approach is as good as Access and in some uses better. First it is easy to work with Approach to build simple DB structures, then if needed you can move on into more complex functions. During my second year of working with Approach I went to some training classes. I ask the instructors how to make Approach do certain functions and was told they did not know if things like Iask were possible. I would be happy to help you (if I can) with any questions you might have.
Ed p.s. I did not prof this so please excuse any errors.
