Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
I basically put those into the actions in the macro, and it worked fine.
Can you force a Windows Common Dialog control in a macro?
No, wait...the worksheet names change every week too--it's a datestamp. It's weird. I'm so far away from VB these days. It's a simple thing--a form with an input field of a datestamp, and a big old button, that when pressed constructs a filename and two worksheet names and goes and imports the data.
I just gotta dip my toe back into the water.
Still, even with the macro needing editing by hand every time it's faster than doing it manually every week. So I may not need to broach my VB fear.
Can you force a Windows Common Dialog control in a macro?
Nope. Well, there is an OCX control that might work with a macro, but it sucks. We use VB to do a Windows API call. Sounds messy, but ya' just need to copy a couple lines of code....
Ick.
Okay, so I dipped into forms again. Looks like they're pandering to me, so I might just get out of this alive. First things first--can I pass an argument (aka build a filename) to a macro? Or should I just go straight to DoCmd? I should just go straight.
Actually, looking at this, I should have been in here earlier. I'd thought the learning curve of getting back in would be higher. But they're totally talking down to me.
can I pass an argument (aka build a filename) to a macro?
Nope.
Or should I just go straight to DoCmd? I should just go straight.
Yeah, it's really not that bad....
You say that, and I'm just staring here at a screen that is pretty much *begging* me to call a macro with that button. Let me see...how do I concatenate strings again?
The light! It burns!
Was that rhetorical?
More... melodramatic.
And, we're done! Ugly little bugger, but spending much more time on it would tip the scales into the time-wasting end of things. Does what it needs to do.
Thanks!
I am now posting from my Windows machine on my MacBook Pro. Heh heh heh.
Better patch my security holes, quick.
MVC is dreamy.
If you'd like to see the patterns that you might might like even better than MVC, I highly recommend Patterns of Enterprise Application Architecture , by Fowler. It has seven of what Fowler calls "Web Presentation Patterns", of which MVC is just one. It talks about why you might want to use one pattern over another, depending on your requirements.
You also get the money pattern thrown in for free!
This is kinda' cool: Shuttle Columbia's hard drive data recovered from crash site
Edwards said the circuit board on the bottom of the drive was "burned almost beyond recognition" and that all of its components had fallen off. Every piece of plastic on the model ST9385AG hard drive melted, he noted, and all the electronic chips inside had burned and come loose.
...
Before recovery could begin, a great deal of dirt and other debris had to be cleaned from the storage device. A rubber seal at the top of the hard drive was completely burned off enabling dirt and charred elements to enter the casing. Everything but the drive's platters were virtually unusable, remarked Edwards
"The heads were bent and they were touching where they shouldn't have, so we had to carefully cut and bend metal away from the platters to get them out without causing more damage," said Edwards.
Once cleaned, the platters were placed into a spare drive and carefully aligned with a new motor. Because the original circuit board was destroyed, Kroll had to use trial and error to determine which firmware was needed for the device.
Although damage to the drive worsened once the team got it up and running, the data recovery specialists retrieved 99% of the drive's DOS-formatted contents. "It was only a couple hundred megabytes of data, which isn't much by today's terms, but the data [the drive] contained was very valuable," noted Edwards.
eta: Check out the slideshow of the damaged drive....
