Re: Index number not working properly with variable

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

The problem with bound forms is the fact that one has to know rather if they
are in Add, Edit, or Inquire mode (Inquire mode though not so bad given you
can use an unbound control for the ID field to use for inquiring purposes)
before putting any data into the form. A pretty good majority of the time,
this wouldn't be an issue, but there are those rare exceptions. As with any
of my other programming work, not only am I after accurate data on a timely
basis, but also after user friendliness, especially for the group of users
that I have to satisfy. With the various things I have learned along the
way, I attempt to implement things that helps all 3 major groups of people
involved with the database (Administrators/DB Programmers, Data Entry
personnel, and Data Users), which I have been in all 3 arenas, as each group
has their own set of issues. In the past, I would have separated DB
programmers from administrators, but learned from on here that many others
prefer to have those 2 disciplines grouped together, given the programmer
has to take into account of the different things that the administrator
would need to have in place to do their job, and how much of an overlap
there is.

One such case, how do you handle a situation when a user calls up one record
to be able to spin off from that record to create a new record with minor
changes. Just by inquiring, the program itself wouldn't know if the user
intends on editing that record (if allowed to), or using that data to create
a new record (if allowed to). For this sort of reason, I and many other
users prefer to have the edit mode choice to be *AFTER* dealing with the
data rather than having the program guess which mode to be in *PRIOR TO*
dealing with the data as a requirement of Access with bound forms. That's
also why the forms that are not switchboards are setup to have 1 status
label and 6 standardized command buttons (Inquire, Add, Edit/Update, Delete,
Reset, Exit) in the footer section of the form.

Yes, I realize working with unbound forms/controls requires more coding and
work, but the flexibility is also greater. That's just one reason why I
standardize certain things.

--
Thanks,

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
"Marshall Barton" <marshbarton@xxxxxxxxxx> wrote in message
news:g2csf45sp7qo0uho84e8625uehbt559suf@xxxxxxxxxx
Ronald R. Dodge, Jr. wrote:

Guess I stand corrected about the improvement aspect of DAO coding.

As for the bound forms, one of the problems with bound forms, it requires
knowing which edit mode one will be going into prior to even starting on
the
form. Generally, a user will know that, but that is not *ALWAYS* the
case.
As with anything I do, unless I have no realistic choice, I make every
attempt to avoid absolutes given absolutes gets one into trouble so much
easier than most other things.


What do you mean by "edit mode"? If it's the options that
can be specified in the OpenForm method's DataMode argument,
then those same options can be set in the form itself using
the AllowEdits, AllowAdditions and AllowDeletions
properties. If those are too heavy handed for what you are
doing, then you can also use the Locked property on
individual controls.

IME, I have only found one case where I had to use unbound
data controls (instead of a subform) and that was because I
needed to allow users to specify aggregate values that code
divided across multiple records in a child table.

--
Marsh
MVP [MS Access]


.

Relevant Pages

  • Re: Index number not working properly with variable
    ... are in Add, Edit, or Inquire mode (Inquire mode though not so bad given you ... can use an unbound control for the ID field to use for inquiring purposes) ...
    (microsoft.public.access.modulesdaovba)
  • Re: Why, oh why, _why?
    ... notable is that someone with the power needs to edit ruby-lang.org to ... while I imagine someone may have his "freaky freaky sandbox" ... programmers, and served as an amazing introduction to Ruby and programming ...
    (comp.lang.ruby)
  • Re: Including Save As, Copy, Edit, etc into Program
    ... This board is a peer to peer board, ... programmers who don't have much time so they usually respond to specific ... problem requests, and leave the tutoring up to Google, and help sites. ... When I said Edit I meant Edit Menu, ...
    (microsoft.public.vb.general.discussion)
  • Re: Enhanced COPY CON
    ... two 720KB floppy drives and monocrome CGA screen. ... Even a standard editor is slow. ... programmers - it was written in *assembly*. ...
    (comp.os.msdos.programmer)
  • Re: as the case may be
    ... ON' if you choose to edit a member that has no lower case in it. ... other hand it does 'CAPS OFF' if it does have lower case. ... Programmers, of course, a breed unto ourselves! ...
    (comp.lang.cobol)