Search results

Goodness...

Bingo - Thanks! Not sure why my googling didn't find that -

Thanks! - I'll give it a try.

Thanks sneu - that didn't seem to help - :(

Help! I got a surface and Access VBA menu bar is not there. How do I get it to show up? I think its access 16 - Any ideas? I'm trying to google it but can't seem to find anything... Thanks in advance - ken

The Iran deal is what I remember. I think it cost him a second term. Why does there seem to be a world of difference between him and someone like W or Hillary...

Just curious what others think about this man - jimmy-carter He is one of the few politicians that I feel is a good, honest, and decent person...

For starters, I'm thinking you need to place pound signs (#) around the prompt syntax. Between #[StartDate:]# And #[EndDate:]# I'm a little rusty on this. Maybe someone else can jump in...

When you say they don't work, what do you mean? Do they not return records at all or is it not including some records you think it should, etc.,?

I'm thinking you will probably have to have a yes no fld in the table that can have a null value. Then hook the radio buttons to it. Or instead of a yes no fld maybe make it an number fld. So the user has the date fld they can fill in or not. If they leave it blank they can select either of the...

Probably best if you google radio buttons to ge a better understanding of how to use them. I'd probably drag it out...

Seems you need a couple radio buttons...

Play with the other events one at a time calling the same prc

Picking the best event can be tricky sometimes. I may even throw in a DoEvents... I like the Trim(cmbBoxname1 & "") trick and use it sometimes as well...

To start with I would do one local sub proceedure that gets called on each of the combo boxes on change events which enables the other controls if the conditions are true...

This still seems like a bad way to build an end user query tool. So... how would the query param object know what data fld type it is to be used for before you use it?

Cool - I'll have to copy this to my snippets :)

Let us know if it will rip through 400k records in a resonable amount of time - :)

A function seems like a pretty good option to me...

Why not just build a form for the user to put thier params in?