Can I automate the marking of a Works database record with VB script?

I still prefer to use Microsoft Works databases for some applications, while Microsoft Office Access is used for other purposes.  I wonder if there is a way to use a VB Script to mark records in a Works database, if the value in a specified field meets certain criteria?
If so, can you provide code to mark a record if the value in a field named "Days to Arrival" is <60, and unmark it if the value in that field is "N/A"?
Who is Participating?
aikimarkConnect With a Mentor Commented:
I do not see a path to your solution without you switching to Access as your database format.
please post the database
ddantesAuthor Commented:
Thank you for your comment.  The database which I am working with contains information about our clients which I cannot post, nor can I upload a blank database because the file extension is not accepted by Experts Exchange.  So I posted a blank database at    I hope this will be helpful.   Marking a record consists of placing a tick in the left-hand column.
ddantesAuthor Commented:
OK, thank you for checking that.   Right now, it isn't worth switching to Access to gain that feature.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.