[nreel]

If you haven't used Access, it will be exceptionally hard to explain.

Also, do you have WinWord?

WinWord allows more Replace features that are not possible in Access.

Assuming you do, here's what you will do. Keep in mind this is a way I found to do it. There may be others who are more knowledgeable and can do it easier.

OK...you asked for it...here it is...Good Luck !!

Task=Make all BookIDs 6-Place numbers by adding leading ZEROS. 6-Place Number will allow for BookIDs up through 9,999 (9,999 Discs), which no KJ will ever have in my lifetime.
Reason=So that one may SORT on the BookID Column in the SONGS.MDB and cause all the BookIDs to be in ORDER.

You may want to make a Backup copy of your Songs.MDB so that, if you make any mistake on the one that you are modifying, you can restore with the Backup and start over.

Open WinWord...do not CLOSE
Open Access...do not CLOSE

ACCESS 1 STEPS
.1. Open Songs.mdb
.2. Double Left-Click the SONGS TABLE to OPEN and MAXIMIZE the window.
.3. Left-Click on BookID Column Header to Highlight the BookID Column.
.4. Left-Click the A/Z (with Down Arrow) Icon to SORT ASCENDING.
.5. Left-Click RECORDS.
.6. Left-Click FILTER.
.7. Left-Click ADVANCED FILTER SORT (Field should be filled-in with
.....BookID/Ascending).
.8. In the CRITERIA Field, Enter: Like "???"
.9. Right-Click Mouse anywhere in the solid Grey area.
10. Left-Click APPLY FILTER SORT.
11. Left-Click on BookID Column Header to Highlight the BookID Column.
.....(All Filtered Records should be Highlighted.)
12. Right-Click anywhere in the Highlighted area.
13. Left-Click COPY.

WINWORD STEPS
.1. Left-Click on the WinWord Icon that is located on the TASKBAR.
.....(WinWord should Maximize and show a BLANK DOCUMENT 1 -- We'll use this Doc.)
.2. Right-Click anywhere on the Blank Document.
.3. Left-Click PASTE.
.4. Left-Click BookID, located at the TOP of the single column Table, to
.....Highlight the Table with the words BookID in it. To HIGHLIGHT this table,
.....you must place the CURSOR in the LEFT MARGIN just to the LEFT of the
.....TABLE that contains the word BookID and Left-Click.
.5. Right-Click in the HIGHLIGHTED area.
.6. Left-Click CUT.
.7. Left-Click the COLUMN of Tables to HIGHLIGHT.
.8. Left-Click EDIT that is located on the TOP BAR.
.9. Left-Click REPLACE
10. Left-Click MORE
11. Left-Click USE WILD CARDS
12. Enter in the FIND WHAT Field: <(1)
13. Enter in the REPLACE WITH Field: 0001
14. Click REPLACE ALL -- If asked if you want to search the remaining Doc.
.....Answer NO.
15. Repeat steps 12-14 but change FIELDS to all single numbers from 2 thru 9
......IMPORTANT - The FIND Field MUST MATCH THE REPLACE Field
......DO NOT GET THIS WRONG !!
......... ex. <(2) and 0002
...............<(9) and 0009 and every number between.
16. Left-Click anywhere in the WHITE area of the Document.
.....(Column should still be Highlighted)
17. Right-Click in the Highlighted area.
18. Left-Click CUT.

ACCESS 2 STEPS
.1. Left-Click MSAccess Icon on TASKBAR
.2. Left Click SONGS:TABLE (BookID should still be Highlighted)
.3. Right-Click anywhere in the HIGHLIGHTED area.
.4. Left-Click PASTE
.5. Left-Click YES to accept the changes.


Repeat process ONCE if you have less than 100 BookIDs and TWICE if you have more than 100 BookIDs following the procedure below.

If ONCE, you will add ONE additional QUESTION MARK (?) in STEP 8 of ACCESS 1 STEPS.
.......(In the CRITERIA Field, Enter: Like "????")
A N D,
You will DECREASE the number of ZEROS in STEP 13 of WINWORD STEPS by ONE.
.......(Enter in the REPLACE WITH Field: 001)

If TWICE, first complete the one above, then, continue with this.
Add TWO additional QUESTION MARKS (??) in STEP 8 of ACCESS 1 STEPS.
.......(In the CRITERIA Field, Enter: Like "?????")
A N D,
You will DECREASE the number of ZEROS in STEP 13 of WINWORD STEPS by TWO.
.......(Enter in the REPLACE WITH Field: 01)


Hopefully, these steps will be easy to follow.

Norm