Adding "Open" column to Query Result

[premis]

I am trying to add the "open" column to my query result to provide a hyperlink to the contact details form. It shows up on my contact list but I can't get it to show up on the query list after it is run. Is this possible?



Two pictures are attached, "Untitled-1.jpg" shows the column I want to add to my query. "Untitled-2.jpg" shows the query. And "Untitled-3.jpg" shows the form I am trying to open with the hyperlink in the open column. Of course, the hyperlink should open the record I select that was returned in the query.

I am a fairly novice user, but can usually figure it out with a little help. Any help would be greatly appreciated.

[pbaldy]

I would likely use this technique:

BaldyWeb wherecondition

[premis]

Thanks for the quick reply pbaldy.

It looks like I may have underestimated my skills. While some of that code looks familiar, I'm still pretty lost. Where would I put that code?

I currently have a form (attached) that allows me to search on 7 different criteria, but one at a time. I enter the criteria into the form and hit the search button for that particular field. Each button then activates the corresponding query based on that field using this formula --Like "*" & [Forms]![SearchForm]![FirstName] & "*"---.

So, do I put that code into the code for the search button? I am currently using a macro in the macro builder. I don't see a way to get your code in there.

[pbaldy]

From the sound of it, the click or double click event of the textbox containing the value.

http://www.baldyweb.com/FirstVBA.htm

[premis]

From the sound of it, the click or double click event of the textbox containing the value.

http://www.baldyweb.com/FirstVBA.htm

I tried using the code, but couldn't get it to work. I would really prefer to just add the "open" link to the query results table. Is there a way to do that? What about having the results come out in a form and adding the "open" link to that form?

[pbaldy]

I can't think of a way offhand, and I think it would be more work. Do you want to post your db and we'll figure out what you did wrong?

[premis]

I can't think of a way offhand, and I think it would be more work. Do you want to post your db and we'll figure out what you did wrong?

Sure, we can try that. I tried uploading it but the compressed file size was too big, it is over the 2mb limit. I tried hosting it at a file transfer site, hopefully this link will work. https://www.sendthisfile.com/ljsXNoaap7e7WWim7l6P3PGZ

I forgot to mention above, and one thing that may make a difference, For the phone, e-mail, first name, and last name search boxes I am performing an "OR" query on multiple fields (ex. Phone searches "business phone" "home phone" etc..). it looked like the code didn't account for that.

I tried placing your code in the double click event on the first name search button on the Client Search Form.

I really appreciate the help.

[pbaldy]

More what I meant was this in the double click event of the last name field on the Client List form:

DoCmd.OpenForm "Client Details", , , "[Last Name] = '" & Me.Last_Name & "'"

which opens the details form to the selected record.

[pbaldy]

Or better, using the ID instead of the name, which could be duplicated:

DoCmd.OpenForm "Client Details", , , "[ID] = " & Me.ID

[premis]

Or better, using the ID instead of the name, which could be duplicated:

DoCmd.OpenForm "Client Details", , , "[ID] = " & Me.ID

That works on the client list form, it was actually already there. My problem is with the query. When I run the query to search for the first name, for example, the results are given to me in a query table format (see image untitled-2.jpg in original post). Double clicking the last name on that yields nothing, and I can't find a way to add the code to the query results.

[pbaldy]

I never let users into tables or queries; you have no real control over what they do there. I would give them the results in a form. By the way, you might want to consider the search method in the sample db here:

http://www.baldyweb.com/BuildSQL.htm

which returns the results into a subform for the user.

[premis]

ALRIGHT! I got it! I made a form and used your code to get to the detail form.

Thank you SO MUCH!!!! I really appreciate your help!

[pbaldy]

Happy to help!