Hi gang,
I’m hoping for a bit of help please, probably initially in better describing my problem in Access terms rather than solving it but here we go!
I have a table of potential meeting papers, one field is the date of the meeting they will go to.
When that date matches a userform textbox, I’d like to extract other details from the row; title, presenter and place them into a word doc with table fields.
Now for the hard (for me) part. I don’t know how many papers will go to each meeting so presumably I need to loop some code to pull the details if the date matches.
Once I’ve got these It would be great if I could allocate a letter starting at (a) to the title of each paper and thus remove the need for separate table rows in word (and thus a ton of field references) and instead just concatenate all the paper titles and use something like take a new line with vbCrLf or similar for each result within one table field that would read:
a) Title one
b) Title two
c) Title three...
then do the same for the presenters and so on. This would be easy in excel but having recently discovered the joys of access I want to learn more so I’m determined to stick with it!
Hopefully this makes sense, any ideas as to how to approach or questions that would help you translate my rambling in to a sensible access vba type question would be much appreciated.
I’ll probably not be able to share the DB given it’s on a work server but if I can give any additional detail then please ask away!
Many thanks
G
I’m hoping for a bit of help please, probably initially in better describing my problem in Access terms rather than solving it but here we go!
I have a table of potential meeting papers, one field is the date of the meeting they will go to.
When that date matches a userform textbox, I’d like to extract other details from the row; title, presenter and place them into a word doc with table fields.
Now for the hard (for me) part. I don’t know how many papers will go to each meeting so presumably I need to loop some code to pull the details if the date matches.
Once I’ve got these It would be great if I could allocate a letter starting at (a) to the title of each paper and thus remove the need for separate table rows in word (and thus a ton of field references) and instead just concatenate all the paper titles and use something like take a new line with vbCrLf or similar for each result within one table field that would read:
a) Title one
b) Title two
c) Title three...
then do the same for the presenters and so on. This would be easy in excel but having recently discovered the joys of access I want to learn more so I’m determined to stick with it!
Hopefully this makes sense, any ideas as to how to approach or questions that would help you translate my rambling in to a sensible access vba type question would be much appreciated.
I’ll probably not be able to share the DB given it’s on a work server but if I can give any additional detail then please ask away!
Many thanks
G