By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,426 Members | 3,368 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,426 IT Pros & Developers. It's quick & easy.

Can I control open forms of other users?

P: 58
I have a database which manages employee time. I have created a macro which locks records so they can't be edited until I unlock them. This is so when I have accepted all time entries by employees and have submitted the information to Payroll they can't go in and add or edit records and mess me up. I need it to be manual because I submit to Payroll on different days/times.

The lock feature works, but what if an employee is in the Time form WHILE I run my lock macro? I assume it will not automatically refresh their data, so how do I get it to do that? Is there something I can do to refresh the Time form for anyone who is in it at the moment?

Thank you.
Feb 28 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,494
How does this locking work?
Does it rely on you having the database open at the time?
Is it an inbuilt locking feature or something you've designed and implemented yourself?
Be aware, if anyone gets as far as trying to give an answer, they will need to know a bit about what your objects do. You can't simply mention a Time Form and expect anyone to know what you're talking about.
Mar 3 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.