Search results

:) Nice Take care and I am sure you will see my name float around some more! ;)

AWESOME! That works like a champ! Clears it and resets it right at the top. PERFECT! Thanks you so much! It is these little things that can eat so much of my time. -Stoss Side Note: I see you are from the UK, I heard it is COLD there

This only problem is, I have a Select statement for that rowsource and if I set it to null, it will wipe out my statement right?

Ok, I figured as much. Thanks so much for your help!!! This project is giving me a headache :) I hate customized search boxes!!! -Stoss

This is a side note that maybe you could solve. When I populate a list box, I have it sent to sent the listcount to a textbox. However, I noticed that it gives me 1 more count than what is actually there. Would you happen to know why it is doing this? Is is seeing the Column Header as a...

Yes, I am using simple.

With the code in the first box, it doesn't seem to deselect anything and it doesn't go back to the top. I tried many combinations with that code but couldn't get it to work. I also tried the other code and that didn't seem to work either. So, at this point, the only code that I can get to...

Ah yes, I didn't even check that. You are right, it doesn't scroll back up. That would be nice if it did.

Thanks vbaInet, Unfortunately, the one line of Me.lstPriorities.value = Null did not work. I would have like it to because it is clear code :) So, I went back to what we talked about earlier and that works great! Thanks so much for your help -Stoss

Thanks You!! That worked like a charm. One question though...How does that work? I mean, looking at it, I wouldn't think that it would deselect the rest of them in a multi select senerio. I did also put it in after my loop and it worked there too (the vbNullString part). Your code is much...

I am trying to reset a list box...which works in a sense. Dim varItem As Variant With Me.lstPriorities For Each varItem In .ItemsSelected .Selected(varItem) = False Next varItem End With It deselects all the items but then, as part of the error...

Priority 1 is just set to "Immediately" (no calculations). Then there is a Priority 3 (30 day calcs), Priority 4 (90 day calcs), then Priority 5 is just "As Required". Thanks for pointing that extra nest in there, after working on the code so long, my eyes get crossed and brain gets fried DOH...

I managed to get it to work. Not sure how or why it works but I guess it is good to go. -Stoss

Hello all, I am having a bit of a brain freeze and I need help with this function call. The following code is currently placed in a form. I also need to use the the same code for a report so I wanted to move the code to Module1 where I can call it from either the form or report. The trouble...

Hello All, I am in need of some advice.... I am running a search box that a person can select 1 or more items ("Priorities"). I need to run some complex (not hard just lengthy) custom queries but I don't know the best route to take. As it stands now, I would have to put in a multiple...

As I just submitted that, I realized that I should have put in "Resume Next" and not just "Resume". It works fine now. I guess that I still have the question if this is a good way to handle this situation. Basically, if it already on Page 3 it gives me this error. -Stoss

I am getting error message 2163...which states... "2163 - The page number you used as an argument for the GoToPage action or method doesn't exist in this form" Page 1 of this main form is the default form that is always up. I am working in another form (search form) in which I call that main...

Thanks vbaInet! I got everything working just fine! I had never seen the Oldvalue property before, that is a pretty cool one to know about. Thanks for all your help! -Stoss

Ok, I will look into that, I didn't know that was available. Thanks.

Sorry, I will try to clarify... Here is the process and what I was trying to get at earlier.... There is a parent form and a subform. If a user clicks, "New PO" the form is clear. After the user selects "Location"..etc. They will come to a combobox on the Parent form that is for Supplier...