Recordset info

[5p1der]

Thanks in advance!

In an Access 2k mdb front end with a sql server backend...
I am trying to learn to use recordsets, so where can i find information
and examples of recordset properties (Edit, AddNew, MoveNext, Filter,
etc.)? Questions I have would include , but far from limited to, do i
always have to use rst.Update and rst.Close when finished working the
the recordset?

Currently I am trying to accomplish the following:

I have a table that has an alphanumeric field where only a portion of
the field needs to be changed (From <oldvalue>_R1 to <newvalue>_R1).
The table lists device names for a site, so I would need to filter the
table to a result set that may include several distinct device names
(one record for each device). It is worthy to note that in some cases
there may not be a record. I then need to edit those names as indicated
above.

[MGFoster]

5p****@centurytel.net wrote:

Thanks in advance!

In an Access 2k mdb front end with a sql server backend...
I am trying to learn to use recordsets, so where can i find information
and examples of recordset properties (Edit, AddNew, MoveNext, Filter,
etc.)? Questions I have would include , but far from limited to, do i
always have to use rst.Update and rst.Close when finished working the
the recordset?

Currently I am trying to accomplish the following:

I have a table that has an alphanumeric field where only a portion of
the field needs to be changed (From <oldvalue>_R1 to <newvalue>_R1).
The table lists device names for a site, so I would need to filter the
table to a result set that may include several distinct device names
(one record for each device). It is worthy to note that in some cases
there may not be a record. I then need to edit those names as indicated
above.

Read the Access VBA Help articles "Recordset Object" and look at the
Methods articles.

Having 2, or more, data items in one cell is bad database design (it
violates the First Normal Form [1NF]). You should break out the
separate data items into 2 columns: <value> in one column, 'R1' (etc.)
in another.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

[5p1der]

Using the Answer Wizard in VB Help (no, not Access Help), i do not have
a topic "Recordset Object"; when i enter something like "MoveNext" or
"Edit", the topics are listed, but no information (The page is "Visual
Basic 'Welcome to Visual Basic documentation'"); so maybe I don't have
the entire help file or something. Under Visual Basic Language
Reference/Objects, there is no 'recordset'. I know i do not have a
developer's edition. I'm sure I have the reference, since i use a
recordset object in one funtion to write data to an excel spreadsheet.
So I would still like to know where to find some info and examples.
(Or, is there a secret to finding "recordset object method", etc. at
the MS KB?)

When i started this thing, i had no knowledge of databases of any kind.
But now that you point it out, I see your point about seperate data
items. I did not view them as seperate data items--chalk to
inexperience of a self-teaching part-timer.

[MGFoster]

5p****@centurytel.net wrote:

Using the Answer Wizard in VB Help (no, not Access Help), i do not have
a topic "Recordset Object"; when i enter something like "MoveNext" or
"Edit", the topics are listed, but no information (The page is "Visual
Basic 'Welcome to Visual Basic documentation'"); so maybe I don't have
the entire help file or something. Under Visual Basic Language
Reference/Objects, there is no 'recordset'. I know i do not have a
developer's edition. I'm sure I have the reference, since i use a
recordset object in one funtion to write data to an excel spreadsheet.
So I would still like to know where to find some info and examples.
(Or, is there a secret to finding "recordset object method", etc. at
the MS KB?)

When i started this thing, i had no knowledge of databases of any kind.
But now that you point it out, I see your point about seperate data
items. I did not view them as seperate data items--chalk to
inexperience of a self-teaching part-timer.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You can find info on a VBA-related command, object, etc. by opening the
Debug window (ctrl-G) and typing in the thing you want info on. Place
the cursor over what you just typed & hit the F1 key. In your case,
type Recordset in the Debug window.

If you do the above for "Recordset," you will be prompted for the
library in which the object resides. If you are using DAO double-click
on the Access library line. If you are using ADO double-click on the
ADODB library line. The Help article will appear (if it is installed).

A pretty good book on database design is _Database Design for Mere
Mortals_ (2nd edition) by Hernandez. He uses some Access dbs to explain
design ideas.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQh97/oechKqOuFEgEQItCQCg82tZadkpH68PomfRj4y3+kKL14MAn1k R
HoKiHQHr753101Kwg66M8RuY
=jzos
-----END PGP SIGNATURE-----