Search results

I think I am going to have to give up on this idea, I have a feeling I am using the box in the wrong way having thought about your answer. My thanks to you and Moke for your help with this. I need to learn a little more before trying to leap ahead like this. Kind regards, Rob. :)

Thanks for your suggestion, now on my form the box shows:- #Name? After I put the expression in. Have I missed something here? Does it require the individual department name in it? Sorry if I am being a bit slow here, coding is not my strong point with Access. Rob :banghead:

When I enter the expression, I get a message 'The expression you entered has an invalid date value' This is what I have entered:- =DCount("*", "Tracker Main", "DEPT" = '" & Me.DEPT & "' And SCHEDULED= #' & Date & '#")

Could someone please help? I wish to create, on a data entry form, a box that shows the total number of entries for today's date. My tabel includes a 'Department' field and I'd like to show the number of entries for the day by each department. Is there an expression that will do this please...

Had a thought - the 'DEPT' field is generated from a 'look-up' list (which has it's own table to create the list) - will that impact the CF on the table? In my data entry it's simply a drop down list that I use to indicate the department. Does CF only work on manually entered text?

Thank you, Ridders and Arnel - I'll try that! :)

LOL, it's clearly me! I think I need medical attention! Thanks Ridders ... I'll step away from the database for a bit and return later, might see my error more clearly then. :)

I changed it from 'S&P' as the ampersand wouldn't show properly in the CF wizard. I've tried what you suggested and it still doesn't colour the box, unfortunately. Many thanks for your time and help though. :)

I have filled in the expression as such, however it doesn't show up in the table - as shown in the two files attached. I presume I am doing something wrong here? Rob :)

Yes that's right - simply to show that it's not applicable when the 'S&P' criteria is shown in the 'DEPT' field.

Sorry, my ineptitude in not reading your reply properly - many thanks again! :)

Thanks Ridders, your help is much appreciated. It's the background colour I want to change. So I actually want to colour the EMAILED & CLEARED fields together if the 'DEPT' field is 'S&P'. Is that possible? Sadly - as I am bit of a dullard with Access at the moment - I don't know how to...

Hello! Could someone please give a bit of help here? I'm using Access 2016. I wish to apply some formatting to a datasheet on a split form. I have a field called 'DEPT' and two others called 'EMAILED' and 'CLEARED' - what I want to build is an expression that means if the 'DEPT' field has a...

Ah, I see. Thank you for the tip - yes it's all a bit gobbledegook at the moment but I'm amazed just how powerful Access is!

I'm from Hull - itself a flood zone ... especially in 2007! I never get tired of visiting York, lovely place. Nice to chat to you and thanks for your welcome!

Thank you again for the help Minty, I am a newbie to this so it'll take me a bit of time to work out how to use a subform as a datasheet. Sorry if my answer seems a bit dim!

Thanks ridders, I'll check that out!

Wonderful, thanks Minty. Can I input that in the conditional formulating rule where it says 'Expression Is'?

Hello, please could you help me? I have a split form and on the datasheet I am trying to format a date column called 'SCHEDULED' (this is the date a specific job will be scheduled for), I have used the expression:- IsNull(SCHEDULED.Value) To flag it as a red box if there's no date given, but...

Hello! New here and pretty much a beginner with MS Access (using 2016), look forward to chatting with some of you - loads I'd love to learn. Rob