Go Back   Access World Forums > Access World > The Watercooler

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-30-2009, 04:31 PM   #1
speakers_86
I am jack's comment.
 
speakers_86's Avatar
 
Join Date: May 2007
Location: JBLM, Wa
Posts: 1,919
Thanks: 11
Thanked 158 Times in 119 Posts
speakers_86 will become famous soon enough
Do you program for a living

I just want to know if anyone here programs for a living. Do you use VBA?

__________________
If you look, you can find anything.
Google is your friend.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


~~~~~~~~~~~~~~~~~~~~~~~~~~~
Access 2010 screw this! I went back to 2007
Windows 7
speakers_86 is offline   Reply With Quote
Old 04-30-2009, 04:45 PM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 32,875
Thanks: 12
Thanked 4,033 Times in 3,970 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Do you program for a living

Define "program". I'm IT Manager,responsible for everything, but around 50-75% of my time is building/maintaining Access applications. That is by and large what gives me the most value to the company. I use VBA extensively.
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Old 04-30-2009, 04:52 PM   #3
jsv2002
Newly Registered User
 
Join Date: Feb 2009
Location: Northern Ireland
Posts: 240
Thanks: 0
Thanked 3 Times in 2 Posts
jsv2002 is on a distinguished road
Re: Do you program for a living

Well I'm an electrical engineer but have been a "programmer" since my first Sinclair ZX80 and have created databases for pretty much every company I have worked for... to be honest its only lately I've taken myself seriously as a developer because some of the databases I've left "in the field" I've been asked to improve on and maintain

__________________
The possibilities are endless the results are always the same.... it either works or you start screaming at the screen in frustration
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jsv2002 is offline   Reply With Quote
Old 04-30-2009, 05:06 PM   #4
ajetrumpet
Banned
 
Join Date: Jun 2007
Location: Universe - Local Group - Milky Way Galaxy - Orion Arm
Posts: 5,640
Thanks: 0
Thanked 98 Times in 45 Posts
ajetrumpet has a spectacular aura about ajetrumpet has a spectacular aura about
Send a message via MSN to ajetrumpet Send a message via Yahoo to ajetrumpet
Re: Do you program for a living

Quote:
Originally Posted by pbaldy View Post
Define "program".
LOL!!!! Need Paul say more? This just screams the answer "DUH".


As far as what I do, I know a he** of a lot about programming, but I've never had the opportunity to use my skills in a work setting unfortunately. So no, I don't.
ajetrumpet is offline   Reply With Quote
Old 04-30-2009, 05:25 PM   #5
speakers_86
I am jack's comment.
 
speakers_86's Avatar
 
Join Date: May 2007
Location: JBLM, Wa
Posts: 1,919
Thanks: 11
Thanked 158 Times in 119 Posts
speakers_86 will become famous soon enough
Re: Do you program for a living

I think I should change my major to IT. I like working on db too much.
__________________
If you look, you can find anything.
Google is your friend.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


~~~~~~~~~~~~~~~~~~~~~~~~~~~
Access 2010 screw this! I went back to 2007
Windows 7
speakers_86 is offline   Reply With Quote
Old 04-30-2009, 05:38 PM   #6
Mike375
Newly Registered User
 
Join Date: Aug 2008
Location: Sydney Australia
Posts: 2,464
Thanks: 2
Thanked 12 Times in 11 Posts
Mike375 will become famous soon enough Mike375 will become famous soon enough
Re: Do you program for a living

Since about September last year I moved to selling what I could make in Access and also some Excel plus a lot with file management via VBA, backup systems, email and similar.

I did it part time for several years while I was in insurance and to other insurance people. But last September I decided to have a go at it full time.

Not that different to insurance. You gather a list of prospects and go for it. The average sale is less money than insurance but much easier and generates referrals very easy.

But in my limited experience doing it for a living (only about 6 months) the money is not in full DBs. They take too long and it is an ongoing thing, never stops.
Very easy, quick and good money converting Excel stuff to Access. Lots of small businesses have an xls file for every month. They think you are a miracle worker.

In short, the opportunities with stuff are unreal. And when you canvass for your business you only wind up with the areas you can do or want to do.
Mike375 is offline   Reply With Quote
Old 04-30-2009, 05:43 PM   #7
Mike375
Newly Registered User
 
Join Date: Aug 2008
Location: Sydney Australia
Posts: 2,464
Thanks: 2
Thanked 12 Times in 11 Posts
Mike375 will become famous soon enough Mike375 will become famous soon enough
Re: Do you program for a living

