I am willing to email you my db. I tried emailing a winzip but it exceeded the limit.
can I email you the winzip, so you can see what I am talking about and post the thread on this website.
Code:
Private Sub List12_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Hymnal ID] = " & Str(Nz(Me![List12], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
Reply With Quote
Access Tables
Table: Name of Hymnal
Fields
Hymnal ID
Name of Hymnal
Table
Hymnal Song Info.
Fields
Name of Song
Hymnal Song
Hymnal Number
Hymnal Name
Composer Name
Arranger Name
Arranger Number
Author Number
Author and Key
Scripture
Key
Tune
Meter
Media Type
The Purpose is I want to have 2 populated list boxes
The other one from Hymnal Song Info. Table, Name of Song Field
One from Name of Hymnal Table, Name of Hymnal Field
Populated Box 1- click on Name of Song
Populated Box 2 click on Name of Hymnal, only displays hymnals from that song.
sql
Code:
Private Sub List12_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Hymnal ID] = " & Str(Nz(Me![List12], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
Reply With Quote
I am trying to import my table the one I created with all of my records
tblehymnalsonginfo excel.
I try copying and pasting my records to tblehymnalsonginfo.
I try deleting the old field I have for idnumber since I have hymnal ID and it says it must be part of the relationships.
There are no relationships in the window and it still won't let me delete the field.
Also then I copy and paste the data from one table to another
Also the listbox name of hymnal is not populating with the subform tblehymnalsonginfosubform.
So everytime I click on the listbox it's not populating right.
Please help I would like to eventually populate the author and key with what Hymnals and songs they are in with 2 list boxes.
Thanks,
can I email you the winzip, so you can see what I am talking about and post the thread on this website.
Code:
Private Sub List12_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Hymnal ID] = " & Str(Nz(Me![List12], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
Reply With Quote
Access Tables
Table: Name of Hymnal
Fields
Hymnal ID
Name of Hymnal
Table
Hymnal Song Info.
Fields
Name of Song
Hymnal Song
Hymnal Number
Hymnal Name
Composer Name
Arranger Name
Arranger Number
Author Number
Author and Key
Scripture
Key
Tune
Meter
Media Type
The Purpose is I want to have 2 populated list boxes
The other one from Hymnal Song Info. Table, Name of Song Field
One from Name of Hymnal Table, Name of Hymnal Field
Populated Box 1- click on Name of Song
Populated Box 2 click on Name of Hymnal, only displays hymnals from that song.
sql
Code:
Private Sub List12_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Hymnal ID] = " & Str(Nz(Me![List12], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
Reply With Quote
I am trying to import my table the one I created with all of my records
tblehymnalsonginfo excel.
I try copying and pasting my records to tblehymnalsonginfo.
I try deleting the old field I have for idnumber since I have hymnal ID and it says it must be part of the relationships.
There are no relationships in the window and it still won't let me delete the field.
Also then I copy and paste the data from one table to another
Also the listbox name of hymnal is not populating with the subform tblehymnalsonginfosubform.
So everytime I click on the listbox it's not populating right.
Please help I would like to eventually populate the author and key with what Hymnals and songs they are in with 2 list boxes.
Thanks,