Recent content by BobLincs

thanks again.

Have looked at delete query but it specifically states that it can't be be used to delete contents of individual columns which is what I am looking for. My idea is some sort of loop that will step through each record and empty specified fields. I know I could do it the long way with a Next...

Thanks, I'll try that.

I have produced a dbase for my bowls club. At the end of the season some contents of tables will need to be emptied ready for next season. Can anyone provide me with the syntax to attach to a button on a form, that will loop through the records and delete the contents from various fields...

Thank you for taking the time to help.

Thank you. I'll give that a try.

Some time ago I saved an early version of my club db to CD to trial it on the club's PC. I only tried it by running it from the disc and found that it was READ ONLY. Will it automatically become fully usable when it is installed on the PC. Your help appreciated.

I am developing a db for a club I belong to and at the end of a season some content needs to be deleted. Can anyone give the syntax to attach to button that will step through the records and delete the content of a field or fields please.

Thanks, that's a great help. Bob

Is it possible to move a record from one table to another without physically copying, pasting and cutting. I.e. we have two membership lists. One for current members one for past members. (It's a history thing) If I set a current member's status to lapsed, is there a way that the record can...

I would just like to say thank you to all who replied and offered/provided help. I personally took no offence from your email Bob. Thanks for button suggestion Smig I hadn't thought of that, but I see less chance of erroroneous entry with the check box. And much to my surprise I tried...

Sorry, I was a bit dim there, for some reason it just didn't register as a link. I've since checked the link and realise how easy it could have been. Thanks

Many thanks for taking the time to suggest a remedy John. I hadn't got a clue regarding where I should put the code Boblarson but your comment set me searching. I found the correct destination by luck, entered your instruction John and Hey Presto, it worked. Thankyou both for taking the...

Thanks again but it's still no go. Must be me. My date field is called renew. The data properties for the field show the control as renew. I have substituted renew for SubDate in your expression and put it in the on click box for the checkbox event properties but when trying it I get a...

Thanks for try but all I get is a message saying it doesn't recognise the macro. I am assuming that I replace Me.SubDate with my tablename.fieldname. As the checkbox didn't work I've added a yes/no field to the table/form but the result is the same.