Microsoft Access 2010 - Page 5 - Technology - Contractor Talk

Microsoft Access 2010

 
Thread Tools Search this Thread Display Modes
Old 05-16-2014, 03:33 AM   #81
Pro
 
macmikeman's Avatar
 
Trade: Master Electrican, Electrical Contractor
Join Date: Sep 2005
Posts: 391
Rewards Points: 306

Re: Microsoft Access 2010


So, for fun I can do some things no real coder would ever do.

On mouseup put ''10 inches'' into Sally.



Sally just became a local variable that contains the text 10 inches. I didn't have to declare Sally a variable. how simpler can it get? Lots.


Put ''BILLY'' into fld ''Agness''. Now drag out a field from the tools box and drop it onto the card canvass. Click on it and an inspector turns up , where you can name the field Agness. BILLY is now inside Agness.


I have a sick and twisted mind, at least that is what my Mom used to say........
macmikeman is offline  

Warning: The topics covered on this site include activities in which there exists the potential for serious injury or death. ContractorTalk.com DOES NOT guarantee the accuracy or completeness of any information contained on this site. Always use proper safety precaution and reference reliable outside sources before attempting any construction or remodeling task!

   

Advertisement

 

Old 05-16-2014, 03:34 AM   #82
The Dude
 
smalpierre's Avatar
 
Trade: home improvement
Join Date: Jan 2011
Location: Sunny South Florida!
Posts: 2,019
Rewards Points: 1,946

Re: Microsoft Access 2010


Visual Basic is considered event driven, and really almost any gui app regardless of language will be. The syntax looks like Visual Basic and Python got drunk one night haha!

I'm not sure how I like the no classes thing - they are extremely useful. Classes, inheritance, and pointers pretty much are indispensable. Classes aren't difficult, they just seem that way.

I'll find out more when I'm not delirious, and have time to play with it. I'm hoping it compiles executables instead of relying on distributing a runtime. That's one of my major gripes with Visual Basic, C#, and Microsoft's C++ for that matter the second you touch "managed code". Runtimes can only slow you down! It's one of my gripes with Java, but not by a long shot my biggest gripe with it.
__________________
"That somebitch looks like MANAGEMENT MATERIAL TO ME...I would have handed him another rod after he bent the first one." ~MAULEMALL
"I think he was grandmaster at a gay pride parade in san fran this week (not that there's anything wrong with that). " ~ J F
smalpierre is offline  
Old 05-16-2014, 03:37 AM   #83
The Dude
 
smalpierre's Avatar
 
Trade: home improvement
Join Date: Jan 2011
Location: Sunny South Florida!
Posts: 2,019
Rewards Points: 1,946

Re: Microsoft Access 2010


Quote:
Originally Posted by macmikeman View Post
On mouseup put ''10 inches'' into Sally
Thanks, now I've got to clean my drink out of the keyboard
__________________
"That somebitch looks like MANAGEMENT MATERIAL TO ME...I would have handed him another rod after he bent the first one." ~MAULEMALL
"I think he was grandmaster at a gay pride parade in san fran this week (not that there's anything wrong with that). " ~ J F
smalpierre is offline  
Sponsored Links
Advertisement
 
Old 05-16-2014, 03:39 AM   #84
The Dude
 
smalpierre's Avatar
 
Trade: home improvement
Join Date: Jan 2011
Location: Sunny South Florida!
Posts: 2,019
Rewards Points: 1,946

Re: Microsoft Access 2010


enough with the derailing ... Anybody got an extra copy of Access 2010 they'll donate to the development team? I don't want to pay $110 for it, I can't believe they even charge for it anymore - they've even got a free version of Sql Server!

30 day free trial is all I'm coming up with so far.
__________________
"That somebitch looks like MANAGEMENT MATERIAL TO ME...I would have handed him another rod after he bent the first one." ~MAULEMALL
"I think he was grandmaster at a gay pride parade in san fran this week (not that there's anything wrong with that). " ~ J F

Last edited by smalpierre; 05-16-2014 at 03:42 AM.
smalpierre is offline  
Old 05-16-2014, 08:35 AM   #85
Accidental Painter
 
Driftweed's Avatar
 
