Search results

OK then... can anybody else with a more modern version of Access take a shot at this???

Not sure why it's crashing. And I'm not too concerned about the information in the database. It's just lawn mowers... lol But thanks!

OK. Here it is. Please let me know if it was not saved properly.

Hello there. I need some help securing an Access database. I've never done anything like this before. I am about to put the database on a shared drive. I want myself to be able to do anything (of course), my co-worker Paul to be able to ONLY enter information (along with being able to view...

No problem. Thanks again for all the hard work. Talk to you later...

BTW, SXSCHECH, are you any good with password protecting a database??? I've never done anything like this before. But I want to put it on a shared drive. I want myself to be able to do anything (of course), my co-worker Paul to be able to ONLY enter information, and my boss to ONLY be able to...

THAT IS ONE OF THE MOST BEAUTIFUL THINGS I HAVE EVER SEEN!!! I, in no way, can believe that you stuck with this STUPID issue as long as you did. THANK YOU!!!!!!!!!! PROBLEM SOLVED! DG

Sorry about that. I guess my head knew what I wanted, but my fingers never typed it!!! :-)

What you posted is exactly what I am looking at here. The order that I am looking for is something more like this: Battery, Air Filter, Fuel Filter, Oil Filter, Deck Belt, Hydro Belt, PTO Belt.

Yes please. That would be very helpful!

No. The sorting of the Report has not changed at all. I'm still trying to figure it out.

OK, if the report is sorted that way, I have no idea why. As far the semicolons, I'm pretty sure that I added them in the last batch of changes.

OK. I just added the database. The Union Query that we are using is titled "qryPartUsageUnion", and the Report is named "Parts Usage Report". Please let me know if you can break this case wide open for us!!! :) DG

OK, so I finally figured out that I had to scroll down on the screen to see the button that says Add a Sort. But, when I added "PartType" to it, nothing happened. This seems futile! :-(

OK, since my goal is to have my report display in some type of order, I used the following code: SELECT * FROM ( SELECT * FROM sbqryUseBattery UNION SELECT * FROM sbqryUseBeltsDeck; UNION SELECT * FROM sbqryUseBeltsHydro; UNION SELECT * FROM sbqryUseBeltsPTO; UNION SELECT * FROM...

I guess that I'm dumber than I think I am... I wasn't able to get any of that to work! When I select "Group, Sort & Total", I want to show the belts first, so under "Group on PartType", I select "with title click to add" and add "Belts". Then, when I run the report, EVERY PART TYPE HAS "Belts"...

Hello. I have a Union Query (that works perfectly fine) with the following code: SELECT * FROM sbqryUseBattery UNION SELECT * FROM sbqryUseBeltsDeck; UNION SELECT * FROM sbqryUseBeltsHydro; UNION SELECT * FROM sbqryUseBeltsPTO; UNION SELECT * FROM sbqryUseFiltersAir UNION SELECT * FROM...

OK Uncle Gizmo, I did that. And I think that I understand how what you gave me works. When you open Form2, it populates the "textID" textbox with the number 3. So now my question is, what if I wanted to instead populate the "textID" textbox with a value that was on Form1? For example, if I...

The name of the textbox on the form is: AltID

Arghhhh!!! I don't know!!! "AltID" is a... a... a... OK. Here's what I did... When I added "AltID" (as an afterthought), I added a textbox to the form & report. Then, in that texboxes' "Control Source, I used the "AltID" field that I also added to the "Inspection" table. Does that make any...