Monthly Archives: July 2009

Access Macros Are The Future

Posted on July 28, 2009 by Biggus Dickus

  Before anything else I have to admit that I came to the Excel and Access world from the User Community – I did not come to it from a background in professional programming.  So my first experience with automation … Continue reading →

Posted in Uncategorized | Tagged , , | 3 Comments

User Maintained Spreadsheet Applications Suck

Posted on July 27, 2009 by Biggus Dickus

I have one special application in Excel that I am especially proud of . This app has functioned for 4 years pulling data from a Data Warehouse using OLEDB and merging multiple data sources and using my work as the core of … Continue reading →

Posted in Uncategorized | Tagged , , , | 18 Comments

Offering Opinions

Posted on July 21, 2009 by Biggus Dickus

One of the things I learned a long time ago was “Don’t tell the client how to run their business !!”.   Some clients have taken that to mean not even suggesting business process changes in and around the applications we … Continue reading →

Posted in Uncategorized | Tagged , , , | 1 Comment

Office 2010 Here We Come !!

Posted on July 20, 2009 by Biggus Dickus

Say what you want about the (Ef)Fluent UI (I love it when they don’t think through the possible bastardizations for a word – I especially liked “Back Orifice” – very clever), I think we have to accept that Microsoft has just … Continue reading →

Posted in Uncategorized | Tagged , , , , , , | 12 Comments

Information Consultants

Posted on July 17, 2009 by Biggus Dickus

I was talking to a client a couple of days ago and he said he would be willing to pay me from his own budget as an “Information Consultant” rather than as a provider of IT services.  I can see … Continue reading →

Posted in Uncategorized | Tagged , , , | 6 Comments

Monday, Monday …..

Posted on July 13, 2009 by Biggus Dickus

Over the past weekend I just thought of something that I have to do in the future.  I have to make sure clients do not arrange status meetings on projects for Mondays anymore !! This is because it ruins my weekend before … Continue reading →

Posted in Uncategorized | 11 Comments

Walking and Chewing Gum

Posted on July 10, 2009 by Biggus Dickus

I am very thankful for the thoughtful discussion of the previous thread.  Firstly it shows the influence of Mr. Murphy on our community as he has single-handedly woken up my Blog – thank you my friend. Secondly I find that … Continue reading →

Posted in Uncategorized | 3 Comments

The Earth Is Shifting Under Our Feet

Posted on July 7, 2009 by Biggus Dickus

I have been an independent spreadsheet developer for 25 years and an independent Access developer since 1992.  In that time I saw my rates triple and the billable hours sustained to the point where  I was able to consider myself a “professional” of … Continue reading →

Posted in Uncategorized | 15 Comments

Thoughts On Access and SQL Server

Posted on July 3, 2009 by Biggus Dickus

I am working on some stuff today using SharePoint Lists with an Access Frontend.  Frankly the reason I am using SP Lists is because this particular client’s IT department won’t allow Access going against SQL Server (a common problem).  SP … Continue reading →

Posted in Uncategorized | Tagged , , | Leave a comment

Things To Know When Using Sharepoint Lists In Access

Posted on July 2, 2009 by Biggus Dickus

I just found out an interesting thing to remember when uploading data from Access (or Excel) into Sharepoint Lists.  If the tables were originally exported from Sharepoint lists into Excel or Access, Sharepoint exports ALL FIELDS in the source including … Continue reading →

Posted in Uncategorized | Tagged , , | Leave a comment