Trade: Who's paying?
Join Date: Nov 2012
Location: Evansville, IN
Posts: 2,292
Rewards Points: 1,262

Re: Microsoft Access 2010


Ok lets get organized fellas. First we have to develope a gameplan for whatever program we use.

Ill draw pics tonite, & then we can sort out code.
__________________
www.callbathdoctor.com
Driftweed is offline  
The Following User Says Thank You to Driftweed For This Useful Post:
smalpierre (05-17-2014)
Old 05-18-2014, 05:54 PM   #86
The Dude
 
smalpierre's Avatar
 
Trade: home improvement
Join Date: Jan 2011
Location: Sunny South Florida!
Posts: 2,019
Rewards Points: 1,946

Re: Microsoft Access 2010


Got some pics? Maybe something like what you want the screens to look like?

I've been trying to access a copy of Access to no avail ...
__________________
"That somebitch looks like MANAGEMENT MATERIAL TO ME...I would have handed him another rod after he bent the first one." ~MAULEMALL
"I think he was grandmaster at a gay pride parade in san fran this week (not that there's anything wrong with that). " ~ J F
smalpierre is offline  
Old 05-18-2014, 06:06 PM   #87
Accidental Painter
 
Driftweed's Avatar
 
Trade: Who's paying?
Join Date: Nov 2012
Location: Evansville, IN
Posts: 2,292
Rewards Points: 1,262

Re: Microsoft Access 2010


Yeah hang on I'll go to my drawing board. Got overwhelmed w/work & social stuff lasy fee days lol.

Just got caught up/sobered up
__________________
www.callbathdoctor.com
Driftweed is offline  
The Following User Says Thank You to Driftweed For This Useful Post:
smalpierre (05-18-2014)
Old 05-18-2014, 06:12 PM   #88
Accidental Painter
 
Driftweed's Avatar
 
Trade: Who's paying?
Join Date: Nov 2012
Location: Evansville, IN
Posts: 2,292
Rewards Points: 1,262

Re: Microsoft Access 2010


Can you read this?

Microsoft access 2010-forumrunner_20140518_181314.jpg

Maybe faster to just pic everything
__________________
www.callbathdoctor.com
Driftweed is offline  
Old 05-18-2014, 06:15 PM   #89
Accidental Painter
 
Driftweed's Avatar
 
Trade: Who's paying?
Join Date: Nov 2012
Location: Evansville, IN
Posts: 2,292
Rewards Points: 1,262

Re: Microsoft Access 2010


Microsoft access 2010-forumrunner_20140518_181630.jpg
__________________
www.callbathdoctor.com
Driftweed is offline  
Old 05-18-2014, 06:20 PM   #90
Accidental Painter
 
Driftweed's Avatar
 
Trade: Who's paying?
Join Date: Nov 2012
Location: Evansville, IN
Posts: 2,292
Rewards Points: 1,262

Re: Microsoft Access 2010


Now when the employee selects customer, that alters the job to presets for that customer.

Then when they click on "job" it opens a invoice where they can do add ons.

Example: bill does a 2 bedroom white for the arbors with 4 drywall patches. After job is complete, bill logs in selects customer and product. Then in the invoice he can add 4 drywall patches, click complete order. The invoice is then emailed to the client, & logged in the database.

Am i making sense?
__________________
www.callbathdoctor.com
Driftweed is offline  
Old 05-18-2014, 09:25 PM   #91
The Dude
 
smalpierre's Avatar
 
Trade: home improvement
Join Date: Jan 2011
Location: Sunny South Florida!
Posts: 2,019
Rewards Points: 1,946

Re: Microsoft Access 2010


It does make sense. One thing you might want to consider, is logins for the employees. The cornerstone of almost every system I've seen is security - by this I mean internal security. You don't want everybody to have access to everything. You don't want everyone to have access to modify pricing for example.

As a side benefit, when an installer employee logs in, things like the jobs pulldown will automatically be filtered to only have jobs for that employee.

But yes, that makes sense.
__________________
"That somebitch looks like MANAGEMENT MATERIAL TO ME...I would have handed him another rod after he bent the first one." ~MAULEMALL
"I think he was grandmaster at a gay pride parade in san fran this week (not that there's anything wrong with that). " ~ J F
smalpierre is offline  
Old 06-05-2014, 07:19 PM   #92
The Dude
 
