Search results

I understand vbaInet - I am trying to learn fast - this is the only method I could think of based on what I know - but hopefully as I learn I will be more efficient. I'll keep trying to figure this one out. Thanks agian for you help! Thanks as well Kryst51!

Hi vbaInet. Are you refering to this? lngCount = .RecordCount I don't mind changing the recordcount, but ould changing that resolve the issue? Thanks . .

Sorry Fellas - The link did help, but I am still struggling with the last post. Any advice?

Thanks Guys - forgive me for being dense. The below code seems to be working partially. Once the msgbox is invoked, my form remains at an empty record, how do I force it to revert to record 1? I also get the msgbox twice, once for "FilterOn" = True and once for "OrderBy" = True. Thank you...

Hi - the exact message is "No Current Record" Runtime 3021. The error is correct because once I apply the filter, there is no record to match the criteria. I would like to either capture the error - or is there a way to determine if a certain filter returns 0 records?

Hi - the error is for no records found . ."no current record" NO. 3021

Hi Everyone, I need a bit of help with a simple error handles. I have this code in a dbl click event of a listbox. The error occurs when there is no records to match the filter. On Error GoTo MyErrHandler Rem FILTER BY SELECTION Me.Filter = "[StockPrice] = 'UnderV' And " & "[" &...

Hi pbaldy - I just wanted to return and say thank you! I integrated your suggestion this morning and the error is resolved. Thanks!

Thanks pbaldy - I left the office but I will give it a go first thing Monday - thank you for taking the time to help.

Hi All, I attempted several tactics but I couldn't figure this out - I keep getting the error. I am sure it's something simple. Thanks for any help! Dim MyStr as Variant MyStr = ">= 0.75" Me.Filter = "[Ratio Type] = 'Acid' And" & "[" & MyFldName & "]= " & MyStr

Thank You Lagbolt - it seems to be working now. Thank you for your help and attention. I played around with the properties of the form, and now it works - though I am not sure what I did. Is there a specific property of the form that stops it from being filtered other than "allow filters"...

Hi Lagbolt - I am not sure why this is not working. But when I run the code I get a blank form. I filtered the query manually and it works - but when I use the code in the form I get nothing. Can you please advice? Thank You!

Hi all, I know I must have the syntax wrong. Also, I am trying to filter a form with a query as the record source. The second filter criteria I have, "Asset Type", is not on field on the form, only in the Query. I am not sure if I have to have the actual field on the form in order to...

That works as well :) Thank you!

vbaInet - you sir dwell in the stratosphere among the legends!! It works great!! A final question - given the scenario you have resolved; this is the best way to go about it? Why do you think Dlookup is too costly? I am very happy with the solution you have provided, but would you be...

Hi vbaInet - I edited my post. If what you suggested is still valid - can you give more detail? Thanks! Also, just to learn, would Dlookup work for this?

Hello! I am not sure how to go about doing this - though I am sure it is an easy issue. I have a Query with hundreds of rows. One of the Fields is Cost Center. In a table, I have two fields, Cost Center and Cost Center Number. I would like to add "Cost Center Number" to the Query. How...

With your intelectual horse power I am almost certain of it!! Once I find a way to break the speed of light though, I could catch up!!

You'll be on the top of my list when I get rich!! :) :)

vbaInet - I consider myself in your debt sir!! Thank you!!