Search results

Based on the description, the OP wants items selected from a pop-up to be added to a listbox. The error message, however, indicates that the listbox is based on a query, rather than a value list, so what we really need to do is determine what the criteria are for the query and how to add the...

I'm not really much of a collector, actually. I discovered the whole Frothingslosh thing from a play-by-mail game I was into back during high school and got back into in the mid 2000s, and I've collected a handful of cans just because I find the whole concept behind the beer to be amusing. For...

In addition to what the others posted above, with all the data in a single cell in Excel, how do you determine the end of the record? Does the spreadsheet only contain one record at a time, or does the cell include carriage returns inside it? One thing you need to watch out for is this: cells...

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.

Yeah, I wasn't taking that bait. :p

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.