smalpierre's Avatar
 
Trade: home improvement
Join Date: Jan 2011
Location: Sunny South Florida!
Posts: 2,019
Rewards Points: 1,946

Re: Microsoft Access 2010


Thought I forgot about it didn't you? I've been duking it out with this guy and a stupid roof - haven't had a lot of good programming time - but I did come up with a couple of things.

I still don't have access - my buddy couldn't get me a copy, but I do have MySQL and Lazarus. It's been a while since I've done a desktop app, so I had to knock some dust off my mad skilz

There's good bad and ugly to that.

Pascal is a strongly typed language like C/C++, so you have to specify data types. If you want to display an integer or float (numbers you can do math with), you have to typecast it as a string (character representation). This sucks in some ways, but there are reasons it's good.

It's much more structured than C/C++, so it's really a better language to learn with since it forces you into better habits

It's compiled code - runs without a runtime, or interpreter - so the code is light and fast. Pointers are supported - but you have to free any memory that you allocate - or your code will leak memory. It's easy though - if you open a database connection you close it when you're done.

I went through the quickie slapped together database to figure out what direction it needs to go, and found a few things that need to be addressed. I'll be getting to that soon.

I wrote a quickie little app to connect to that database, and populate the dropdowns like you want - but until the data structure is there to code against, it's futile going further. I'm working on that a bit now.

Not sure if I can attach a zip file, but I'll try - it's the lazarus project directory.

If you want to see what I've got so far, you'll need MySql Community Server, MySQL Workbench (the GUI tools), and Lazarus.

I'm running MySQL 5.5, and Lazarus 1.2.2 - BOTH are 32 bit, and that's important. If you get the latest MySQL (5.6) it comes with everything, but the windows installer is 64 bit, so you'd also need to install 64 bit lazarus - just to be sure they play together nicely.
__________________
"That somebitch looks like MANAGEMENT MATERIAL TO ME...I would have handed him another rod after he bent the first one." ~MAULEMALL
"I think he was grandmaster at a gay pride parade in san fran this week (not that there's anything wrong with that). " ~ J F
smalpierre is offline  
Old 06-05-2014, 07:22 PM   #93
The Dude
 
smalpierre's Avatar
 
Trade: home improvement
Join Date: Jan 2011
Location: Sunny South Florida!
Posts: 2,019
Rewards Points: 1,946

Re: Microsoft Access 2010


200k filesize limit on .zip files - PM me an email address if you want the code.
__________________
"That somebitch looks like MANAGEMENT MATERIAL TO ME...I would have handed him another rod after he bent the first one." ~MAULEMALL
"I think he was grandmaster at a gay pride parade in san fran this week (not that there's anything wrong with that). " ~ J F
smalpierre is offline  
Old 06-05-2014, 09:21 PM   #94
Accidental Painter
 
Driftweed's Avatar
 
Trade: Who's paying?
Join Date: Nov 2012
Location: Evansville, IN
Posts: 2,292
Rewards Points: 1,262

Re: Microsoft Access 2010


Smallpiere, I'll go download Sql now so we can be on the same page. Then we'll begin hashing things out tomorrow.

Been batshart busy lately, had work lined up for a new employee and he never showed up. Frustrating!! This week WILL end haha
Driftweed is offline  
Old 06-05-2014, 09:26 PM   #95
Accidental Painter
 
Driftweed's Avatar
 
Trade: Who's paying?
Join Date: Nov 2012
Location: Evansville, IN
Posts: 2,292
Rewards Points: 1,262

Re: Microsoft Access 2010


ok got the first two but dont see lazarus...
Driftweed is offline  
Old 06-06-2014, 03:26 AM   #96
The Dude
 
smalpierre's Avatar
 
Trade: home improvement
Join Date: Jan 2011
Location: Sunny South Florida!
Posts: 2,019
Rewards Points: 1,946

Re: Microsoft Access 2010


For some reason, lazarus.freepascal.org isnt' working. I got mine from the sourceforge repository: http://sourceforge.net/projects/laza...urce=directory

