Search results

Yep, that's basically a better way of explaining my own reasoning too. I can determine the data type from the name, but it's vital I know the CONTROL type, since different types will have different properties and methods.

I have roughly a half dozen scattered about, all of them from the later collectible releases. I've kept my eyes open for the rarer older ones, but they don't come up for sale often, and tend to be fairly expensive when they do.

I'm not sure how someone could get 'Do not use a naming convention' out of 'I disagree with Mark's reasoning about which prefixes to use', but you somehow managed to pull it off. For now, I'll go with 'completely misread the post' rather than 'deliberate obtuseness.' I didn't object to a...

Fair enough, but yeah, you should be consistent through the app.

Yeah, for report objects the traditional prefix is rpt. I actually wrote a procedure myself that goes through a given form and renames all of the default controls, including attached labels. Well, by all, I mean text boxes, combo boxes, check boxes, and labels. It won't touch objects that...

I disagree with Mark on control naming 100%. You see, I go the other way around. If I can't tell from the name what a control is supposed to contain, then the name sucks and needs to be changed. However, it's just as important to know what kind of control you're working with. I indicate the...

Yeah, my bad. Guess I shouldn't have compared Jeremy Soule to John Williams.

Wow, I've never seen Access 1.0 before. Like Doc, I started with Access 2, although I took a detour away from database work for quite some time after a few years. That was actually my intro to database programming. We were having a meeting, and the operations manager asked, "Froth, you're...

Colin, for what it's worth, I work from home 3 days a week, and use Citrix over a wifi connection. The only real issue I've encountered is a distinct lack of bandwidth when logged on remotely, and that stays the same regardless of whether I use wifi or hook up the cord. It only really becomes...

I believe ADODB connections can send parameters directly to stored procedures, but I'm not 100% sure. I'm afraid ADODB is something I've virtually never had need to touch. That would be a solid starting point, however.

LOL You're fine. Just always a kick in the pants to answer a post, only to find someone else answered it while you typed! The irony here is this just came up at work for a co-worker. It was the reason a form would not open correctly when opened in data entry mode.

DBGuy:

Does the table have a primary key? If it doesn't have one and one isn't assigned as part of the linking process, then Access will treat it as read-only.

Oh, I'm fully aware of what Jonathan Williams has written, trust me. The man is incredible. There's a reason they just list him rather than a specific piece as the best.

Have your trigger update a global variable for each form, or maybe some bitwise code (1 = a, 2 = b, 4 = c, add 'em) indicating which forms were viewed and which werent. Then, when they go to move on, check the globals to see if everything got checked.

To reinforce what Colin said, we really have no objection to cross-posting itself as long as you're upfront about doing it and explaining why you're doing it. On the other hand, if I spend 3 hours coming up with a solution for someone, only to learn they got an answer somewhere else the day...

They can get out of hand if you have enough subforms, plus they all have to load, which can slow everything down badly if you have too many or they're too complicated.

Meh, I think it's the biggest name in the MOBA field these days. It's still one of the biggest genres out there; it's just toxic as all hell. I got enough of that kind of behavior playing Magic: the Gathering at a competitive level, thanks. I quit M:tG in large part because it was bringing...

Yep, what I typically do in this situation is bypass the Master/Child Field properties entirely and base the subforms on parameterized queries.

I dunno. They're just action cinematics to hype the game; vignettes, basically. But the new one - AWAKEN - is just a damned cool cinematic regardless of whether or not you like the game (which I don't).