Search results

Marvellous. Thank-you!

Hello, I have a default value in a form based on a DMin value -1 , so that the 'Week Number' in a new record is one number less than the existing values in that field. Is there a way that I can get it to exclude zero? I would like the numbers to only be positive or negative integers. So that...

You are a modern day marvel. Works like a dream. Thank-you so much!

Do you mean to try using the Form name instead of the table name in the DMax function? I've started again and made a new table, query and then form incase I had gotten my wires twisted. I've attached a screenshot of the Query, and then of the Form and the expression that I have used in the form...

That is what I've been trying today, but it keep saying #Name? rather than inserting the next date. It is accepting the expression in the form properties but not returning the date. I have also had it saying #Type? when I tried a different selection of brackets....

I am building a Tour Booking Form and am trying to set the default value in the 'TourDate' field. I would like it to be the next consecutive available date from my 'TourDate' field in a table called 'CompositeKeySchedule'. I have previously done this using a =DateAdd ("d","1",DMAX()) expression...

Hello, I'm a new member trying to do a very rapid zero to hero learn of Access for a new job. I work in theatre and since it's been so quiet this year my boss has got me developing his dream high tech database... with no developer experience at all. I think I will have a lot of questions for...