Search results

sorry im quite new to access and not sure what you mean

hi that looks quite complex for what i need, i can set a simple password by default before i convert to a runtime but then it means whoever i send the database too has to use that one, whereas id rather they could choose one them selves

hi the problem is that i dont know who will be using it, lots of people dont even have passwords on their laptops hence the need for a simple password access

hello all, not sure if this is the right section but is there a way that i can set a runtime database so that the users can set their own password to protect the database rather than me setting one prior to converting to a runtime product

hello galaxiom, thanks for your advice, i take your point and it is good advice, but i think at this time its way beyond my capabilities, unless you can provide comprehensive instructions on doing this in which case i would be happy to have a look at doing it

thats great thanks a lot it works now, much appreciated

hi thanks for taking a look, did you make any changes, did you make the button work because when i download it it still doesn't do anything for me

hello heres the database im trying to get the button to work on, all i need to do is every time you click the renew button it adds one year to the renewal date to its left for this record only

ok i can zip it but how and where do i upload it

how do i upload the database

sorry still not working

this is the code Private Sub renew_Click() Me.[Renewal date] = DateAdd("yyyy", 1, Me.[Renewal date]) End Sub the field i want to add the year to is called "Renewal date"

hi my renewal date field is called Renewal date, ive tried putting brackets round like this [Renewal date] but it didnt do anything

hi minty now i understand where to put it thanks, but im not sure ive explained what i want properly, the join date is whatever date they joined and can be any one of the 365 days in the year and once entered does not ever need to change, the renewal date is same as join date but plus one...

hello thanks for that, but im not sure where to add that, also how do i tell it which date to modify as ive got two a joined date and a renewal date, im using access 2007

hello, im very new to access but managing to find what i need with just google, but ive drawn a blank on this one, probably quite easy if you know how, which i dont lol im making a simple membership database, nothing complex just simple details for renewals, quite simply id like a button on a...