Search results

You are correct namliam. I'm just a novice Access user trying to learn the disciplines as I go along. I will remember your teachings well in my next Access adventure. Thank you, again!

Thanks for your solution as well namliam!

CJ, Thanks, you got me to follow the right track I just needed to experiment finding the right Syntax for DLookup. I found this works very well: DLookup("Val([VcoDispChk]+[VcoInChk])","Reservations", "Reservations.].[CR#_] = 'CR01' And [VcoDispChk] = True and [VcoInChk] =False") I did not...

CR#=CR01, VcoDispChk = True and VcoInchk = False. If a DLookup can find this instance of a single row, that will suffice to use Conditional Formatting to color in a Flag. Thank you.

CJ, attached the table data I need to use to find the highlighted row. thank you.

CJ_London, Thank you. I'm using the information just as a general Dashboard. The table is one to many of the same CR#'s. there are four inspections per CR# and i only need to find one overdue inspection or one inspection due within the next 30-days. i will use conditional formatting to highlight...

In table design you have the option to choose the field type and one of the options is calculated field. It uses other fields in the table to calculate on the spot.

Took me a couple of hours trial and error but finally got the third criteria Syntax to work: Dlookup("DueODue", "Fleet_PMCS", "[CR#] = 'CR50' And DueODue >= Date() and DueODue <= Date()+30 And Completed = False"). I'm guessing that the table field (Calculated Date) DueODue does not need any...

Thanks Arnelgp, I got this to work. I had to close out Compact and Repair and the code starting working. I can now get CR# and Complete = False to get the right Dates. I need your help to add the third criteria. I need to use DueODue again but need to find the date between Today() and...

I tried this: IsNull( Dlookup("DueODue", "Fleet_PMCS", "[CR#] = 'CR50' And Completed = False")) still same #error.

I tried this: Dlookup("# DueODue #", "Fleet_PMCS", "[CR#] = 'CR50' And Completed = False") I'm still getting the same #error. Does this also mean no records? I know the table has the data I need. I just can't get DLookup to retrieve it.

I'm also using the code in a Switchboard. I just used the code and the text box just says #error. I have multiple Dlookup statements on a Switchboard looking at the same table all at the same time. This never happened before but when I corrected the extra " all seven of the DLookup statements...

I've tried using the Syntax in the above examples. However, I'm not getting an error message and my multiple Criteria Dlookup code is not giving me the correct result. Dlookup("DueODue", "Fleet_PMCS", "[CR#] = 'CR50'" This part works fine and returns the last table row occurrence of 'CR50'...

Hello, everyone. looking forward to learning Access programing. Gary