Quote:
Originally Posted by speakers_86 View Post
Do you use VBA?
Missed that part. Both yes and no. For some things you have to use VBA. But I use macros a lot and for speed in making plus some other reasons. But if it is to be an MDE then no macos because you can get to them.

Mike375 is offline   Reply With Quote
Old 04-30-2009, 05:53 PM   #8
Banana
split with a cherry atop.
 
Join Date: Sep 2005
Posts: 6,315
Thanks: 0
Thanked 90 Times in 72 Posts
Banana is a name known to all Banana is a name known to all Banana is a name known to all Banana is a name known to all Banana is a name known to all Banana is a name known to all
Re: Do you program for a living

It used to be "Other duties as applied" for my last job.

I'm so glad it's not the case anymore.
__________________
If relation-valued attributes and arbitrarily complex types are wrong, then I don't wanna to be right!
Founder of 'Blame the Developers First' crowd.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Banana is offline   Reply With Quote
Old 04-30-2009, 05:59 PM   #9
speakers_86
I am jack's comment.
 
speakers_86's Avatar
 
Join Date: May 2007
Location: JBLM, Wa
Posts: 1,919
Thanks: 11
Thanked 158 Times in 119 Posts
speakers_86 will become famous soon enough
Re: Do you program for a living

I made a db for a water damage company a while ago. I posted a video in a post called "see my db". I really think I could sell that to restoration companies, but no one has any work right now. I called many different restoration companies today, no one is hiring. I did met with the owner of a local Serv-Pro. I could tell I impressed him, but they already have a full staff (only 2 techs!). One of those techs is new, so if he doesn't work out, I expect them to call me. I digress.

@ Mike-how do you handle integrating accounting software with your databases? This is the problem with my water damage software. It tracks work orders, equipment, and creates invoices, but is not a full fledge accounting db. I am now looking at the quickbooks SDK, but I am not sure if that is the best method to use (not all companies use quickbooks, each year the software is different, etc.). I do not want to make my db a full fledge accounting db, though I am kicking the idea around.
__________________
If you look, you can find anything.
Google is your friend.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


~~~~~~~~~~~~~~~~~~~~~~~~~~~
Access 2010 screw this! I went back to 2007
Windows 7
speakers_86 is offline   Reply With Quote
Old 04-30-2009, 06:41 PM   #10
sportsguy
Finance wiz, Access hack
 
sportsguy's Avatar
 
Join Date: Dec 2004
Location: Boston, MA, USA
Posts: 341
Thanks: 4
Thanked 1 Time in 1 Post
sportsguy has a little shameless behaviour in the past
Re: Do you program for a living

i program access most times, as the oracle programmers take months to do what i can do in access in a few hours for data analysis and reporting. VBA is a requirement for custom data transformations due to the multi dimensional data sets. . I also write scripts in Hyperion Essbase as I designed a forecasting system in Essbase for 12,000 employees, almost to the employee level, with all the revenue and cost of sales and expense drivers. . . took six months to design and about 6 months to implement cleanly. . .

but i work for a large, intl life safety company. . .
sportsguy is offline   Reply With Quote
Old 04-30-2009, 06:43 PM   #11
Mike375
Newly Registered User
 
Join Date: Aug 2008
Location: Sydney Australia
Posts: 2,464
Thanks: 2
Thanked 12 Times in 11 Posts
Mike375 will become famous soon enough Mike375 will become famous soon enough
Re: Do you program for a living

Quote:
Originally Posted by speakers_86 View Post
@ Mike-how do you handle integrating accounting software with your databases? This is the problem with my water damage software. It tracks work orders, equipment, and creates invoices, but is not a full fledge accounting db. I am now looking at the quickbooks SDK, but I am not sure if that is the best method to use (not all companies use quickbooks, each year the software is different, etc.). I do not want to make my db a full fledge accounting db, though I am kicking the idea around.
In Australia the main one is called MYOB (and short for Mind Your Own Business)

Most of my prospects are small businesses and If I have success then MYOB is dumped. But I am not selling a DB as such. I did do that in the insurance business, I sold what I had with some changes etc. But not now.

Accountants in Australia are geared for either MYOB or Excel. When I dump MYOB and replace with Access I have it so it will output to Excel. Most people I see with MYOB do double entries. They produce and invoice, either hand written or in Word and then enter details in MYOB. I eliminate that problem. A lot of what I make is based on Access to Word.

But I don't take on challenges, don't have to as there are millions of prospects and even with our small population.

There are two ways to make a living with the keyboard. One of course is to have a job. The other is to be self employed and they are two different things in regards to knowledge. Having the job requires a much broader knowledge. Being self employed is more about a narrower knowledge but it might run deeper, if you know what I mean.

