Recent content by dstahl81

The code runs great in Access 2013 but not in Access 97. I found code to substitute for Split and FindReplace but I keep getting an error on UBound (var) and I feel it's something with the split code I had to insert. Let me clarify, the original code does work but not in Access 97 as there are...

So, after some deliberation (waking up) I realized that @arnelgp did provide a solution to my original request. I now have to wait until we can upgrade access to something newer than 97 as the code doesn't work. It works PERFECT on 2013 though! Daniel

Mark, I am limited by current business processes which stipulate we use the current database to query 911 addresses with. This is to validate if the caller is in our jurisdiction, thus if the address is not loaded they may be calling from outside of the county. It doesn't happen often when a...

Hey all, So I tried the code last night at work and realized our version of Access (97) is missing certain functions available in later ones.....split, ubound to name a few. Daniel

Yes'ish, I want the db to be "smart" enough in case an operator is in a hurry. 111 Adms could return: 11 Adams st 111 Adams Ave 1111 Admantium Blvd These are all possible solutions. Again, this is for 911 operators that might be a tad hasty at the moment.

@arnelgp So I got anxious and built a test db at home with fake addresses, setting it up like at work. I found that your code does work! Now, I input "111 Adams Ave" I get nothing. How do I also get anything from that input that is either 111 or Adams or ave?

@arnelgp I go back on shift tomorrow night, in between calls I'll see if this works. I'll report my findings if I'm stuck. Thank you sir! Daniel

Anyone else???

Business Issue: Allow 3 different search abilities from single unbound text box predicated on the information entered. 1. only numbers returns addresses begining with those numbers 2. only road name or partial road name returns addresses with that road name it in. 3. house number and road...

Hi all, I am trying to comew up with a way to use regex coupled with a Select Case to validate some data. Here's what I have. On my form I have an unbound text box that is used to query a single table called address and output to a listbox. If a user inputs a house number e.g. "1111" the...

Hi all, I've played with Access over the last 15 years but nothing serious which makes me have to come to info hubs like this! I am married to the best woman and we have 3 wonderful kids. We live in NE Alabama and enjoy outdoor activities to include: hiking, camping, fishing, and swimming. I...