If you are not a paid subscriber, you must have signed up for our free trial at http://www.codeoftheweek.com. Our ezine is not an unsolicited message (in other words a spam email). Keep in mind that if you signed up for our free trial you can still receive a total of four issues at no cost to you. After you receive the four issues you will be notified about continuing your subscription.
If you do not wish to continue to receive this ezine, please email us at email@example.com
The source code in this issue is designed for Visual Basic 5.0 32-bit and above. It will work in VB 4.0 with small changes to the error handlers and the parameters in the CopyQuery function. It is geared towards the intermediate to advanced programmer.
If you have any questions about this issue, please email us at firstname.lastname@example.org
This issue introduces a routine to copy a Microsoft Access query from one database to another. It will also work with any databases that support the QueryDef object and the QueryDefs collections.
Public Sub CopyQuery(sQueryName As String, sSourceDB As String, sDestinationDB As String, Optional bOverwrite As Boolean = False)
Nothing unless an error occurs. If any error occurs it will be raised to the caller.
This example shows how to use the CopyQuery subroutine. The first example will copy the query called rpt11 from the src.mdb to the dest.mdb. The second will copy rpt12 from src.mdb to dest.mdb. If the query rpt12 exists in dest.mdb it will automatically be overwritten.
CopyQuery "rpt11", "e:\temp\src.mdb", "e:\temp\dest.mdb" CopyQuery "rpt12", "e:\temp\src.mdb", "e:\temp\dest.mdb", True
To see the source code for this issue you must be a subscriber to Code of the Week. If you are a subscriber the source code is available at the following address: http://www.codeoftheweek.com/membersonly/bi/0043.html
That concludes this issue of COTW. We hope you find the source code useful in your development.
The below describes the ways you can supply us some feedback about COTW. We would like to see our members help mold COTW into the best Visual Basic source code resource available. But to do that we need your feedback about what you like and what you do not like about COTW.
If you are interested in advertising in COTW please email us at email@example.com Our rates are VERY reasonable, actually they are almost FREE. We reach over three thousand Visual Basic developers each week.
If you have any suggestions for topics you would like to see covered or questions about this issue, please email them to firstname.lastname@example.org or use online feedback form at http://www.codeoftheweek.com/feedback.html.
If you have any source code you would like to submit for possible inclusion in COTW, please fill out our online submission form at http://www.codeoftheweek.com/submission.html.
Thank you for trying Code of the Week for Visual Basic.
Your free trial expires after you receive your fourth issue. If you want to continue to receive Code of the Week you can get 52 issues of COTW for only $19.95. This is a full year of Visual Basic source code and information to help with all your development. So don't wait, subscribe now! The quickest way to subscribe is to jump to our online order form at http://www.codeoftheweek.com/order.html