Recent content by damageinc86

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...