Disable standard fields?

  • Thread starter Thread starter Albacrest
  • Start date Start date
A

Albacrest

Is it possible to prevent users from changing standard fields?

Here's what I want to do:

My custom appointment form starts up an application that writes to a SQL
database. When I've stored the record I can track and either undo them or
get my app to replicate the changes dynamically. This is proving rather
difficult to manage and it would be much easier if I could just stop them
doing it after a critical point has been reached. For instance, changing
start time will require constant monitorting and the corresponding event
seems to be fired off repeatedly when this attempted.

I realise I can save my item and close it but I need it to remain open to
allow changes to fields that don't affect my database content. Is there a
way of doing this that anyone knows of?

Jeff Mowatt
 
You could store the values for the fields you want to hold steady to global
variables when the user opens the item, then reset them each one when
Item_PropertyChange or Item_Write fires. A custom form with the controls
disabled wouldn't hurt either.
 
Thanks Sue,

That's more or less what I'm doing and finding it hard to keep up with,
noticing that Property change for [start] can fire as many as 10 times when
I make a single change. Guess I'll have to deal with it then:-(

Regards,

Jeff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fields and custom fields 0
Corrupt form? 5
Importing Text Files Into Access 1
Error when dismissing reminder 1
Outlook Outlook To-Do Bar Not Showing 7-days Appointments 0
Outlook send .ics file with other organizer 0
EntryID question 1
Location field 1

Back
Top