Rocky Smolin
rockysmolin at bchacc.com
Mon Mar 28 10:40:28 CDT 2011
I wrote a rather elaborate piece of code behind an Excel 2003 spreadsheet to update data in an Access mdb. Actually the project was to export data from the Access based accounting system to a real complex spreadsheet, which would allow the user to tweak all the numbers, then, when she got it the way she wanted it, import the data from the spreadsheet back into the Access back end. It was all sorts of fun. So I've got the framework and techniques. I'll give it a shot. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Janet Erbach Sent: Monday, March 28, 2011 8:12 AM To: Access Developers discussion and problem solving Subject: [AccessD] 'Hidden' form question & Excel 2010 question Hello - I have 2 questions for you all. 1) We use a pre-packaged access application for order processing: I've created a number of custom forms and modules that I export to a 'customizations' data base and import into the main app whenever I install it to a new machine. I have one form that seems to export successfully - I get no error messages, anyway - but when I open up my 'customizations' data base it can't be found. I've checked to see if it was somehow set to be hidden, and that's not the case either. I tried exporting it to a temporary data base, and it appeared there just fine. But I need it to go into this 'customizations' data base, and it just won't go! What could be causing this? 2) Do any of you have any experience writing VB code for Excel 2010? A tech temp agency in our area is looking for someone with that kind of experience for a specific project; if any of you are game for that type of thing, please let me know. Thank you! Janet Erbach IT/Office Manager Natural Healthy Concepts www.naturalhealthyconcepts.com 920.886.7500 * 866.505.7501 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com