Search results

I am having a hard time figuring this one out. I created a button on my report to search through the report and it worked fine. I made a boatload of changes and now I can't get it to work. I have no clue why, as there were no changes to the report that I can remember (other than making the...

Hi guys, I'm trying to make a report and I'm pretty much totally lost. I have multiple records I would like to show on a report. I have created a form to enable options (date range, serial number, word search). Given the options available, the number of records will be variable. If someone can...

Simple issue but I have spent hours and hours trying to find the answer and I have come up empty-handed. I need the 3rd combo box to be cascaded off the 2nd. The 3rd is to display the ID based off what the 2nd combo box is. For some reason when I copy the steps I took to cascade the 2nd and...

Hi guys! I'm trying to Identify a particular entry in my table for editing via combo boxes. The same serial number will come in multiple times but a different job number each time it comes in. To identify a record for editing I need the user to identify the serial number in combo1 and then the...

I'm fairly new to Access and I've been at this for quite a while now and can't figure out how to make only unique values show in my combo box. In the picture I show lots of "1"s. If I move "ID" to the right of Serial # and select unique values, it removes duplicates entirely (meaning there are...

I'm rather new to Access and I've been trying to get something to work and countless searches have provided nothing that I can use. I'm trying to set buttons as numbers on one form and then checking another form to see if those buttons were pressed so it will set RecordSource. Button Form...

Unfortunately I'm very new to both Access and VBA so I'm having some trouble getting this setup. On a form I have multiple buttons. When I push one of those buttons I'd like it to open the new (reuseable) form I've created and have the recordsource be that button's caption (there's a table...

Hi, Scoured the internet and these forums and I'm unable to find what I'm looking for. I have a memo cell in a table that I'd like users to be able to insert their name into (from the same form). Basically allowing a user to throw their name into the memo, then auto-clear the box. When they...