Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 18th, 2012, 10:15 PM
Registered User
 
Join Date: Sep 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Export Formatted Report To Excel

This is a picture of my Access report http://i.imgur.com/sWXUZ.png, each of the textbox recieve its data from another textbox in a form.
This is a picture of an excel template http://i.imgur.com/79Hkd.png.

Is it possible for me to export the data in the textbox of my report into my excel template cell specifically.
I have been using Access for 1 week plus and have no experience in VBA codes or whatsoever, so please explain in "noob" terms (: Thanks!!!
 
Old February 3rd, 2013, 07:15 PM
Registered User
 
Join Date: Feb 2013
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Is it possible? In short, yes. I have done this type of thing by coding VBA, having the code launched by the user clicking on a specific button on the form (e.g., "Export to Excel" could be the caption on the button). Having said that, there is alot you will need to learn about both Access and VBA to accomplish this. As such, my advice is to buy and read the following books:
"Access 2010 - The Missing Manual" (O'Reilly); This is a really good book for those new to Access. It won't help with VBA, though.
"Access 2010 Programmer's Reference" (Wrox); This has tons of good material (VBA code snippets + explanations of the objects you will need to be up-to-speed on + various coding tips, etc.). You can probably get the Wrox book on this site; the other would be obtainable via Amazon. Happy reading.





Similar Threads
Thread Thread Starter Forum Replies Last Post
how to export crystal report to excel manoj_k79 Classic ASP Basics 2 September 12th, 2011 01:52 AM
Crystal Report Export problem to excel spmano1983 VB.NET 0 August 17th, 2007 01:33 AM
Export Access table to a pre-formatted Excel file mccoy Access VBA 2 May 25th, 2007 08:04 AM
Export Crystal Reports' report to Excel ONLY DATA peter2004 Crystal Reports 0 January 6th, 2007 02:30 PM
Export Access Report to Excel - Total column moves rklass BOOK: Access 2003 VBA Programmer's Reference 1 June 9th, 2006 08:50 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.