Recent content by Frankenoid

Is replying to your own post like talking to yourself? Never could get the SQL statement to work; even tried using a stored query, which would give me a too few parameters error (although the query itself would show the correct filtering). Weird. Ended up using a variation on the Len(fldCase)...

Nope... gives me a "too few parameters" error. But thanks for the try. Any other suggestions? -- Franki

Just got the chance to try your solution (I was in the midst of a family reunion at my house with my 5 siblings, our parents, and various nieces, nephews and spouses); works beautifully -- thanks.

Arggghh! I'll never figure these things out! I need to let our file clerk designate a "blank" designation for a client matter if necessary. I'm cool if its a brand new client; however, on an existing client, I need to determine if such a generic "blank" designation (a zero-length string)...

I have a combo box (cboCase) whose rowsource is populated by the selection made in a previous combo-box (cboClient). At least 90% of the time, there is only one item in the cboCase list. When there is more than 1 item, I have cboCase do a drop down to alert the user that the client has more...

See, I knew it was simple. I'm sure I'll come up with another basic question (I will NOT call it a stupid question -- stupid is the Access "help" function which couldn't manage to lead me to this simple answer).... Thank you kindly

OK, I'm sure there is a simple answer to this, but I don't know it. What I need is a simple way to have a user enter their initials on a form 1 time, and have the value stored in an unbound hidden text box on the form. The form pulls up a list of archive boxes which are currently at our...

Yes, a case can have many clients -- and leave it to lawyers to all have a different way of naming a case -- which is why I'd like to have the combo box for efficiency. As noted in my first post, I HAVE done an inelegant work-around: two queries, joined into a union query, but it gives me a...

I'd prefer a combo box for 2 reasons: the lookup function, and the autocomplete function. When you're dealing with a few hundred client case names you can't always remember how a client was referred to in the filing system (was it the company name? the company owner's name? what was the...

I am a very occasional designer of databases, so my knowledge is limited. What I need is a smarter combo box, that will use the autocomplete function to compare strings against two columns, not one. I'm doing a database to track our lawfirm's files as they go in-and-out of storage. We have...