Search results

In the AfterUpdate event of the 'Damage to Property' field, you could add code along the lines of If [Forms]![form name]![Damage to Property] = True Then [Forms]![form name]![Damage Contents].Enabled = True Else [Forms]![form name]![Damage Contents].Enabled = False End If This...

You don't need to compare the hours and minutes separately. I think this should do it. IIf(Format([Request date], "HH:MM") > #12:30:00 PM#, "After 12:30", "Before 12:30")

I think this is about right. =DCount("[CLASSIFICATION]","table name","[CLASSIFICATION] = Preliminary' And (Not IsNull([PROD1]) Or Not IsNull([PROD2]) Or Not IsNull([PROD3])")

What is the table structure? I'm trying to picture how you're storing the callback info. I would guess a query that asks for all names where there is a callback date and where the callback date isn't in the list of all calls made for that same person?

If you don't want a total (i.e. all cell values added together), you could use DCount, rather than DSum e.g. =DCount("CLASSIFICATION]","table name","([CLASSIFICATION]='Preliminary' And ([PROD1]='?' Or [PROD2]='?' Or [PROD3]='?'")) This counts the number of Classification values for all...

Try putting quotes around [Barcode].

Thanks, both (it's much more reassuring to hear about personal use than just reading the product reviews). I'll look into all three and get something sorted out.

Do you mean after or before update? I only ask as it's safer to stop the record being inserted than to delete it afterwards. Either way, you can use DCount() for that record in the relevant table. If it returns more than zero, you've got a duplicate.

You can use the Replace() function to replace any occurrence with the full "Elizabeth". e.g. Loop through table For each record, Replace(name,"Elizh","Elizabeth") End loop If Elizh is anywhere, it gets replaced. f it doesn't exist in a record, nothing happens.

Are the fields Period and Year strings or dates? If the former, you need to put the criteria in single quotations, if the latter you need to use hash (or pound) signs. e.g. strQuery = "SELECT Workfile.Period, Workfile.Year FROM Workfile " & _ "GROUP BY Workfile.Period, Workfile.Year " & _...

Glad to help.

Glad to help.

I think it's because you don't need the double-quotes if you don't have a filter. As long as thr right number of commas are present, a space is fine e.g. DoCmd.OpenForm pvcAirCmp1LoadCus, acFormPivotTable, , "[qryAirComprs]![fldDATE] Between [Forms]![frmHome]![AirCmpStartDate] And...

Sounds promising. What size paper does it accept (could I print 4 x 6 or 5 x 7 photos)?

Private Sub Option183_Click() DoCmd.OpenReport "Rpt_Charges03", acPreview, "", "" DoCmd.Maximize [Forms]![formname]![Option183] = False End Sub Should reset it to be clear, after opening the report.

I'm still setting up, so I was hoping to stay this side of $400 CAN.

Sorry, when I said 'working' I meant 'working for that form'. The following will set the filter and ensure that filtering is allowed, but if there is something resetting either value after this, you'll still have problems. [Forms]![form name].Form.Filter = "filter" [Forms]![form...

To transfer data you need an append, rather than an update, query. e.g. INSERT INTO Available_Reports ( Listed_Name ) SELECT AllReports.Listed_Name FROM AllReports WHERE (((AllReports.Listed_Name)=[Enter Name:])); This query just appends the values from one field of one table to one field of...