Originally Posted by
shoelesscraig
<snip>Well, from time to time, I need to be able to easily pull up every time I played "Song x" and see the notes from those weekends. Now that I have a LOT of tabs in the spreadsheet, it is fairly difficult to find the instances in which I played "Song x" without doing a "find" and that is not very user friendly. I figured Access is probably a better solution...plus, I'm not sure how many tabs Excel is going to let me add. I figure eventually I'll run out of space...?
I've got a decent amount of experience with Access, and once I get all of my info into it, I know how to create queries to find all records where "Song x" exists, etc.
HERE'S THE QUESTION I CAN'T FIGURE OUT: I know it sounds dumb, but the part that stumps me in Access is...how am I going to print the 1 record for this weekend? I have a form where I enter all info for each weekend, and all of that info goes into a table...separate record for each weekend. Field names in the table are something like "Song1Name", "Song1Tempo", etc....
What is the best way to print THAT 1 RECORD?? Ideally,
Without knowing your table structures, the general idea is to use a PK field to select the song to print.
You report has a query. One of the fields in the table/query is the unique PK field.
So you would have a button that runs code to open/print the report - something like this
Code:
Private Sub Command7_Click()
DoCmd.OpenReport stDocName, acPreview, , "PKField = " & Me.FormControl
End Sub
Where "Me.FormControl" is the control on the form that is the PK field.
Would you post your dB? Only needs a couple of sample records as data.