Hi Folks,
Over the last 10+ years I have created a host of Microsoft Access programs, most of them requiring users to input data into forms as a means of data collection ... some of the forms use drop down boxes, list boxes, codes to check for errors, macro kick offs, input masking, and what not and others are just simple forms. The forms work well and for the most part most of the users just upload the databases on a monthly basis, so it does work but is not real-time data collection.
I am investigating maybe placing a few of the database forms online and linking them to a SQL server with the appropriate security; so that, I can just send these data entry users a .html file and whatever they enter into the form will be stored onto SQL server thereby making this collection as much real time as can be and eliminating the need for monthly uploads, and even maybe eliminating the need for them to have Microsoft Access.
I have noticed that Microsoft Access does have the ability to export forms to a .html ... my question is, what is the best and easiest way to create something as described above without losing such things as drop down boxes, macros, and whatever other code or extras is on some of the forms? If Microsoft Access' automated export of a form into .html is the easiest and fastest way, is it possible to alter that .html to add such items as drop down boxes and macros as it is in the regular forms? Although if I must, I will investigate visual basic as a means to create such forms whether that be on the internet or stand-alone .exe program with a odbc link in the code to SQL ... however, I am just curious if there is a fast and easy way to do this and perhaps one where I won't have to learn a lot of new techniques to make it happen?
Thank you,
Joe
Over the last 10+ years I have created a host of Microsoft Access programs, most of them requiring users to input data into forms as a means of data collection ... some of the forms use drop down boxes, list boxes, codes to check for errors, macro kick offs, input masking, and what not and others are just simple forms. The forms work well and for the most part most of the users just upload the databases on a monthly basis, so it does work but is not real-time data collection.
I am investigating maybe placing a few of the database forms online and linking them to a SQL server with the appropriate security; so that, I can just send these data entry users a .html file and whatever they enter into the form will be stored onto SQL server thereby making this collection as much real time as can be and eliminating the need for monthly uploads, and even maybe eliminating the need for them to have Microsoft Access.
I have noticed that Microsoft Access does have the ability to export forms to a .html ... my question is, what is the best and easiest way to create something as described above without losing such things as drop down boxes, macros, and whatever other code or extras is on some of the forms? If Microsoft Access' automated export of a form into .html is the easiest and fastest way, is it possible to alter that .html to add such items as drop down boxes and macros as it is in the regular forms? Although if I must, I will investigate visual basic as a means to create such forms whether that be on the internet or stand-alone .exe program with a odbc link in the code to SQL ... however, I am just curious if there is a fast and easy way to do this and perhaps one where I won't have to learn a lot of new techniques to make it happen?
Thank you,
Joe
