dataset and text boxes on same form.

  • Thread starter Thread starter Tony Roake
  • Start date Start date
T

Tony Roake

An immediate problem which I have with Access 97 is to
place a dataset type display and individual text boxes to
read from the same datasource (table) on a single form.

So far my various attempts have not been successful.

Can anyone help with this please?

Any assistance much appreciated.

Many Thanks
 
If by 'dataset' you mean a grid-like display, I'd suggest a subform in
datasheet view.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
An immediate problem which I have with Access 97 is to
place a dataset type display and individual text boxes to
read from the same datasource (table) on a single form.

So far my various attempts have not been successful.
Click to expand...

I presume you mean a "datasheet"? A dataset is a programming object,
not a display tool!

You may be able to use a Form and a Subform based on the same table;
but this may run into editing problems if you attempt to edit the same
record on both forms simultaneously.

Post some more details please! Why is this display necessary, and what
are you trying to accomplish with it?

John W. Vinson[MVP]
 
Ok. Thanks for your response.

The background to this is as follows.

There is an existing application, written by me in Visual
Dbase some years ago, which stores the various
combinations of company trademarks and product ID's.

This application has a couple of forms which show a grid
display of the datasource (table) together with the
contents of the current record in a textbox display

This textbox display includes the contents of a memo field
containing remarks and comments.

It is now necessary to do some enhancements to this
application and since our parent company nominates Access
as its chosen database system I have to try to produce an
Access version.

(Another reason for using Access is that all the
components are encapsulated in one mdb file which makes it
easy to e-mail updates world-wide: not very easy to do
with the VDB version).

I would like to retain this dual display feature if
possible simply because users are used to it and prefer it.
 
Ok. Thanks for your response.

The background to this is as follows.

There is an existing application, written by me in Visual
Dbase some years ago, which stores the various
combinations of company trademarks and product ID's.
Click to expand...

Aha. Yes, that explains some of my confusion - the jargon is
different!
This application has a couple of forms which show a grid
display of the datasource (table) together with the
contents of the current record in a textbox display
....
I would like to retain this dual display feature if
possible simply because users are used to it and prefer it.
Click to expand...

A Subform will perhaps be useful here; if you make the datasheet or
(better, because you have more control) Continuous subform read-only
by setting its Allow Edits property to False, you'll be able to view
all the records on the subform, but still be able to edit a selected
record on the mainform.

John W. Vinson[MVP]
 
Back
Top