Re: Any alternative to a Data Control?
- From: jake <peppy54@xxxxxxxxx>
- Date: Thu, 8 May 2008 20:25:22 -0700 (PDT)
Thank you both, Ralph and Larry,
Ralph, I tried as you described but could not get to the
"third dialog box" in the Data Wizard where it asks to
select a Binding Type.
It wouldn't allow me past the 2nd dialog box because it
errored out: "unrecognized data format", (it didn't
like the database name - which was correct). I believe
that may be an incompatiblity between an elderly VB 6.0 Pro
and a late version of Access.
Larry, I have absolutely zero experience with DAO coding
and time's getting short on me (I have a very nervous boss).
I don't think I have time to try that plan. I'll try it
later if I cannot solve the problem below.
All is not lost; After playing around a whole work
day, I finally got the Data Control to work. I linked a text
box to the ADO Data Control and it displays the field in the
data table....HOWEVER, I need it to refresh with appending records
(in one instance) and changing fields via barcode scanning (in
anoter instance). It displays the current data upon opening the
datasource but does not refresh with changes. How do I get the
textbox to automatically refresh?
Thanks again, this group has always been a great resource.
On May 8, 1:53 pm, "Larry Linson" <boun...@xxxxxxxxxxxxx> wrote:
Yet another alternative, is to set the appropriate Reference, and use DAO
code to read the record, and VB code to populate the form. For read-only
data, it is likely worth the time and effort to learn and use the Data
Control, unless there is a compelling reason to do otherwise.
The extra work required to deal with database in classic VB is one major
reason that I did my individual, workgroup, and client database applications
in Access... the data-related events in Access make it much easier. DAO, by
the way, is the native language of the Jet (Access) database engine, and
faster when used with Jet (Access) databases, while ADO is intended for
various data sources, thus more complex in general, and slower with Jet
(Access) databases.
Larry Linson
"Ralph" <nt_consultin...@xxxxxxxxx> wrote in message
news:VdidnYLgFuRV4L_VnZ2dnUVZ_j2dnZ2d@xxxxxxxxxxxxxxx
"jake" <pepp...@xxxxxxxxx> wrote in message
news:b50010c2-3f6f-40a5-9376-6ca4785812bc@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
What I need to do is create a display (read only) screen of fields
from records in
an Access table. Every time a record is appended to the table (from a
scale control)
the screen needs to refresh. Is there an alternative to the Data
Control? I'm not very
good with those :)
Thank you for any help,
Lot's of ways.
One way to easily test/compare various methods is to use the "VB Data Form
Wizard". [Projects Add Form ]
On about the third dialog, you will be presented with an opportunity to
select a "Binding Type":
ADO Data Control
ADO Code
Class
Create one Form of each and experiment. You might even discover why you
are
having trouble with the ADODC. I'm not saying that you need to use the
Wizard for your production code, only as a learning tool.
hth
-ralph- Hide quoted text -
- Show quoted text -
.
- Follow-Ups:
- Re: Any alternative to a Data Control?
- From: Ralph
- Re: Any alternative to a Data Control?
- References:
- Any alternative to a Data Control?
- From: jake
- Re: Any alternative to a Data Control?
- From: Ralph
- Re: Any alternative to a Data Control?
- From: Larry Linson
- Any alternative to a Data Control?
- Prev by Date: Re: Any alternative to a Data Control?
- Next by Date: Re: Any alternative to a Data Control?
- Previous by thread: Re: Any alternative to a Data Control?
- Next by thread: Re: Any alternative to a Data Control?
- Index(es):
Relevant Pages
|
