User input forms

  • Thread starter Thread starter Malcolm
  • Start date Start date
M

Malcolm

Hi all

I am trying to design an interface, using forms in Access
2000 for unit trainers, with limited computer knowledge (I
am a relatively intermediate user of Access 2000 myself).

The first task is to allow them to define a new process in
an existing table, with minimal information of:

Code
Area Name
Title
Description.

I have created a pop-up form for entry of new 'process'
records and have set "Data Entry" to "Yes" to allow new
blank records. The database rules/settings work fine.
However, I have a "Close Window" command button and so if
an "illegal" entry is made and then the close button is
pressed, the inaccurate record is not saved, but also no
error messages are output and so there is no opportunity
to change the entry. A non-user could also believe that
the entry had been saved.

Can anyone suggest the best way to "force" the save, and
hence the error message for invalid entries.

Secondly I would like to know if it is possible to
automatically create a new table, with the above "Code" as
its name, by copying an existing table (template with
structure only) to this name, and further if a 'user input
form' can be created for this table, again based on an
existing form.

The data input to the created table is to be used by third
party software, using ODBC.

I hope this is understandable, and thanks in advance for
any help you can provide.
 
If you have each textbox validation set a user can not even exit the textbox
until the data is correct. If validation can't be set at the textbox level
due to complexity, then you can write more advance code in one of the events
that will 'cancel the close event' and then send the user to the offending
field by using the Set Focus event.

Unfortunately, I don't have any prewritten code that I can give you on this,
so I can only pass on the concept. Perhaps an MVP has some code readily
available that you can use.
 
Back
Top