Search results

The third argument of the function DCount() "WhereCondition" is a string! :)

Checked it out. It worked for me like this: =DCount("*";"tblJobRefBook";"JobStatus = 'Quoted' AND QuotedDate >=" & Format(Date()-30;"\#mm/dd/yyyy\#"))

If your regional date format is different from MM/DD/YYYY - try this: =DCount("Quoted","tblJobRefBook","[JobStatus] = 'Quoted' AND QuotedDate >=" & Format(Date()-30, "\#mm\/dd\/yyyy\#"))

Try use sub forms

Or in this way: Dim strMailMessage As String Dim strRes As String strMailMessage = "Bla - Bla - Bla " & vbCrLf & vbCrLf & vbCrLf & "First name:" & _ vbCrLf & vbCrLf & "Phil" & vbCrLf & "GOGO" & vbCrLf & vbCrLf & "Last name:" 'Debug.Print strMailMessage strRes =...

Use Len() function

Try this expression: =IIf(IsNull([SaleOrder]);Null;Nz(DCount("*";"SalesOrderDetailsT";"SaleID=" & [SaleID] & "AND SaleOrder <" & [SaleOrder]);0)+1)

If I understood you correctly, something like this:

Use a colon to combine lines If (Me.standard <> "apple") And (Me.frequency = "annual") Then strDocName = "report1": msgbox "all good", vbInformation

Wrong!!! In my opinion you should take the argument from current record of open Recordset - not from current record of subform. ... "' and endt_num =" & Rs!endt_num & ";"

What about the space character? SELECT * FROM [YourTableName] WHERE ([YourFieldName] Like "*[!A-Z,a-z,0-9]*"); With space character exception: SELECT * FROM [YourTableName] WHERE ([YourFieldName] Like "*[!A-Z,a-z, ,0-9]*");

try IsError Function =IIf(IsError([Enquirymaster100 subform].[Form]![REF NO]);0;[Enquirymaster100 subform].[Form]![REF NO])

you can also use this effect to highlight an active record in a continious form Restriction: All form data fields must not be available for focus.

This won't be a problem, since you can also use the function in your code. Private Sub ObjectName_GotFocus() FRMControlFocusInOut Me.Name, True 'Highlighting Control ' your code ... End Sub Private Sub ObjectName_LostFocus() FRMControlFocusInOut Me.Name, False 'Highlighting Control...

Yes! - we do. Step 01 Set BackColor (of selected fields) to #FFFDD1 Step 02 Set back style (of selected fields) = Transparent ... And "hocus pocus" is ready. :cool: Good luck!

I meant, almost the same result I think - the more choice of solutions - the better

01. Setting the field back color (Light Yellow) 02. Making the field back style transparent - Done! When the field gots focus, it restores the background color

And ... Almost the same without any code at all (y)

the same with less code ...

Try to use semicolons instead of commas as separators of function arguments