Search results

Define not working. All names with spaces have to be inside [] to work. Forms!Form4a!QuarterOrPealID = QuarterOrPealID Is QuarterOrPealID field the same field from the same table? Dale

Forms!Form4a!QuarterOrPealID = ActualNameHere. Dale

pre-eugin, Thank you for correcting my post. I am still trying to learn queries. Thanks again. Dale PS, Post deleted. Miss leading information.

Do the calculations in a query or redo the calculations on the report. I would first try to do the calculations in a query. Dale

First, Try the OnLoad event. On the Afterupdate event of a changed text box add Me.Recalc and/or subformname.recalc. Dale

Please post the entire code. Dale

In the subform, in the text box you want to insert/copy from, in the after update event try, Forms!YourMainFormName!MainFormTextBoxName = SubformTextbox Forms!YourMainFormName.Refresh Dale

try, Me.Requery in the after update event of the customer and the company text box. Dale

Why not use the delete macro that goes with the Delete record button when you made the button. Dale

Try this at the top of your function. Function getTatStatus(PO_date, ReqApp_date, [Working Days]) Dim PO_Date As Date Dim RegApp_Date As Date Dim WorkDays As Interger Dim TAT As String Dale What variables are you passing to this Function?

IIf ([PO Creation Date] < [Req Approval Date]), "", IIf([Working Days] < 0, "Pre-Req. Approval", IIf([Working Days] >= 0 And [Working Days] <= 3, "0 to 3 Days", IIf([Working Days] >= 4 And [Working Days] <= 6, "4 to 6 Days", IIf([Working Days] >= 7 And [Working Days] <= 10, "7 to 10 Days"...

Show your entire code please. Dale

SELECT tblMyTable.MyField FROM tblMyTable WHERE What youWant = WhatYou WantTo Show.If you use a WHERE clause you are filtering the data by what you want/do not want, to to be returned. Example: WHERE MyID = tblSomeThing_ID You don't need DISTINCT because there should not be duplicates. Dale

Try Querying for Null in the field Fulfilled Course or whatever field that shows the task complete. Dale

Put the button action inside the if statement. If the test is not met the the action will not run. Dale

Mihail, Setting the decimal to auto will give you 2 decimal places, will it not. Dale

Try setting your format to Standard and your decimal to 4 in your table. Dale

Try filtering with a WHERE clause and remove the DISTINCT. Dale

I think you could take the query you just make and use it plus the table. Give that a try. Nothing ventured, nothing gained. Don't change the join type, leave it as access sets it as an inner join. Dale

It is grouping on the other fields also. Put them back in 1 by 1 and you will see what I mean. I don't know how to explain it without writing a book. The query will group on each field in the query. There is no way to tell it to return the field and not group on it. Dale