|
With regards to the line continuation issues, what I'm trying to do is create a an array (an ever growing array!) of terms that can be used to categorise an item.
eg
items = Array("item1", _
"item2", _
...
"itemN")
N, for me, has grown beyond the limits of what VBA likes.
What I probably should do is just enter the terms in the spreadsheet somewhere and have the method reference the values in those cells rather than hard coding.
I've well and truly burned through the 1hr I budgeted on this one
cheers
Chris Maunder
|
|
|
|
|
Understandability isn't an issue, then, but I think you are right about what you should do. When I have the same sort of issue in Access VBA, I generally create a new Table (if the 'array' is likely to be needed again) or Recordset (if it isn't), which is pretty much the Access equivalent of entering the terms on the spreadsheet in Excel.
|
|
|
|
|
Understanding the principles of relational database design is a first step.
|
|
|
|
|
Yet another case of someone using excel as a quasi database.
It should have just been done in Access in the first place.
I, too, have done a lot in Access VBA - easy when you know how.
The problem I've found in Excel VBA is that they named most 'things' differently. I haven't done any VBA for Winword, but the same issues probably arise. No doubt that different teams did the initial design for each program.
|
|
|
|
|
Sorry, but it shouldn't have been done in Access in the first place. This is a spreadsheet I'm working on, and it includes text, formatting, multiple worksheets and it needs to be approachable and usable by a non-developer.
The categorisation part is a minor, minor part of this. I'm not a fan of changing the problem to suit the tools. I choose the tools to suit the problem.
cheers
Chris Maunder
|
|
|
|
|
Then I apologise for my assumption. I agree with your statement - choose the right tool for the job.
|
|
|
|
|
I think the hardest thing for us is realising that sometimes we shouldn't write an app or dive into the technology 'just because we can'.
What I should have done is looked for an online service that does this and just used that instead. I'd be done 4 days ago.
We had a big meeting this afternoon about this: balance the ease and fun - and fairly hefty price tag - of writing solutions ourselves, vs paying the money and using something pre built that, if you actually do the suns, will be way way WAY cheaper in the long run.
But coding is a drug.
cheers
Chris Maunder
|
|
|
|
|
Yeah, I've just written VBA code to validate "date ranges" in Excel, i.e. a range with year, month, and day cells. It also has to identify date ranges based on the year cell containing a validation list.
It's an unholy, un-OOP, mess, and working in that bloody VBA IDE is really a big step down from VS 2019.
"'Do what thou wilt...' is to bid Stars to shine, Vines to bear grapes, Water to seek its level; man is the only being in Nature that has striven to set himself at odds with himself."
—Aleister Crowley
|
|
|
|
|
I'm upgrading my handset, as I mentioned before.
So the first thing I do it connect it to my WiFi ... and shortly after it starts telling me I'm low on PAYG - because it's updating itself and USING MOBILE DATA INSTEAD OF WiFi! 
So that's fixed, and a new PAYG with data, minutes, and text added ... sodding thing.
The fingerprint unlock is good though - really quick!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I have a LG / Android. I can disable data over mobile connection. I only allow data over WiFi. But admittedly, I don't use it much outside the house.
|
|
|
|
|
So do I - but this grabbed 11MB of data before I got a chance to turn it off - which all went at the "expensive rate" since I normally use WiFi data only ...
Glad I spotted it - it just downloaded 3.93GB of Android 10 ... all by WiFi, thankfully!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
OriginalGriff wrote: So do I - but this grabbed 11MB of data before I got a chance to turn it off - which all went at the "expensive rate" since I normally use WiFi data only ...
AUD$40.00 per month gets me unlimited calls, text and streaming services and 30GB of data, plus with the Missus on the same account her 30GB of data is pooled so we have 60GB to share. Haven't looked at the usage but if we hit 10GB in a month even when I have to tether client laptops off the phone I would be shocked.
OriginalGriff wrote: Glad I spotted it - it just downloaded 3.93GB of Android 10 ... all by WiFi, thankfully!
I've got a Pixel 2XL that I've had for a couple of years now, it's also running Android 10. At a customers the other week and wanted to test/checkthe WiFi. Fired up WiFi Analyser and WiFi Overview 360 Pro and they both require Location to be on to work, reckon this has been required since Android 6.
Do you have anything else that you use or do you have your Location stuff on? I've got nothing to hide but Google can faarrrkkkk off cause they ain't tracking me, at least not as easily as if I had Location on.
Michael Martin
Australia
"I controlled my laughter and simple said "No,I am very busy,so I can't write any code for you". The moment they heard this all the smiling face turned into a sad looking face and one of them farted. So I had to leave the place as soon as possible."
- Mr.Prakash One Fine Saturday. 24/04/2004
|
|
|
|
|
I hated the idea of the fingerprint unlock, but I have to admit that once I started using it (Huawei phone) I found it extremely convenient.
My plan is to live forever ... so far so good
|
|
|
|
|
|
When two cats end a fight do they hiss and make up?
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
would be purrfect if it were true
after many otherwise intelligent sounding suggestions that achieved nothing the nice folks at Technet said the only solution was to low level format my hard disk then reinstall my signature. Sadly, this still didn't fix the issue!
|
|
|
|
|
It depends upon what claws they had to fight. Usually the purr-pose is an available female.
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
They don't fight, they pussy-foot around the issues.
|
|
|
|
|
Unless there is one clear winner, then it is a catastrophe
“The palest ink is better than the best memory.” - Chinese Proverb
|
|
|
|
|
I thought the fight had been scratched!
If you can't laugh at yourself - ask me and I will do it for you.
|
|
|
|
|
|
We live in a era of 21st Century Snake Oil.
Some are in the form of prescription drugs, usually very new and far beyond even very expensive.
The others are in the form of "dietary supplements" - which due to the way the laws in the US are written, have to show themselves to be neither safe nor effective (and yes, you read the first word correctly). As long as they somehow mention that their claims are not FDA tested and it's not claiming to do anything (innuendos should count but don't). Same with a lot of insurance ads, especially those targeting seniors.
What does this have to do with higher and higher resolution TV?
In the first case, side effects (often worse than the malady they treat) and in the second case, that it has no valid proof that it works or has ever worked (or is even safe*) beyond the placebo effect.
The higher the resolution, the smaller the font and the more impossible to read text they cans squeeze into the bottom edge of your screen.
So, improved picture resolution is, when it comes down to it, an aid to fraud. Also, it encourages these commercials (adverts) and even with the sound turned off they are annoying.
* if somehow show to be unsafe its sale can be halted.
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
One thing you have to remember is that you don't see with your eyes, you see with your brain, and an image doesn't have to be perfect for your brain to interpret it perfectly.
Another thing is that a high-res picture won't stop cr@p content being cr@p content.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
I think you got my thought backwards - I don't want more resolution and thus finer print.
Indeed, to your first point, your eyes and brain process the image quite a bit before you are conscious of it - an example from when I used to hand-color photos (with a water based color - not the usual oil-over): if you had a portrait and colored the eyes, alone, it seemed to come to life. If you colored the entire face it was perceived as a full-color image although the background was in B&W.
The audio for these - that is your basic rhetoric with implied statement not actually made. A well orchestrated and often used dance to the brink of lying without quite doing it. "Mislead" in the most literal sense
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
W∴ Balboos wrote: I think you got my thought backwards - I don't want more resolution and thus finer print.
Nope, I got that. I was just adding more ammo.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
