Recent content by enthrop

We were just talking around in the office and none of us could figure out what MDE stood for.. and I can't seem to find it on Microsoft's webpage. Does anyone know?

Hey, I know this should be simple, but I can't think of what expressions to you use. I want to find any fields with the string "IS" in them. I've been using: Like "*IS*" BUt it picks anything with IS up: (ie RISK, FRISK, MISS) How can I limit it to ONLY IS (IS the sky...

Hey, I've been putzing around w/ my data (asked around in Queries Forum), and the suggestion presented was a VB module. I've coded a very basic one and got it working, but because I plan on updating my data and things might get changed, I need a VB module that is also easily updated to be able...

Thanks a bunch again Mike - I feel like I've spent my day thanking you :) I've already started fooling around with what you gave me... and I'm about to head off to the other forum you mentioned to see if what I have in mind is doable (pointers time!) Thanks :)

Haha. Don't you love how I keep posting follow ups? I don't really need to know this - but it's more of the programmer of me coming out (and yeah I know, I used C above :/) Is there a way to create an 'array' of all possible titles? Ie VP[array_size] where each element of the array is a...

THANK YOU SO MUCH! I got it to work! so now I just have to build up the if-then statements and I can leave it running on the larger databases! You've saved me so much time! thanks again!

Ok, I'm feeling very incompetent and ashamed for having to ask so many questions.. but I really don't have exp. w/ VBE and macros and stuff.. (well, now I know what I'll be doing tonight after getting home and digging out my Access books). Anyway, I loaded up VBE and wrote a function...

Actually, I have a follow up question, and this is mostly due to my lack of experience with VBA (and Microsoft's Help isn't getting me far). If InStr(sUpperTitle, "VP") > 0 _ And InStr(sUpperTitle, "SALES") > 0 Then title_trans = "VP of Sales" Exit Function End...

Heh, I seem to like replying to my own posts.. Follow up question. Say i have a table with a column, "Company Name," located in table tblCompany. (other columns have info about the company). Over the course of time, things have been marked for deletion if the company name has a *...

This basic thing seem to have slipped my mind due to in use... When designing a query, how do I scan for the STRING # and * without them being used as wildcards? Thanks.

Mike, Thanks a lot of that tip. I understand what you suggested, and I'm about to go putz around and try it out. I have smaller DBs I can work with first to try it out with, so lets see how this works out. Thanks again. - Alex

Mike, Thanks for the response, but I still have a problem. What you described is basically what I _want_ to do (only you seem to have put it in a more easily understood way). I actually do have a 3rd table w/ all the standarized titles - in the future when more data is added, people pick from...

Quick little update/additional question I forgot to ask: I know Access has a little VB Builder (at least I think it does), unfortunately, I have no idea how to use VB. As an extension of my question (and I am looking for the more efficient way to do the above), is there something equivalent in...

Hey, First time posting here, so lets hope I get this right. I've just recently begun to use Access & queries and such, and there's something I'm trying to figure out and I'm sure there's an easier way than what I'm doing, so was hoping someone could help me. I have 2 fields I want to work...