Hi All
I posted a question on this subject yesterday but I can't open it now to read so I'll try again thinking no one else can read it either
I have an Access XP application I want to send out to multiple users. I've made custom menus, toolbars and Help files. I then convert the mdb to an mde file with only my menus, toolbars and Help files.With the mde file everything works great and user can enter new Customers, Territories, Jobs, Sales, Costs, etc., which update a master table. From this table, various queries generate detailed reports and classifies each customer as "A", "B" or "C" based upon specific programmed criteria. The mde file is packaged as a Runtime application using Office XP Developer
Here is my challenge
The package contains sample data so anyone new can see what all the various Text Reports, Pie Charts and Line Graphs will look like. There is a password protected "Reset" button that then allows all this sample data to be cleared so user can enter own data. Currently, all this data has to be loaded manually and this is a big drawback as this information is already contained in various databanks. I want the user to be able to batch load the table and then be able to update it monthly. Can anyone tell me how to do this from an Excel file I would have customer load with his/her data. The update information is expected to contain new customers, jobs, month, year, etc. Once the available data is batch loaded, only new data will be loaded each month to update the table. Can I set this up when the file is mdb and then will it work after converting to mde and packaged
This is a big issue and, while there is a lot of interest in this application, any requirement for manual loading of data already in existance will severely curtail its use. Any help or suggestions you could provide will be greatly appreciated. Also can anyone point me to any books or articles that might be helpful in this area
Than you
Willia
|
Similar Threads
