Search results

Thanks all, always amazes me how powerful access can be, just hope it is here for a few more years...

Thanks Pat, I will get rid of the timer even and do it on open form. We do not have multiple people running the application as only a very small business. If you all dont mind I will rewrite it in open form, copy the code and see what you all think. We will not overbug the customer as we...

I know I am going to change it, forgot to save it. Completely forgot the date was 3/3/2024 no wonder it worked (LOL) I will change it again without the #character, I am only working on this in my spare time so will try again later.

Thanks Pat, Think I get you, what I have done whether right or not I do not know. Is when I open the database a welcome form opens first with which I plan to add buttons to. Then a timer event occurs to check the followupdate criteria if some match then it opens a Notice form which I have...

Hi All, I would just like to say you have all been super helpful so thank you. I changed some of the code to include date and got rid of the # character and all was working. After working late on it last night I forgot to save the code and it went to earlier save version of this :- Private...

Hi CJ, I'm in the uk so will be using dd/,mm/yyyy I will try changing the #character So now I have I will give this a bash in the morning perhaps with fresher eyes, will let you know how I get on. :)

Hi Thanks for that, I did try the date format and the exact same thing happens. What I have done is when a date is today or past (dont want future) it opens a blank form to say that they need to be contacted then I have put a button on that form to go to the records that match that criteria...

Hi The_Doc_Man Thank you for you reply The Record ID we manually enter to link to another table what I have basically done is a customer record table then a seperate table for maintenance contracts all I wanted to do is when the date is today or in the past it will open a form to say we need...

Firstly new to this forum and after a long time of not using access I have decided to use the program for a customer database. I am currently creating tables and forms for different aspects of our business. Unfortunately I seem to be banging my head head against a wall on this one and I am...

Hi everyone, came across this forum whilst researching some access problems I am having. Not used access in a long time so still learning the ropes. Only problem is... seem to be addicted to it now :)