Search results for query: *

This is my code: SELECT TOP 5 * FROM [Top 20 Installation Data] WHERE (((MT)="s52w1")) AND [DO] > [Forms]![Repeats Interface]![Volume] Union SELECT TOP 5 MT, * FROM [Top 20 Installation Data] WHERE (((MT)="s52w2")) AND [DO] > [Forms]![Repeats Interface]![Volume] Union SELECT TOP 5 MT, * FROM...

I want to know if there is a way that i can prompt the user with a message stating that "The criteria you input returns no records." as opposed to getting #Error on my report, or a blank report. KaayJaay

Is there a way that i can send the user a message stating that "there are no records returned for the criteria you input" when a query doesnt return anything, as opposed to my report being filled with #Error signs, or a blank page? KaayJaay

The "Tech_Data" table needs to inner join with the "Top 20 Installation Data" table, but i dont know how to reconfigure my query for the inner join. Any Suggestions? My SQL query code: SELECT TOP 5 * FROM [Top 20 Installation Data] WHERE (((MT)="s52w1")) AND [Tech_Data].DO >...

Thanks for all of your help, the info about the date i gave you helped me realize my stupidity, I have a form doing the date calculation, but i wasnt using the form when i was running the query, hence, no information was entered in the date text boxes. I ran it in the form, and it worked...

What is also interesting, is another query i have that is not sorted with the date criteria above works. Heres the code: SELECT [Total Repair Repeats].MT_RC AS MT, [Total Repair Repeats].Full_RC AS MU, Count([Total Repair Repeats].[OR_Disp]) AS Repeats, Sum([Tech_Data Query].[VSO]+[Tech_Data...

Alright, i will try that thanks. What is the QBE you are referring too? KaayJaay

I cant understand why i get this error message"This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables. (Error 3071)"...

Yes. The wierdest part about it is that when it opens in form view the first time, it shows existing values, if i go to design view, then go back to form view, the default values are shown. KaayJaay

I have this form that is used to find records, never change records, only find. When it opens instead of opening with the default values specified, it opens with existing values. Now when i go to design view, and then back to form view, it shows the default values like its supposed too. I am...

Hey is there a way to popping up a Alarm message or prompt, instead of an Message box? My reason for asking is, i dont know visual basic code, but i want to use a before update that will check to see if such a record exist in my database, and if it does, than continue to display record, if it...

Thank You, But in using the after update, doesnt the data get processed before the After Update is run? I want to be able to say to the user, invalid entry, without having garbage data sent. KaayJaay

I would like to have a data validating entry field that will basically force the user to enter valid information into the pop up text box. As opposed to allowing the user to enter garbage and then in turn spitting out garbage. Any Suggestions? KaayJaay

I have a form set for Data Entry but, when the form opens up, it opens with existing records displayed in my text box fields as opposed to the default values that i had specified. I thought that maybe by turning off the allow additions, allow edits, and allow deletions, since all i want to be...

I have a form set for Data Entry, and instead of bringing the form up with the default values, it brings the form up with existing data. I thought that maybe by turning off the allow additions, allow edits, and allow deletions, since all i want to be able to do is find info, i thought that would...

Thanks, I have the form set for Data Entry, and thats what its doing, I thought that maybe by turning off the allow additions, allow edits, and allow deletions, since all i want to be able to do is find info, i thought that would work, but when i do that all i see is a blank screen. Why is...

A form, opens with present data already inside of the text boxes as opposed to the text boxes having the default values that i had specified. Not sure of why. Also, i have another for that is to add records, but if i start to add a record, and click no on the confirmation, it adds the record...

Disregard All, I have found a solution :) KaayJaay

Here is my code, Top 20 is a form with 2 toggle buttons on it. The user then select Command135 which is a submit button, but it doesnt run anything when the submit is clicked. Cant figure out why. Private Sub Command135_Click() If [Forms]![Repeats Interface]![Top20].OnClick = "Install"...

How do i do this? KaayJaay