Microsoft Access Macro - is there a way to copy records with a macro?
I have written a macro in Microst Access that runs a make-table query, opens the table and selects all the records. (I don't know VBA so I have to use macros).
Then I copy all the records and paste them into Word and run a macro I've created there.
Is there a way to add a command of some sort to copy selected records?
If so, here would be the end result that I'm trying to accomplish.
By adding this to a menu item, the End User would simply click the Run Whatever Report button and it would go through all these steps:
- Run a make-table query.
- Open the resulting table.
- Select all records and fields.
- Copy all selection.
- Open Word.
- End User clicks previously created macro button.
- Task completed.
My End Users are at the very basic level and are menu-button driven. If they have to manually select the records, I will (seriously) have to write a manual on "How To". Therefore the reason for my desired end result.
Thanks for any help or suggestions!
microsoft-word macros microsoft-access
edited Aug 26 '13 at 18:40
Shekhar
4,52032945
asked Jan 13 '12 at 22:34
SherrySherry
111
add a comment |
I have written a macro in Microst Access that runs a make-table query, opens the table and selects all the records. (I don't know VBA so I have to use macros).
Then I copy all the records and paste them into Word and run a macro I've created there.
Is there a way to add a command of some sort to copy selected records?
If so, here would be the end result that I'm trying to accomplish.
By adding this to a menu item, the End User would simply click the Run Whatever Report button and it would go through all these steps:
- Run a make-table query.
- Open the resulting table.
- Select all records and fields.
- Copy all selection.
- Open Word.
- End User clicks previously created macro button.
- Task completed.
My End Users are at the very basic level and are menu-button driven. If they have to manually select the records, I will (seriously) have to write a manual on "How To". Therefore the reason for my desired end result.
Thanks for any help or suggestions!
microsoft-word macros microsoft-access
edited Aug 26 '13 at 18:40
Shekhar
4,52032945
asked Jan 13 '12 at 22:34
SherrySherry
111
add a comment |
I have written a macro in Microst Access that runs a make-table query, opens the table and selects all the records. (I don't know VBA so I have to use macros).
Then I copy all the records and paste them into Word and run a macro I've created there.
Is there a way to add a command of some sort to copy selected records?
If so, here would be the end result that I'm trying to accomplish.
By adding this to a menu item, the End User would simply click the Run Whatever Report button and it would go through all these steps:
- Run a make-table query.
- Open the resulting table.
- Select all records and fields.
- Copy all selection.
- Open Word.
- End User clicks previously created macro button.
- Task completed.
My End Users are at the very basic level and are menu-button driven. If they have to manually select the records, I will (seriously) have to write a manual on "How To". Therefore the reason for my desired end result.
Thanks for any help or suggestions!
microsoft-word macros microsoft-access
edited Aug 26 '13 at 18:40
Shekhar
4,52032945
asked Jan 13 '12 at 22:34
SherrySherry
111
I have written a macro in Microst Access that runs a make-table query, opens the table and selects all the records. (I don't know VBA so I have to use macros).
Then I copy all the records and paste them into Word and run a macro I've created there.
Is there a way to add a command of some sort to copy selected records?
If so, here would be the end result that I'm trying to accomplish.
By adding this to a menu item, the End User would simply click the Run Whatever Report button and it would go through all these steps:
- Run a make-table query.
- Open the resulting table.
- Select all records and fields.
- Copy all selection.
- Open Word.
- End User clicks previously created macro button.
- Task completed.
My End Users are at the very basic level and are menu-button driven. If they have to manually select the records, I will (seriously) have to write a manual on "How To". Therefore the reason for my desired end result.
Thanks for any help or suggestions!
microsoft-word macros microsoft-access
microsoft-word macros microsoft-access
edited Aug 26 '13 at 18:40
Shekhar
4,52032945
asked Jan 13 '12 at 22:34
SherrySherry
111
edited Aug 26 '13 at 18:40
Shekhar
4,52032945
asked Jan 13 '12 at 22:34
SherrySherry
111
edited Aug 26 '13 at 18:40
Shekhar
4,52032945
edited Aug 26 '13 at 18:40
Shekhar
4,52032945
edited Aug 26 '13 at 18:40
Shekhar
4,52032945
4,52032945
asked Jan 13 '12 at 22:34
SherrySherry
111
asked Jan 13 '12 at 22:34
SherrySherry
111
asked Jan 13 '12 at 22:34
SherrySherry
111
111
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Why not just create a report using the Access Report Designer? It's not that hard and doesn't require knowing VBA. There are report wizards for basic designs. You already have your "make table" query that creates the data to be reported. Just choose it in the report wizard and in a few simple steps you will have a basic report. Once the report is designed and saved you can create a simple one-step macro to open that report and put that macro on a menu button.
You can then use the Office Links button on the toolbar to export the report to Word, if that's still necessary.
If you want to learn more about creating reports starting with using the wizard, here's a very clear video tutorial on YouTube: http://bit.ly/xQBzjp
answered Jan 14 '12 at 0:37
Dave BeckerDave Becker
2,5351315
I can create a report but my end user needs this in MS Word format. Basically, they need a text version of my FN and LN field to go from being columns to end up like this in Word: John DoeJim RupertLeslie Lester*Mandy Manilow I have solved this problem, but thanks for the suggestion!
– Sherry
Jan 17 '12 at 23:12
add a comment |
http://www.vbforums.com/showthread.php?t=376693 (interesting info that may be close to what you are looking for).
If you must use a macro, this site looked promising.
edited Jan 25 '12 at 17:54
soandos
20.2k2892131
answered Jan 13 '12 at 23:24
JeffJeff
174213
Could you expand your answer? Its a bit unclear exactly what your suggesting to do.
– Simon Sheehan
Jan 14 '12 at 20:36
Thanks for your response. I really do need to delve into the world of VBA. Time seems to be the biggest factor for me. What I know about Access I've had to teach myself through trial and error (no classes, no books...sigh). My biggest problem on this one is the deadline and I don't have time to learn VBA in time to meet the deadline. :-( Thanks for the links! Will definitely look into them and hopefully be able to put them to use!
– Sherry
Jan 17 '12 at 23:10
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f378186%2fmicrosoft-access-macro-is-there-a-way-to-copy-records-with-a-macro%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Why not just create a report using the Access Report Designer? It's not that hard and doesn't require knowing VBA. There are report wizards for basic designs. You already have your "make table" query that creates the data to be reported. Just choose it in the report wizard and in a few simple steps you will have a basic report. Once the report is designed and saved you can create a simple one-step macro to open that report and put that macro on a menu button.
You can then use the Office Links button on the toolbar to export the report to Word, if that's still necessary.
If you want to learn more about creating reports starting with using the wizard, here's a very clear video tutorial on YouTube: http://bit.ly/xQBzjp
answered Jan 14 '12 at 0:37
Dave BeckerDave Becker
2,5351315
I can create a report but my end user needs this in MS Word format. Basically, they need a text version of my FN and LN field to go from being columns to end up like this in Word: John DoeJim RupertLeslie Lester*Mandy Manilow I have solved this problem, but thanks for the suggestion!
– Sherry
Jan 17 '12 at 23:12
add a comment |
Why not just create a report using the Access Report Designer? It's not that hard and doesn't require knowing VBA. There are report wizards for basic designs. You already have your "make table" query that creates the data to be reported. Just choose it in the report wizard and in a few simple steps you will have a basic report. Once the report is designed and saved you can create a simple one-step macro to open that report and put that macro on a menu button.
You can then use the Office Links button on the toolbar to export the report to Word, if that's still necessary.
If you want to learn more about creating reports starting with using the wizard, here's a very clear video tutorial on YouTube: http://bit.ly/xQBzjp
answered Jan 14 '12 at 0:37
Dave BeckerDave Becker
2,5351315
I can create a report but my end user needs this in MS Word format. Basically, they need a text version of my FN and LN field to go from being columns to end up like this in Word: John DoeJim RupertLeslie Lester*Mandy Manilow I have solved this problem, but thanks for the suggestion!
– Sherry
Jan 17 '12 at 23:12
add a comment |
Why not just create a report using the Access Report Designer? It's not that hard and doesn't require knowing VBA. There are report wizards for basic designs. You already have your "make table" query that creates the data to be reported. Just choose it in the report wizard and in a few simple steps you will have a basic report. Once the report is designed and saved you can create a simple one-step macro to open that report and put that macro on a menu button.
You can then use the Office Links button on the toolbar to export the report to Word, if that's still necessary.
If you want to learn more about creating reports starting with using the wizard, here's a very clear video tutorial on YouTube: http://bit.ly/xQBzjp
answered Jan 14 '12 at 0:37
Dave BeckerDave Becker
2,5351315
Why not just create a report using the Access Report Designer? It's not that hard and doesn't require knowing VBA. There are report wizards for basic designs. You already have your "make table" query that creates the data to be reported. Just choose it in the report wizard and in a few simple steps you will have a basic report. Once the report is designed and saved you can create a simple one-step macro to open that report and put that macro on a menu button.
You can then use the Office Links button on the toolbar to export the report to Word, if that's still necessary.
If you want to learn more about creating reports starting with using the wizard, here's a very clear video tutorial on YouTube: http://bit.ly/xQBzjp
answered Jan 14 '12 at 0:37
Dave BeckerDave Becker
2,5351315
answered Jan 14 '12 at 0:37
Dave BeckerDave Becker
2,5351315
answered Jan 14 '12 at 0:37
Dave BeckerDave Becker
2,5351315
answered Jan 14 '12 at 0:37
Dave BeckerDave Becker
2,5351315
2,5351315
I can create a report but my end user needs this in MS Word format. Basically, they need a text version of my FN and LN field to go from being columns to end up like this in Word: John DoeJim RupertLeslie Lester*Mandy Manilow I have solved this problem, but thanks for the suggestion!
– Sherry
Jan 17 '12 at 23:12
add a comment |
I can create a report but my end user needs this in MS Word format. Basically, they need a text version of my FN and LN field to go from being columns to end up like this in Word: John DoeJim RupertLeslie Lester*Mandy Manilow I have solved this problem, but thanks for the suggestion!
– Sherry
Jan 17 '12 at 23:12
I can create a report but my end user needs this in MS Word format. Basically, they need a text version of my FN and LN field to go from being columns to end up like this in Word: John DoeJim RupertLeslie Lester*Mandy Manilow I have solved this problem, but thanks for the suggestion!
– Sherry
Jan 17 '12 at 23:12
I can create a report but my end user needs this in MS Word format. Basically, they need a text version of my FN and LN field to go from being columns to end up like this in Word: John DoeJim RupertLeslie Lester*Mandy Manilow I have solved this problem, but thanks for the suggestion!
– Sherry
Jan 17 '12 at 23:12
add a comment |
http://www.vbforums.com/showthread.php?t=376693 (interesting info that may be close to what you are looking for).
If you must use a macro, this site looked promising.
edited Jan 25 '12 at 17:54
soandos
20.2k2892131
answered Jan 13 '12 at 23:24
JeffJeff
174213
Could you expand your answer? Its a bit unclear exactly what your suggesting to do.
– Simon Sheehan
Jan 14 '12 at 20:36
Thanks for your response. I really do need to delve into the world of VBA. Time seems to be the biggest factor for me. What I know about Access I've had to teach myself through trial and error (no classes, no books...sigh). My biggest problem on this one is the deadline and I don't have time to learn VBA in time to meet the deadline. :-( Thanks for the links! Will definitely look into them and hopefully be able to put them to use!
– Sherry
Jan 17 '12 at 23:10
add a comment |
http://www.vbforums.com/showthread.php?t=376693 (interesting info that may be close to what you are looking for).
If you must use a macro, this site looked promising.
edited Jan 25 '12 at 17:54
soandos
20.2k2892131
answered Jan 13 '12 at 23:24
JeffJeff
174213
Could you expand your answer? Its a bit unclear exactly what your suggesting to do.
– Simon Sheehan
Jan 14 '12 at 20:36
Thanks for your response. I really do need to delve into the world of VBA. Time seems to be the biggest factor for me. What I know about Access I've had to teach myself through trial and error (no classes, no books...sigh). My biggest problem on this one is the deadline and I don't have time to learn VBA in time to meet the deadline. :-( Thanks for the links! Will definitely look into them and hopefully be able to put them to use!
– Sherry
Jan 17 '12 at 23:10
add a comment |
http://www.vbforums.com/showthread.php?t=376693 (interesting info that may be close to what you are looking for).
If you must use a macro, this site looked promising.
edited Jan 25 '12 at 17:54
soandos
20.2k2892131
answered Jan 13 '12 at 23:24
JeffJeff
174213
http://www.vbforums.com/showthread.php?t=376693 (interesting info that may be close to what you are looking for).
If you must use a macro, this site looked promising.
edited Jan 25 '12 at 17:54
soandos
20.2k2892131
answered Jan 13 '12 at 23:24
JeffJeff
174213
edited Jan 25 '12 at 17:54
soandos
20.2k2892131
edited Jan 25 '12 at 17:54
soandos
20.2k2892131
edited Jan 25 '12 at 17:54
soandos
20.2k2892131
20.2k2892131
answered Jan 13 '12 at 23:24
JeffJeff
174213
answered Jan 13 '12 at 23:24
JeffJeff
174213
answered Jan 13 '12 at 23:24
JeffJeff
174213
174213
Could you expand your answer? Its a bit unclear exactly what your suggesting to do.
– Simon Sheehan
Jan 14 '12 at 20:36
Thanks for your response. I really do need to delve into the world of VBA. Time seems to be the biggest factor for me. What I know about Access I've had to teach myself through trial and error (no classes, no books...sigh). My biggest problem on this one is the deadline and I don't have time to learn VBA in time to meet the deadline. :-( Thanks for the links! Will definitely look into them and hopefully be able to put them to use!
– Sherry
Jan 17 '12 at 23:10
add a comment |
Could you expand your answer? Its a bit unclear exactly what your suggesting to do.
– Simon Sheehan
Jan 14 '12 at 20:36
Thanks for your response. I really do need to delve into the world of VBA. Time seems to be the biggest factor for me. What I know about Access I've had to teach myself through trial and error (no classes, no books...sigh). My biggest problem on this one is the deadline and I don't have time to learn VBA in time to meet the deadline. :-( Thanks for the links! Will definitely look into them and hopefully be able to put them to use!
– Sherry
Jan 17 '12 at 23:10
Could you expand your answer? Its a bit unclear exactly what your suggesting to do.
– Simon Sheehan
Jan 14 '12 at 20:36
Could you expand your answer? Its a bit unclear exactly what your suggesting to do.
– Simon Sheehan
Jan 14 '12 at 20:36
Thanks for your response. I really do need to delve into the world of VBA. Time seems to be the biggest factor for me. What I know about Access I've had to teach myself through trial and error (no classes, no books...sigh). My biggest problem on this one is the deadline and I don't have time to learn VBA in time to meet the deadline. :-( Thanks for the links! Will definitely look into them and hopefully be able to put them to use!
– Sherry
Jan 17 '12 at 23:10
Thanks for your response. I really do need to delve into the world of VBA. Time seems to be the biggest factor for me. What I know about Access I've had to teach myself through trial and error (no classes, no books...sigh). My biggest problem on this one is the deadline and I don't have time to learn VBA in time to meet the deadline. :-( Thanks for the links! Will definitely look into them and hopefully be able to put them to use!
– Sherry
Jan 17 '12 at 23:10
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f378186%2fmicrosoft-access-macro-is-there-a-way-to-copy-records-with-a-macro%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
