« First « Previous Comments 21 - 60 of 74 Next » Last » Search these comments
I am familiar with VBA used in Access, so in the meantime I will install perl and check out a few tutorials.
Can you post the input file in CSV format. At least some chunk like100 lines of it is too large, for reasonable testing.
BTW @HeadSet - ever heard of LibreOffice?
I love LibreOffice, and before that OpenOffice. Any "missing" feature needed could be added with plug-ins. I had LibreOffice on all worker stations for years. However, I had to install MS Office because puds would send us Excel files with a formatting that LibreOffice could not read. These were usually files from government agencies, where the formatting was just for looks (like cool titles) and nothing of substance. Also, workers wanted to have "MS Office experience" on resumes so they complained until the owner made me buy Office. By the way, unlike Excel, LibreOffice Calc does not have a file size limit. I was able to extract data from an old legacy dBase3 file into Calc to parse it down. Excel would only be able to pull the first third or so before maxing out, and truncate the rest.
Also, if one want to write a user manual or any other complex document with pics and charts, LibreOffice Write is far superior to Word. With LibreOffice, you can adjust a graphic without scrambling the adjacent text formatting. With Word, moving a graphic even slightly can jumble up the text formatting for several pages.
Also, workers wanted to have "MS Office experience" on resumes so they complained until the owner made me buy Office.
OK, I may be doing the dbo source (FROM) wrong:HeadSet says
Oops, I see that I named the column "VehicleNumber: and not "Cab"
Then gives you data that looks like this..
That is what I need! I just got to take out the errors I made copying your design.
OK, I may be doing the dbo source (FROM) wrong:
Just hope I do not remind you of your co-workers.
As lately I'm so disgusted because everyone and everything is in the way of me getting my job done. When a problem comes up, that I would solve and turn around in minutes, hours or days. By time everyone has stepped on it and poked their finger in the pie, it's three months later, and I can't bring my self to even do it.
Change jobs.
I burn out, I'm fucking crispy fried now. Everything is a roadblock. New job, fun new interesting, old job, boring stale and I'm just doing maintenance.
I was literally getting up every day wanting to die rather than go to work sitting in front of a computer running data through a script. It was a nightmare.
Next time I'm off, I'm taking 6 months off to do all the crap I've been wanting to do, but have been blocked at my job from doing. I can't work on two entirely different projects at the same time - I need time to concentrate on what I want to work on. When I'm sick of that, not only will I have a cool product, I'll be sick of working on my cool product.
Thanks for giving me something to do, I actually felt like doing.
Your welcome! Now I will look over your code in detail and transpose it to Access. I really appreciate this, it will save a ton of work.
but I don't want to be in technology or programming. I'm tired of the pointlessness of it. No matter what you make and what you make it for. It will be obsolete in a few years. Libraries deprecated and OS they were written for end of life cycle.
Then gives you data that looks like this..
Tenpoundbass saysbut I don't want to be in technology or programming. I'm tired of the pointlessness of it. No matter what you make and what you make it for. It will be obsolete in a few years. Libraries deprecated and OS they were written for end of life cycle.
THIS is why I want time off.
30 years eh? What about bringing a bunch of stuff back? Remember ytalk? Remember when email ran on your computer? This cloud shit is just another way to censor and eavesdrop. It's another thin-client attempt. I'm disgusted by companies that say shit like "Google's terms of service say they will protect our data, and if they don't we can sue them". Yeah, good luck suing Google. Like when Dr. DOSS sued Microsoft, or Spyglass did, or Stacker did.
When people get burned, and they will get burned, it's going to swing back hard to private solutions in house. The trick is you have to drop a b...
Wow, that was fast. Works perfectly. Was this even much of a challenge?
« First « Previous Comments 21 - 60 of 74 Next » Last » Search these comments
I cannot figure this out in Access tools/VBA or Excel tools/VBA. I really just need to know how many days each cab was leased out for the month, and I think this grid is the way to do it. For example, a cab that was leased out from 1-8 Nov and then from 8-15 Nov was leased for 15 days. Output is any way to show Cab 1 for 24 days, Cab 3 for 30 days, Cab 6 at 4 days, and so on. I do not want to double count dates that overlap.
Any ideas, to at least point me at what logic to use? Does not have to be Access or Excel.