Recent content by JSDoyle

Thanks! Like anything else I've gotten busy on a different project and I'll have to get back to this one in the next day or so. I'll use your suggestions to try to get this working. Thanks!

I have an application that searches a database based on parameters input by th e user. They click a button to open a form that is tied to a query. It displays the results of the search. Sometimes when a search is made there are no matches and I'd like to have Access pop up a custom message...

Working Now! Okay I figured it out! I had to modify the popup to use a list box and then had the recordset stored and then passed on to the main form. Scott :)

I've search around the forum and haven't come up with the answer yet. So here goes... I have a main form (GRCSearch) that is tied to a table (StoredSearches). When users enter data in this form it saves it to the table. It is a single record form. The data entered by the user is used to...

Well I tried coping the entire code over first. That didn't work so I cut out everything except the code I was interested in. Both had the same results. The entire first section was hilighted. I followed the instruction on the KB article to a tee the first time but it had the error. I'll do...

Here is the entire section taken from the KB article that I've plugged into a module Public Function InStrRev(ByVal sIn As String, sFind As String, _ Optional nStart As Long = 1, Optional bCompare As _ VbCompareMethod = vbBinaryCompare) As Long Dim nPos As Long...

I get the error and click OKAY, the entire line below is highlighted: This is straight from the article and the error again is: "Compile Error: Automation Type not supported in Visual Basic" Thanks!

problem Well I plugged the code from the article into a module in my application. I immediately get a compile error that says "Automation type not supported in Visual Basic." The code is right from the article and is suppose to be for Access 97. I know enough about modules to be dangerous.

Thanks Thanks for sharing the knowledge base article with me. If I can get that to work it will be a miracle.... but I've got lucky before! Thanks again, Scott

I have code in a form that sets the path to images. It works fine in Access 2000. When I run it in Access 97 I get a compile error, Sub or Function not defined and it hangs on the string "InStrRev". Is there an equivelent 97 instruction? The full expression set is below with the point of the...