20 years ago, I developed a Pawnshop Management application with Informix-SQL. Most of my users also have Microsoft Office 2003, '07 and '10. My app exports data to a text file which Excel and Word pick up. I would like to convert my ISQL-based app to Access 2010, so that I can have direct integration with Word and Excel via VBA, but I'm not familiar with VBA or object-oriented programming. I've been inside a 20 year ole time-capsule and only know procedural 4GL type programming languages.
I acquired a book called "Access 2010 Inside and Out" from Microsoft Press, but the VBA part boggles my mind, so I need help!
I would like for the Access version of my app to retain, as much as possible, the same functionality and logic as my ISQL-based version in order to minimize the impact of having to retrain my users. Examples: I want to disable "On-Focus" on all data entry fields so that users are forced to follow the same tab order used in my ISQL app and not wander around the forms. This is how it works in my text-based forms.
There are other features not available in the ISQL text-based interface that I would like to provide for my app and need to know if its possible to do in Access. The list of features is too long to describe here, so this would have to be carefullhy analyzed. Is there another forum or site for addressing these issues?