Search results

So how would you get the query into a listbox? Just do the source, and then set the right number of fields so it doesn't just show the first one? Why would a listbox be able to be called upon by multiple users at the same time? I'm just curious, this is my first time ever really delving into...

Thankfully this will be one user at a time on one computer. But I would still be curious how to do the same thing in a multi-user environment.

Yeah, I got a button to de-select whatever boxes where checked, found some simple code on some other post that works great. But for my Select all button, I can't get it to give the focus back to the checkbox field within the query once it has been clicked. So It only populates all the...

Awesome that works pretty well! Could you explain what you did there? What changed? Is there a way to clear the select checks with a button perhaps? I noticed when I search again, whatever I had checked last time will already be selected.

Hey thanks, but the print still shows both records even though i select only one. And I accidentally clicked a checkbox for a new record and it had some crazy error messages and a debug thing pop up.

Yeah, now after trying so many different things, somehow I managed to break by text box for the search, can't even type anything into it again, even when I deleted it and re-created it. I'm at a complete loss now. I never would've guessed it would be this hard to just select some records and...

Yes the listbox row source only shows the first field, my ID field. so it's just a number. Anyone who could take the database and show me the code in practice then send it back? Or maybe explain how to make the checkbox field the only field in the record that can be edited. That would work...

Yes, I've seen the listbox suggestion all over, but when I try to put a listbox in my form I can't figure out how populate the list box with my query results. So I don't even get past step one. I just want to be able to highlight the records and print them only. Either that or figure out how...

I have a Form with a subform in it that has a query as a source, and updates the query to filter by whatever is typed in a search txtbox. It requeries when you click the search button based on what's in the search txtbox. Now I'm just trying to figure out how to let the user highlight a few...

Right, that makes more sense, because it's basically what i'm already doing. I do have a table with all of the transactions in it that also have the customer# next to them. So I would just be linking that table to the parent customer# table if I understand correctly. I think this is what it...

Right, I understand the power of queries, and I can see how what seems like unrelated info in a large table can easily get connected to meaningful results with the queries. So do you have any advice on my question about how to get a certain set of transactions in the transactions table to all...

Yes! because the only real pertinent data we need from the fiche is the person, their cust #, and all the microFILM reel details, so we can then go into the microfilm room and find that reel to print out the letter that was sent to them 10 years ago. I suppose I could include the actual number...

Yeah I looked at those search results, but really I don't find it to be a problem other than the fact that the records are on microfiche. Visually, on the enlarged image it looks exactly like what I re-created in the image. It's a spreadsheet format really, so just imagine it was a directory...

No i'm a low level employee, I am just running a desk that processing this stuff. I was hoping that if I got a decent working database going on my own first, that my boss might find it a worthy endeavor and back me up on it. Plus it would make my job a lot easier when I no longer have to go...

Wow thank you for the thoughtful post. That is a lot to chew on, and some of it makes sense. But yes the novice in me is very lost still with the theory. I will only be using the microfiche card to print out a single customer's records. Then I want to go one by one, and put those into the...

So i watched some youtube videos about relationships, and it made a little more sense. But the examples usually used don't seem to have a lot of similarities to the data that I will have at the end stage I guess you could call it. The real data that will be aggregated by having a...

I determined it by the fact that if I gave a table to each customer number, and within that table it had all the different dates of transactions, then there would be way too many tables. Well I obviously do not understand the relationship stuff, which is why I sought guidance here in the Theory...

I am trying to setup a database for my desk at work which will eventually have thousands and thousands of customer numbers, with details about each customer. Each customer number will have a bunch of details like dates and document numbers and such, each needing their own row for one date's...

Do you have any experience bringing this search code over to visual studio? I have linked the database as a data source, and got the table to populate the box under my search fields like it does when the "clear" button is pressed in the access version. I copied and pasted the search code into...

Now I'm wondering about actual Visual Basic, and making a standalone program to search. I tried to connect the database, and got that working, re-created the access search fields and buttons. I guess there is a little bit of difference in coding, because when i put the code from the access vb...