Search results

Thanks. It works great. Now, I'll look through the code and see if I can learn something.

I'm real apprehensive about uploading the database because it's going to show so many things I'm doing incorrectly or inefficient. Just remember, I'm self taught with lots of code copied off the internet. The reason this question came up is because I was giving the UI an upgrade or facelift...

Let me do some looking and see I can make any headway. Thanks theDBguy

When the PrinterData form loads Text12 holds the printerID number I've never used OpenArgs before, so I'll have to do some googling. CartridgeUse form does not open to new record. Combo76 is bound to the ID field of a query that lists active printers. Sorry, but I can't answer the...

NO.

I have a database for my company's printers. On the Main menu is a button that opens the CartridgeUse form. On this form is a combo box that allows me to pick a specific printer, which populates various fields about that printer and I then enter the number pages printed, click save and it closes...

The user wants a form with the past 4 drives listed as individual list boxes. I'm sure there's a way to filter in the List box, but I prefer queries. The solution provided by CindyKredo is working just fine. Thanks CindyKredo. RJW

plog, Answering using the sample data wouldn't explain it clearly. I posted a limited data set because I thought it was going to a simple solution. It turns out to be not so simple (from my perspective) The actual table has 500 records. 18 records with DriveID 15 19 records with DriveID 13 28...

I'd rather keep it as just queries. But when I change it from TOP 1 to TOP 2 or TOP 3 ... I still only get the records with the highest DriveID value. Am I missing something. Here is the current SQL code: SELECT TOP 1 Qy_All_FallDonations.* FROM Qy_All_FallDonations ORDER BY DriveID DESC...

Thanks isladogs First, I only used "Name" in the example. It's not the real name of the field. Your solution worked great. But now on to Part 2. The values in the "DriveID" field are always odd and always increase by two. What I need is 4 separate queries for the 4 highest values in the...

I need a query for records with the highest "DriveID" Table Name|Amount|DriveID Bob|45.00|1 Sue|60.00|3 Ed|30.00|3 Jim|75.00|5 Barb|25.00|5 Tom|50.00|5 The highest value in that field will change as more records are added, so I was hoping to use something like the MAX function to query...

Sub reports. Didn't think about that. That would do it. Thanks RJ

I'd like to create a report with two columns, one column for ID numbers that are even and a second column for ID numbers that are odd First five rows of my table. ID, Amount 1, $22,775.00 2, $30,665.00 3, $21,700.00 4, $31,875.00 5...

I'm not a programmer. I could not do that. I build almost exclusively in Design mode & I google for a lot of VBA code. I have only 7 years. I'll build 7 reports and based on the year picked I'll put code in the "View Report" button to pick the specific Report. Thanks for helping everyone.

The query "QSpecificYear" is a Crosstab query. The names of the fields in the query change based on input from a Form. I'm using that query as a source for a Report. If the year 2013 is chosen on the Form, The fourth and fifth field in the query are labeled "2" and "3" If year 2014 is...

Trying to create a Report, it's source is a query "QSpecificYear" Depending on which year is picked on a Form, the names of two fields in the query change. Example: If year 2013, the field names are ... FirstName,LastName,PledgedAmount,2,3 If year 2014, the field names are ...

The data is actually persons or companies that have pledged money to a Non-profit radio station and the last digit is which specific drive the money was given. I want to create a scrolling sub-form in a horizontal layout, with one line per person, showing how much each person gave for each...

Got It. Thanks Ranman256

The final result would have 6 fields. Company,1,2,3,4,5

That was quick, and you understood. And thanks "Plog" for the proper posting method.