make sure you get the version that matches mysql, the client libraries gave me some **** when I had one 32 and one 64 bit. Can fix I'm sure but easier to have both the same.
__________________
"That somebitch looks like MANAGEMENT MATERIAL TO ME...I would have handed him another rod after he bent the first one." ~MAULEMALL
"I think he was grandmaster at a gay pride parade in san fran this week (not that there's anything wrong with that). " ~ J F
smalpierre is offline  
Old 06-06-2014, 03:28 AM   #97
The Dude
 
smalpierre's Avatar
 
Trade: home improvement
Join Date: Jan 2011
Location: Sunny South Florida!
Posts: 2,019
Rewards Points: 1,946

Re: Microsoft Access 2010


the rest of the freepascal.org site works fine :/

I've been on a job from hell the last couple of weeks - last job before the move has to be a toughie no?
__________________
"That somebitch looks like MANAGEMENT MATERIAL TO ME...I would have handed him another rod after he bent the first one." ~MAULEMALL
"I think he was grandmaster at a gay pride parade in san fran this week (not that there's anything wrong with that). " ~ J F
smalpierre is offline  
Old 06-06-2014, 09:04 AM   #98
Accidental Painter
 
Driftweed's Avatar
 
Trade: Who's paying?
Join Date: Nov 2012
Location: Evansville, IN
Posts: 2,292
Rewards Points: 1,262

Re: Microsoft Access 2010


You coulda told me to just get the mysql windows installer, lol. THAT was fun! ok, I'll go get the lazarus after work.

This could wind up being a cool little project.
Driftweed is offline  
Old 06-06-2014, 08:24 PM   #99
The Dude
 
smalpierre's Avatar
 
Trade: home improvement
Join Date: Jan 2011
Location: Sunny South Florida!
Posts: 2,019
Rewards Points: 1,946

Re: Microsoft Access 2010


lol! yeah - the windows installer for 5.6 - the latest version is 64 bit, but it includes everything you need. That being the case, don't follow the recommendations on sourceforge to get the 32 bit version of Lazarus, get the 64 bit version. This way it'll play well with the mysql client libraries.
__________________
"That somebitch looks like MANAGEMENT MATERIAL TO ME...I would have handed him another rod after he bent the first one." ~MAULEMALL
"I think he was grandmaster at a gay pride parade in san fran this week (not that there's anything wrong with that). " ~ J F
smalpierre is offline  
Old 06-06-2014, 08:25 PM   #100
The Dude
 
smalpierre's Avatar
 
Trade: home improvement
Join Date: Jan 2011
Location: Sunny South Florida!
Posts: 2,019
Rewards Points: 1,946

Re: Microsoft Access 2010


I assumed you'd get the windows installer. There's a lot of different versions of it though. The older ones don't include the gui tools so you have to get that seperately.

Advertisement

__________________
"That somebitch looks like MANAGEMENT MATERIAL TO ME...I would have handed him another rod after he bent the first one." ~MAULEMALL
"I think he was grandmaster at a gay pride parade in san fran this week (not that there's anything wrong with that). " ~ J F
smalpierre is offline  


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
I Love Angie (NOT), access the digital version MOTB Marketing & Sales 1 04-30-2013 03:46 PM
microsoft surface tablet BCConstruction Technology 22 04-27-2013 05:27 PM
Is Access to a Toilet a ‘Basic Human Right’?: (This isn't a joke!) MAULEMALL Off Topic (Non Trade) 50 05-28-2012 02:42 PM
Microsoft Office 2010 Beta DaVinciRemodel Technology 4 03-17-2010 01:16 PM

Join Now... It's Fast and FREE!

I am a professional contractor
I am a DIY Homeowner
Drywall Talk is for
PROFESSIONAL CONTRACTORS ONLY!

At DrywallTalk.com we cater exlusivly to professional contractors who make their living as a contractor. Knowing that many homeowners and DIYers are looking for a community to call home, we've created www.DIYChatroom.com DIY Chatroom is full of helpful advices and perfect for DIY homeowners.

Redirecing in 10 seconds
No Thanks
terms of service

Already Have an Account?