Updating form data by end user

  • Thread starter Thread starter roger
  • Start date Start date
R

roger

Hello Friends:

I am designing this application called Guest Book
Application for this gallery.

On one of the forms are a couple of date fields which
basically say when the Gallery admission will be free and
this kind of changes every three months...so I want that
the end user who does not know how to use Access is able
to just clich on this form and change the dates...without
opening the form in design mode or even using Access.

He must be able to click on a SC to this form...change the
dates to the new one and the next time the visitor opens
the application...the Guest book application...he must see
the new date. How would I do this?
 
Hi,

We would generally do that with TWO applications sharing the same back
end database.

The first application just display some information in the back end
database, and refresh it through a timer. That application may even run on a
keyboard-less, mouse-less PC (but it is not an obligation, in case the
application has to display a large amount of information, some navigation
may be done, eventually, by the visitor). But the first application do just
that, displaying the information.

The second application, on another PC, that the administration can access,
but not the "visitors", is used to change the information in the back end
database as it fits. The administrator may then change any data, through
this second application. You are free to use any tools at your disposal to
change that information, there.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top