Search results

Just out of curiosity, is there a significant speed difference between running a saved query and running a SQL string via VBA?

Also, you'd be surprised who you run into, regardless of your line of work. I've never worked in games or graphics, but I know people all throughout the video game industry. Some are old co-workers, some are old roommates, and some through MMOs. I also know Vanilla Ice (and yes, totally a...

On a slightly different note, I do find it rather amusing every time I see a 'Top 10 Movie Scores of All Time' or 'Top 10 Movie Themes of All Time' list and instead of listing a single piece, they just list Jonathan Williams.

You can add Elder Scrolls Online and Elder Scrolls 6 to that as well - they are based on the same basic theme as well. Videos playing all the Elder Scrolls soundtracks in sequence are pretty widespread on YouTube. All Elder Scrolls music since Morrowind has been written by Jeremy Soule, who...

I actually knew SPAWAR and was able to figure out NAVRESINFOSYSOFF by breaking it down, but I'm afraid NEDC NO is new to me and isn't in my bookmarked list. I'm guessing NO means New Orleans office, and while NEDC was originally the Northeast Defense Command, that hasn't been a thing for a long...

Okay, standard stops in database design. First, determine what data is going to need to be generated in reports. Then determine all the data you're going to need to store and track to meet requirements. After you've done that, build your tables. Don't worry about the query until you have those...

This stinks of homework. Please tell us what you have tried so far, and we'll be happy to help point you in a viable direction. As a general rule, however, we will not do the work for you. Even if it isn't homework, this is entirely too open-ended a question for a realistic response, and...

Oh, one thing, Doc - I have a long-standing interest in military history, which has the interesting side effect that I actually know many, many more military acronyms than most civilians. Not all of them by any stretch - I'm not sure anyone other than a few career sergeants can make THAT claim...

-Offer sacrifices to the Ruinous Powers in hopes that they encourage the state to hire a qualified DBA.

Interesting. We just upgraded to 2014, so we can't use it here, but that's good to know. I'm afraid it will lead to even more sloppy databases (WHY HAS NO ONE IN IT EVER HEARD OF NORMALIZATION?!?!?!?), but it might be useful on occasion.

Heh. The place I worked from 2013 to 2016 had me write an Access app that takes any of roughly 15 different spreadsheets, identifies which spreadsheet is being loaded, pulls only the required data, and exports it into a CSV file. The problem is that the spreadsheets are not only created by...

Yeah, I know a guy Derek Scott Bland. Goes by Scott, and often doesn't realize that someone is talking to him if they call him Derek. Of course, that has its own issues, since for many years there were four of us going by Scott in the M:tG scene around here. Even today, I'm more used to being...

Please read the following link. https://www.excelguru.ca/content.php?184 You're not getting yelled at, it just explains why you shouldn't normally cross-post, and what you should generally do if you feel you have to do it.

Honestly? If I needed to track all of that, I'd break it down like this: First Name: Karl-Franz Middle Name: Helmut Markus Heinrich Last Name: Schmidt-Miller Suffix: III Honorific: Esq Nickname: Bob If I only had the three name fields, I'd toss the honorific and either toss the suffix or put...

Aaand the winner with the most elegant solution is plog!

Yep, you can use the Requery method on a combobox to requery the control without having to requery the entire form. Vlad's answer is the one you want to use: Me.ComboBoxControlName.Requery

"Karl-Franz Helmut Markus Heinrich Schmidt-Miller III, Esq. (Bob)" Yep, that is PRECISELY why we always recommend storing each name in its own field. :D

I have to agree with the others - unless there is a documented business need for calculated data to be saved for some reason, you should avoid doing so since it just wastes space. In the example you gave, you have the DOB and you have the date they were entered into the system. With that, you...

DBGuy - I wonder which would run faster, your solution in 3 or mine in 4? The one I gave in 2 kind of sucks.

Actually, even better: Select DISTINCT all records from the table with value greater than 1000. Query should just return the Marker. Let's call it IncludeList. Next, left join that to your main query on the Marker fields. For Include, use this: Include: IIf(IsNull(IncludeList.Marker, "No"...