Search results

thank you

thank you

Awesome, thank you , that did it. It still removed the brackets after date though. Another question if possible for anyone, is there anyway to remove the minimise, restore and close buttons in the top right corner of forms to stop them being closed down without clicking a button on the form...

Hi, I have tried the code and just get an error (see attched image), my field is called MembershipExpiry and is formated as a date. When I type the Date() in, it automatically removes the brackets. I also had to remove the last End if due to another error. I have added my table in design view...

Thank you arnelgp for this, I will give it a try shortly and get let you know how I got on. Yes I only have one members table which is the source for the form.

thanks, but still none the wiser, I am a beginner and just about the smash computer up. Any chance of a simple example with explanation?

Hi, thank you for your persistance with me, I am trying the following code to try and get a form to pop up. my table is called 'Members', the expiry field is called 'MemberExpiry' and the members ID field is 'MemberID'. The pop up form is called 'red' the first part looks up the the member...

thank you for your reply, I have the text boxes turning orange when the date is within 7 days to warn them. The only thing I am struggling on is when it has expired....

Yes it makes sense, but I am struggling on how to do the code for it because what ever I tryI cannot get it to work.. If all coding was as easy as pseudo our life would be easy..... I will keep trying thanks

yes that's it, but I am struggling on how to do it

Ok, thanks for your responses. A friend of mine is opening a new gym and asked me to set up a database for him, all of the data will already be in the database, so validation takes place at entry of data itself. When the member comes in to the gym, they scan their card or enter their...

Thank you for your replies, but that will only work if you click in the date cell. I would like a pop up to appear as soon as the record is accessed and the date is overdue. thanks again

Hello, I am creating a membership database (in Access 2016/19), when the persons membership number is selected and the record is shown, if the membership is out of date I would like a pop up to appear on the screen to stop the user going any further until a password is entered to clear the...

If the date is within 3 days, i would like the pop up to happen, but it needs to have a password entered/typed in to close the pop up down.

I have slightly edited the question I would like the pop up message or form to appear when a record is opened and meeds the criteria, e.g. if record 23 is selected and the date (date of birth) shows as being within the next few days, then a pop up form or message will appear, but only close...

Thank you for your reply, I might sound a little dim, but how does this open a pop up message and where do I type it? Does it need to have something created first to do this? again thank you

Hi, I am a newbe to access and am trying to create a database, which is going well so far. I would like to get a pop up box or form to appear depending on a value in a date field. I have menaged to get the text boxes to change colour depending on the date, but not sure about getting a pop up...