MartyConnelly
martyconnelly at shaw.ca
Sat Jul 17 13:11:19 CDT 2004
There is a new data grid control with vb.net express.
You could use SQL Reporting Services, there is a wizard to upgrade
Access reports to SQL Service.
Or if you want just local reporting with vb.net and you have Access
installed you can use Access Reports.
Here is some code that should run under vb.net to print locally, preview
or email report.
You will need the Access mdb to test against.
You may have to modify the Access database and play with to get print
menu selection
working properly.
It has a menu toolbar to direct to various printers or email
'http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm
' Acesss97 example With ms-access interface hidden:
And here is the method to call it.
I tested this with another Access program but should work with VB.
You can even remove the Access Key Icon or set to your own
in the upper corner, can't remember how but have done it.
Option Compare Database
Option Explicit
Private Const SW_SHOWMAXIMIZED = 3
Private Const SW_SHOWNORMAL = 1
Private Const SW_HIDE = 0
Private Declare Function apiSetForegroundWindow Lib "user32" _
Alias "SetForegroundWindow" _
(ByVal hWnd As Long) As Long
Private Declare Function apiShowWindow Lib "user32" _
Alias "ShowWindow" _
(ByVal hWnd As Long, ByVal nCmdShow As Long) As Long
Sub test()
'http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm
' Acesss97 example With ms-access interface hidden:
Dim accRpt As Access.Application
Set accRpt = CreateObject("Access.Application")
With accRpt
.Application.OpenCurrentDatabase ("C:\WordVBA\Kallal Word Merge Easy
Samples\WordMerge22\WordMerge22.mdb")
.Application.DoCmd.Maximize
.Application.Visible = True
Call apiSetForegroundWindow(.hWndAccessApp)
'Call apiShowWindow(.hWndAccessApp, SW_SHOWNORMAL)
Call apiShowWindow(.hWndAccessApp, SW_SHOWMAXIMIZED)
' Call apiShowWindow(.hWndAccessApp, SW_HIDE)
' .Application.DoCmd.OpenForm "frmDefaultPrinterList"
'displays the custom toolbar named CustomToolbar in all Microsoft Access
windows that become active:
.Application.DoCmd.ShowToolbar "Rides Print", acToolbarYes
'DoCmd.ShowToolbar
.Application.DoCmd.OpenReport "Contacts", Access.AcView.acViewPreview
'Set the focus to MSACCESS
'alternate method
'Dim lngAcc As Long
' lngVal = FindWindow("OMain", ByVal 0&)
' lngAcc = SetFocusAPI(lngVal)
'must close form to exit second app 'acReport=3;acObjStateOpen=1
Do While .SysCmd(acSysCmdGetObjectState, acReport, "Contacts") =
acObjStateOpen
DoEvents
Loop
.Quit acQuitSaveNone
'MsgBox "Print"
End With
Set accRpt = Nothing
End Sub
Jim Lawrence (AccessD) wrote:
>Hi Marty:
>
>Fine piece of investigation.
>
>I was just about to install SQL Empress on my 2003XP server, one with SQL
>2000/EM and would have lost the manager. I wondering if there is a work
>around as I was hoping to have an application put together using Access2003
>or VB.Net and SQL Express, by the end of the summer.
>
>Looks like that will not be possible for a while.
>
>I guess if the application is assembled, using SQL2000, the table
>structure/SP etc.. should be portable to SQL Express, on a XP box and
>Express.
>
>A little off topic:
>
>I have been trying to find some info on reporting capabilities of
>VB.Net...does it have any or does it require a third-party product like VB6?
>Has anyone worked or found a good site with code related to extending VB.Net
>grid capabilities?
>
>Any suggestions will be appreciated.
>Jim
>
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of
>MartyConnelly
>Sent: Saturday, July 17, 2004 8:48 AM
>To: dba-sqlserver at databaseadvisors.com
>Subject: [dba-SQLServer] Some quick install notes and warnings on SQL
>Express2005
>
>
>SQL Express 2005 is Yukon and replacement for MSDE. However, like MSDE, SQL
>Express does not have any administrative interfaces. Review the installed
>documentation and its own BOL to learn more about SQL Express. They are
>supposed to bring out a Beta EM, backward compatible with MSDE.
>
>Some notes I have picked up that may help.
>
>1-------------------------------------------------
> SQL Express can't run on XP Home, so what is the purpose?
>
>One of the purposes for SQL Express is deployment with
>applications instead of JET. Now the software companies
>involved have to force their clients to buy XP Pro????
>Arrrghhhh!
>
>There are rumors you may be able to modify TCP ports to get around this.
>
>System Requirements for Express
>
>http://lab.msdn.microsoft.com/express/sysreqs/
>
>2 --------------------------------------------------
>FAQ: Installing SQL Express side by side with SQL 2000 Enterprise Manager
>seems to break EM. It is still broken when You uninstall Express. SQLDMO9 is
>culprit.
>
>http://blogs.msdn.com/sqlexpress/archive/2004/07/04/172956.aspx
>http://blogs.msdn.com/sqlexpress/archive/2004/07.aspx
>
>3 -------------------------------------------
> I noticed that the DTS Runtime will not be included. In Access, you get the
>DTS Runtime when you install MSDE. Does this mean that DTS will not be
>available in Access?
>
>Currently, I use DTS to interact with SQL Server databases hosted at ISPs.
>It is a quick and easy solution to use the DTS Wizard to upload data from
>the Access database to the SQL Server database using bulk insert. I would
>hate to see that go away.
>
>4 -------------------------------------------------
>SQL Server Express does not have any connection limits. 4GB max size
>It doesn't install any test databases but there is a sample pubs database
>script install from download pages.
>I think you can install side by side with MSDE but you will break EM
>
>5.--------------------------------------------------
> SQL Server 2000 Reporting Services fails after installing SQL Server 2005
>Fix here
>http://blogs.msdn.com/sqlexpress/archive/2004/07/07/175820.aspx
>
>--------------------------------------------------------------------
>Welcome to the Visual Web Developer 2005 Express Edition Beta Guided Tour
>
>http://beta.asp.net/GuidedTour/s2.aspx
>
>Beta Private newsgroup -- good for problems
>
>microsoft.private.sqlserver2005.express
>
>http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&sl
>cid=us
>
>
>Express overview
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/
>sseoverview.asp
>
>
>--
>Marty Connelly
>Victoria, B.C.
>Canada
>
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>
>
--
Marty Connelly
Victoria, B.C.
Canada