Search results

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

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

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

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

Is there a query, or queries that can transform this data ... Company A 200 2 Company A 400 3 Company A 300 5 Company B 500 1 Company B 500 2 Company C 100 2 Company C 100 4...

My database has only two tables Form 1 has three steps each with their own button, each button opens a new form. Step 1 - Button 1, opens Form 2. Which has a button that runs an update query that resets 15 Yes/No fields in Table A to no. Closing Form 2 returns the user to Form 1 Step 2 -...

I have a form, called "Repairs" with an Option Group. Clicking a button in the Option Group will reveal a specific set of fields on the form. (That works fine) Now I would like to add a button on a different form that opens the "Repairs" form with one of the Option Group choices already...

Sorry for the simple question ... I have this line which works CurrentDb.Execute "UPDATE Responses SET FollowUp = 0 WHERE ID = 131" But I need the value for the WHERE ID = to be a value of a field on the current loaded form. Form Name: Response Field Name: Text33 I can't seem to get the...

I can't seem to locate where to go to shrink the spacing between my grouped items. See attached screen shots. RJ Wellstead

On a form I have an option group with three choices: Current Month Last Month Year to Date I need the users choice to filter a date field in a query. I tried ... After Update: If Me.Frame29 = 3 Then Me.Text38 = "Year((Now()))" And then in the query I had the criteria...

I have a form (called: Current Month) with a 7 page Tab Control. Each Page has a command button, which opens another form (a different form for each page) I can set the focus to the command button on first Page when the Current Month form loads. When I click on Page 2 of the Tab Control, I'd...

Sorry for the simple question ... if I knew how to ask I'm sure I'd find the answer myself. Text field on a form is the search criteria for multiple fields in a query. Here's the SQL code: SELECT Attendees.* FROM Attendees WHERE (((Attendees.[First Name])=Forms![Keyword Search]![Text0])) Or...

I've searched and haven't seen this particular question asked and answered before. Sorry if was and I missed it. I create my forms so that the user entering the data can use the tab key to move through the entire form and hopefully never touch the mouse. And I have forms that are longer than...