Recent content by Dscalf1

I got it stupid mistake... I rearranged how they were layed out in my table and had the criteria in the wrong column...

I figured it out I had another parameter in there. But I need both.. For example under due date if the date has passed and its not completed its over due but if the date has passed and its completed its not over due.. In the due date i have the criteria as "< Date()" not what should I put in...

That didnt work it isnt pulling the action items that are overdue..

Good Morning, I am trying to run a query based on a date. Under my "Action Items" Table there is a column labeled "Due Date" it is the data type "Date/Time" and ion the table shows up as "M/DD/YYYY". I have a query called "Overdue Action Items" I want this query to only pull the items that have...

Thank you that was it... Such a simple mistake :banghead: .. Thank you for looking at it for me. And I will take a look at that article!

I did try what you had posted and it still prints both records... Is there anyway I can privately send you the database?

I changed it and it is still printing all the records idk why... should i have parameters on the report or something. I tried a different coding way and it did the same thing.. this is what else i have tried but it would print all the records as well Private Sub Command317_Click() On Error...

Here is the code: Private Sub Command317_Click() DoCmd.OpenReport "Bread Mold Report", , , "Swab Date = #" & Me.Text307 & "#" End Sub And I have it in a button on the form. When the user clicks the button a pop up comes up asks for the date and then still prints all the records.

I have tried that code idk if i am putting it in the wrong place or what but it isnt working for me.

Hey guys! I am trying to get a report to print out one one record that I want.. I feel like this should be easier than it seeming to be.. I want it to be able to be sorted by date and the user just picks a date and one record is printed out on page. Right now every record that is stored is...

This worked all except for when the number lands exactly on one of the lower acceptable, actionable and upper acceptable, actionable. It is supposed to be a greater than (not a greater than or equal to) For example: Specified Weight=37 L. Acc=35 L. Act=33 U. Acc=39 U. Act= 41 Right now if...

I have figure it out thanks though. I put the query in a subform and used the requery VBA.

I am trying to show the result of the query in a textbox on a form. My problem comes in because the query takes two numbers that form to run and I cant seem to get the form to update after the two numbers are entered into the form. I want the user to be able to enter in the two different...

I need to run a query in a form right now I have it as a button where the user presses and the result shows up in a different query screen. I am trying to figure out a way to show the result of the query directly onto the form. I have tried a subquery and it doesnt seem to update at all based...

You can use conditional formatting based on a query? It has to be off the query because as the specified weight number gets bigger so does the different rating ranges.. I tried using conditional formatting on the text boxes at first but then i figured out that the ranges change. I tried to use...