Drew Wutka
DWUTKA at Marlow.com
Fri Aug 26 15:21:27 CDT 2011
First, on your P.S. part.... why make 1000 pages with different info with HTML? Sounds like you should have just had one page, with a server side script to change what the user gets. As for Access being your 'Leatherman', I hear ya, I'm at a cross roads right now, VB 6 was my 'programming' Leatherman for quite a while, but .Net is starting to eclipse that. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte Sent: Friday, August 26, 2011 3:15 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Freelancing Today, I typically use Access for only a handful of things. --Custom little widgets/tools I need personally because I don't want to buy something or can't find exactly what I need(my own little task tracker). --Many times I will get a batch of files (xls,txt) that need to be put into SQL server...each time different files, different data, different server...I'll open up a form, create a button and use vba to do the looping, importing, exporting etc...go to lunch and my 500 files are now 1 file ready for SQL server. --I also use it to do a quick 'mock-up' of how an app will look and how the data will come out. Pretty much anytime I need to do a 1 time automation type task...I use Access...(my boss uses Foxpro in the same fashion). Not sure how I ended up here...but its where I am and Access helped pave the path. (and I can bring my dog to work!!!) Just my 2c. Mark A. Matte P.S...Just remembered a cool one. Need a little over 1000 html landing pages with pretty much same content, just different label name and different link...loaded all the variables in access...VBA loop to open template.html as text ...search and replace with variable...save as variable.html...10 minutes=1000 custom HTML pages...I thought it was kinda cool. > From: ssharkins at gmail.com > To: accessd at databaseadvisors.com > Date: Fri, 26 Aug 2011 15:34:54 -0400 > Subject: Re: [AccessD] Freelancing > > > It's Access -- the work for Access developers is disappearing. :( > Consider SQL Server. Don't forget apps for smartphones -- big business > right now. I'm not sure anyone's getting rich, but it's something to fill in empty hours! > > Susan H. > > > > Hey Susan > > Your article was an eye opener. > > I have been producing database applications for over 20 years. No > > ego being inferred but I figure I have produced quality products > > that are 99.9% bullet proof (many are still in use today). But I > > feel I am going the way of the dinosaur. Since the 2008 recession I > > have found that most companies no longer want to spend money to save > > money (no matter want you do to try and convince them of such). To > > be honest, on my end, the market is drying up. > > I > > am kind of looking at leaving ACCESS and starting to develop > > customized iPad/iPod (whatever) "Apps" for clients. If that doesn't > > work then I will be buying a "Weenie" wagon and hanging out at the > > beach. Not a boo hoo scenario, just reality. > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.