Search results

I've been looking around trying to solve this and it seems that I shouldn't be using a hyperlink instead I should be using a "bookmark" to find records. I'm trying to take the autonumber (primary key) that shows up on the search form once it has been filtered down and click that to take me to...

Ok, thanks GinaWhipp I changed it and now the form closes as it should but now the link isn't opening the matching record in the form. Do you have any idea on how to fix that?

PaulO In the macro the first step is set up to close the search form and then open the next one. GinaWhipp, To be honest I'm not 100% sure how to make the search form a snapshot; help please? :)

I'm hoping to get a reply to solve this. Attached is my Access 2007 database, what I was trying to do is use the AutoNumber field as a hyperlink to go from the search form to the matching Accident/Near Miss Form so that the user can update records that they just searched for. I keep getting an...

I'm not sure who did what to the database that I loaded but someone found the, what I call the middle file after I split the database and then made it ACCDE. Now when I log in I get this message: "The SQL Statement could not be executed because it contains ambiguous outer joins. To force one...

After a lot of trial and error I think I got most of this nailed down and found a lot of my stupid mistakes :rolleyes: The thing I wasn't sure if anyone can help me with now is the drop boxes, can I use those for searching that specific text or do I have to use text boxes for searching?

Attached is part of a 2007 Access Database, as you can see I copied the form view and layout from the sample I've seen posted on this site but I can't get either of the filter buttons to work. Any idea what and where I am going wrong with the code?

Thank you, that was more information then I really needed but I was able to put it to good use and get that part of the database nailed down.

Not 100% sure this goes in this section but I'm giving it a shot. As my SN shows I'm not a programmer yet I've been asked to build an access database for the EH&S (since I've built a few minor ones for my department) and I was wondering how I would go about using the calendar control option...