If you are self employed you graviate to what you like. For me, I have always liked a real lot the Access to Word and to a lesser extent Access to Excel and Access to Email. You then prospect and canvass in areas where that will be appreciated. Basically, my prospect is a business where each of their customers means a lot. My stuff is of no use to the retail type outlet as they would be doing well to even know the first name of 1% of their customers. They are into inventory, scanning items etc.

Another interest of mine is fixing shit data. Lots of stuff in one column and phone numbers in all sorts of formats etc. My interest in that area came from fixing name lists we would buy for canvassing for insurance. The sort of prospect I see often have that issue.

Self employed is where you will make the money. However, your real business will be salesman and what you make is the product. Actually, you are the product. The prospect buys you.

Decide what you like about Access and what can be done. Where forums like this are very good is the fact that scenarios are put up by people and in most cases they don't have much of an idea. I pick different ones and then see if I can solve the problem. That does not mean posting the solution but just solving it.
Mike375 is offline   Reply With Quote
Old 04-30-2009, 06:44 PM   #12
sportsguy
Finance wiz, Access hack
 
sportsguy's Avatar
 
Join Date: Dec 2004
Location: Boston, MA, USA
Posts: 341
Thanks: 4
Thanked 1 Time in 1 Post
sportsguy has a little shameless behaviour in the past
Re: Do you program for a living

what is a hot industry to be in, is Hyperion Essbase and Planning, which is much cooler than sql tables. . . and working in an external hosting and maintenance facility. . . Alot of mid size companies don't want to internally staff the resources to operate and maintain specialty software when experts can be used with a service contract.

just a thought.
sportsguy is offline   Reply With Quote
Old 04-30-2009, 07:06 PM   #13
speakers_86
I am jack's comment.
 
speakers_86's Avatar
 
Join Date: May 2007
Location: JBLM, Wa
Posts: 1,919
Thanks: 11
Thanked 158 Times in 119 Posts
speakers_86 will become famous soon enough
Re: Do you program for a living

I have never even heard of MYOB stateside.

I take it you don't do much to streamline or automate the synchronization between access db and accounting software.
__________________
If you look, you can find anything.
Google is your friend.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


~~~~~~~~~~~~~~~~~~~~~~~~~~~
Access 2010 screw this! I went back to 2007
Windows 7
speakers_86 is offline   Reply With Quote
Old 04-30-2009, 07:40 PM   #14
Mike375
Newly Registered User
 
Join Date: Aug 2008
Location: Sydney Australia
Posts: 2,464
Thanks: 2
Thanked 12 Times in 11 Posts
Mike375 will become famous soon enough Mike375 will become famous soon enough
Re: Do you program for a living

Quote:
Originally Posted by speakers_86 View Post
I have never even heard of MYOB stateside.

I take it you don't do much to streamline or automate the synchronization between access db and accounting software.
No, just dump MYOB or have nothing to do with it. It is the same type of program you have in the US. You can buy at different levels to suit different business sizes and then pay to go to a course on what you bought.

A lot of small business is happy to leave it and spend the money on other things. For example, tomorrow morning (Saturday here) I am delivering some Access to Word stuff and also file management. This small business uses MYOB but the owner said "he was happy in spite of limitations BUT a problem I do have is etc and etc."

In short, I don't sell a basic DB that is in place and then adapt it etc. About the best your own DB can do is to be your instruction manual as you will have done a lot to get it running.

But bear in mind that my views are framed from being a salesman with two salesman working for me. If my knowledge was at the level of some of the other members it would probably mean we would only need to make 80 calls instead of 100. But the time and energy to get that knowledge would mean no calls were made for a couple of years
Mike375 is offline   Reply With Quote
Old 05-01-2009, 12:16 AM   #15
Rich
Newly Registered User
 
Rich's Avatar
 
Join Date: Aug 2008
Location: searching the truth
Posts: 2,898
Thanks: 3
Thanked 2 Times in 2 Posts
Rich is on a distinguished road
Re: Do you program for a living

Hey Mick is your db normalised yet?

__________________
Amateurs...built the ark.Professionals...built the Titanic
Rich is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Delayed connection between VB6 program and Microsft Access database aquacool Visual Basic 3 04-28-2009 08:22 AM
Running a console Program wjburke2 Visual Basic 0 02-03-2009 08:49 AM
Running a VB comsole program wjburke2 VB.NET 0 02-03-2009 08:46 AM
Run queries with VBA Ironis Modules & VBA 10 12-12-2002 11:12 AM
Continual running program??? NJudson General 2 07-19-2002 08:49 AM




All times are GMT -8. The time now is 06:56 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World