I have a database which contains personal information of about 1000 students and their classes. I want to transfer the student information on a class by class basis to dBase III+ files (to be used by an ancient DOS problem), each dBase III+ file contains only student info for each class. If I have 30 classes, then I should have 30 dBase III+ files. Transferring the info to dBase III+ files is no problem. What I am not sure is how can I loop through all the 30 classes so that I can produce 30 dBase III+ files? The class field is not indexed. My approach is to store all the distinct names of 30 classes into an array and then ask the Access program to loop through the array element by element, but so far without success. The failure is due to my inability to get the 30 distinct class names. Can anyone please help.
![]() |
There are isolated problems with current patches, but they are well-known and documented on this site. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
List distinct field values (A2K SP3)
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » List distinct field values (A2K SP3)
- This topic has 4 replies, 2 voices, and was last updated 22 years ago.
Viewing 0 reply threadsAuthorReplies-
WSHansV
AskWoody Lounger -
WSlesoch
AskWoody LoungerMarch 20, 2003 at 8:17 am #662563Thanks for your response, Hans.
What I want is to make the process automatic. Say I have classes named 2A, 2B, 2C, and 2D, which I may not know beforehand. I want by just supplying a class name “2”, and the program will get the distinct class names 2A, 2B, 2C and 2D, and then for each distinct class, save the info into files 2A.dbf, 2B.dbf, 2C.dbf and 2D.dbf.
I am really dumb. I don’t see how the SQL statement “SELECT DISTINCT Class_Name FROM tblClass_Info” will help. Apparently I need to know the Class_Name, which I may not know, as I only know their names start with “2”. My post must have been unclear. Can you elaborate it a little, please?
-
WSHansV
AskWoody LoungerMarch 20, 2003 at 8:51 am #662565Here is a code template. Of course, you must substitute the appropriate field and table names.
Dim strChar As String Dim strClass As String Dim strFile As String Dim dbs As DAO.Database Dim rstClasses As DAO.Recordset ' Ask user for first character strChar = InputBox("Enter first character, e.g. 2") If strChar = "" Then Exit Sub ' Get class names Set dbs = CurrentDb Set rstClasses = dbs.OpenRecordset( _ "SELECT DISTINCT Class_Name FROM tblClass_Info WHERE Class_Name Like '" & _ strChar & "*'") ' Loop through recordset Do While Not rstClasses.EOF strClass = rstClasses!Class_Name strFile = strClass & ".dbf" ' Now, you have the name of the class (e.g. 2A) in strClass ' and the file name (2A.dbf) in strFile ' Insert code to export data to strFile here ... ' Move to next class rstClasses.MoveNext Loop ' Clean up rstClasses.Close Set rstClasses = Nothing Set dbs = Nothing
This code will not work in this form, you will have to adapt it to your situation. Post back if you need more help.
-
WSlesoch
AskWoody Lounger
-
-
-
Viewing 0 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
simple general stupid question
by
WSaltamirano
2 minutes ago -
Automatic Toggle code for pages and bookmarks for Table of Content (Awaiting moderation)
by
switchtolinux
45 minutes ago -
April 2025 Office non-Security updates
by
PKCano
7 hours, 25 minutes ago -
Microsoft wants to hear from you
by
Will Fastie
8 hours, 37 minutes ago -
Windows 11 Insider Preview Build 22635.5160 (23H2) released to BETA
by
joep517
10 hours, 58 minutes ago -
Europe Seeks Alternatives to U.S. Cloud Providers
by
Alex5723
16 hours, 29 minutes ago -
Test post
by
Susan Bradley
18 hours, 42 minutes ago -
Used Systems to delete Temp files Gone WRONG what does this mean?
by
Deo
20 hours, 24 minutes ago -
SSD shuts down on its own
by
CWBillow
11 hours, 48 minutes ago -
OneDrive File Sharing Changes
by
David Clark
1 day, 4 hours ago -
OneDrive File Sharing Changes
by
David Clark
1 day, 6 hours ago -
Win 10 Pro 22H2 to Win 11 Pro 23H2 Conversion Guide
by
doneager
6 hours, 34 minutes ago -
Today is world backup day
by
Alex5723
22 hours, 8 minutes ago -
Windows .exe on Mint
by
Slowpoke47
1 day, 8 hours ago -
Reviewing your licensing options
by
Susan Bradley
17 hours, 49 minutes ago -
Apple has been analyzing your photos since September 2024
by
B. Livingston
3 hours, 21 minutes ago -
What Windows 11 24H2 offers beyond bugs
by
Lance Whitney
11 hours, 8 minutes ago -
Making sense of Settings in Windows 11
by
Simon Bisson
31 minutes ago -
Windows 11 pro fails to log in after upgrading Win 10 pro to Win 11 pro 24h2
by
ben_sitaud
1 day, 4 hours ago -
23H2 / 24H2 / Local v. Microsoft Account.
by
CWBillow
1 day, 2 hours ago -
YouTube Ad Blocker Blocker
by
bbearren
1 day, 2 hours ago -
Obscure historical facts about Windows
by
Cybertooth
1 day, 3 hours ago -
Microsoft Backup
by
Linda2019
19 hours, 40 minutes ago -
What is the best notepad++ version for W7?
by
Picky
1 day, 3 hours ago -
What are right steps to move MS 365 Office+OneDrive files from PC to iMac?
by
glnz
2 days, 12 hours ago -
How to move existing MS 365 Office with OneDrive files from PC to new iMac
by
glnz
2 days, 12 hours ago -
How to move MS 365 files (some on OneDrive) from PC to iMac
by
glnz
3 days, 7 hours ago -
Microsoft adding Quick Machine Recovery to Windows 11
by
Alex5723
3 days, 7 hours ago -
Microsoft vs Passwords
by
Alex5723
15 hours, 33 minutes ago -
Windows 11 Insider Preview build 26200.5516 released to DEV
by
joep517
3 days, 11 hours ago
Recent blog posts
Key Links
S | M | T | W | T | F | S |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | ||
6 | 7 | 8 | 9 | 10 | 11 | 12 |
13 | 14 | 15 | 16 | 17 | 18 | 19 |
20 | 21 | 22 | 23 | 24 | 25 | 26 |
27 | 28 | 29 | 30 |
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.