Change data on an Access Screen.

  • 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?
 
roger said:
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?
Click to expand...

I don't know what you mean by "SC". However, the date information
you're talking about is data, and since it can be changed (however
infrequently) it shouldn't be stored in the design of the form, but
rather in a table. The table may possibly have only one record, with
fields for these dates and and maybe other information such as the
gallery name (which might come in handy to have in a table if you sell
this database to another gallery).

Suppose you create this table and name it "Profile", with the date/time
fields "FreeAdmissionStart" and "FreeAdmissionEnd". Then you could have
text boxes on your form that use DLookup() expressions to get the
appropriate dates from the Profile table. Their ControlSource
properties might be like this:

=DLookup("FreeAdmissionStart", "Profile")

and

=DLookup("FreeAdmissionEnd", "Profile")

You could set up a Click event procedure on these text boxes that would
open a form based on the Profile table, allowing the user to edit the
dates directly. After that form closes, you would tell Access to
recalculate the text boxes, and they would show the new dates
immediately.
 
Back
Top