Search results for query: *

I have a report in access which when close using the X button a procedure runs and make another form visible. The problem comes into play when the users performs a file exit procedure from the tool bar while the report is still active...an error message pops up stating run time error...

The original table driving the query has unique key field...The challenge comes in to play in the group by..I am trying to give the end result query new unique values..For example the query returned 114 records, is there a way to use that count and populate the field in that same query? DougP...

Does any know How to create an Auto Number For Each Row of in Query..Currently the query has no unique values.

Thanks... I got it to work..New problem. It locate the first matching criteria then exit the function..I need it to loop thru the entire memo record and return all..Any thoughts??

Thanks..it's working now. I had a missing ref!! My real objective for this sql is to find a number in my memo field...see below. I am attempting to pull apart a string of data. The piece I need is [Edit7]=19689421 and &[Edit7]=19449855485, but the issue is that is it is not always the same...

dao 3.6

Dim db As Database Dim rs As Recordset Dim strsql As String strsql = " Select Hardware.test" & _ " From Hardware" & _ " WHERE (((Hardware.test) Is Not Null))" The code above produces an error message runtime error 13 type mismatch....Can someone...