How to load specific records from Bible database
I have the entire Bible stored in an access database. The name of the Bible books are stored in text fields. The chapter numbers of the bible books are stored in integer fields.
My question is how can I load and display specific books/chapters using queries?
Example: How can I load only verses in Genesis, Chapter 5, verse 2 ?
I was attempting to use the data control but could not figure out a solution.
My question is how can I load and display specific books/chapters using queries?
Example: How can I load only verses in Genesis, Chapter 5, verse 2 ?
I was attempting to use the data control but could not figure out a solution.
You will have to provide informaion about database definition (tables, field names) if you want somebody to help you with query
ASKER
The database structure is as follows:
Table = Bible
Field 1 = Books (Text format) 'This is the name of each book of the Bible
Field 2 = Chapters (Integer format) 'This is the Chapter numbers
Field 3 = Verse (Integer format) ' This is the verse numbers
Field 4 = Text (Memo format) 'This stored the text of each verse in the Bible
Table = Bible
Field 1 = Books (Text format) 'This is the name of each book of the Bible
Field 2 = Chapters (Integer format) 'This is the Chapter numbers
Field 3 = Verse (Integer format) ' This is the verse numbers
Field 4 = Text (Memo format) 'This stored the text of each verse in the Bible
You'll need an SQL query something like:
select field4 from bible
where field3 = 2
and field2 = 5
and field1 = "genesis"
select field4 from bible
where field3 = 2
and field2 = 5
and field1 = "genesis"
SELECT * FROM Bible WHERE Books='Genesis' AND Chapters=5 AND Verse=2
ASKER
mladenovicz, how do I use that query in code? Is it useful with the data control?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
mladenovicz, can you help me out one more time. I'm going to give you the points.
I tried the query in the data control and it didn't work.
what should the sDNS connnection string be? The name of my database is "KJV.mdb", and the table is "Bible"
I tried the query in the data control and it didn't work.
what should the sDNS connnection string be? The name of my database is "KJV.mdb", and the table is "Bible"
What is the full path of KJV.mdb file (e.g. "C:\My Documents\KJV.mdb")?
Try sthg like this (put Data control on form and put textbox)
Private Sub Form_Load()
Data1.DatabaseName = "C:\db1.mdb"
Data1.RecordsetType = 1
Data1.RecordSource = "SELECT * FROM Bible"
Data1.RecordSource = "SELECT * FROM Bible WHERE Books='Genesis' AND Chapters=5 AND Verse=2"
Set Text1.DataSource = Data1.Recordset
Text1.DataField = "Text"
End Sub
Private Sub Form_Load()
Data1.DatabaseName = "C:\db1.mdb"
Data1.RecordsetType = 1
Data1.RecordSource = "SELECT * FROM Bible"
Data1.RecordSource = "SELECT * FROM Bible WHERE Books='Genesis' AND Chapters=5 AND Verse=2"
Set Text1.DataSource = Data1.Recordset
Text1.DataField = "Text"
End Sub
You have to replace "C:\db1.mdb" with your dataabse path
ASKER
Hey, I think I may have given too many points for this question. I thought the solution would me much harder than this. Congrats mladenovicz! Thanks for your help as I'm almost done with my Bible project.