Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Impression d'un rapport Access
Message
De
11/09/1998 20:32:08
 
Information générale
Forum:
Visual Basic
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00135165
Message ID:
00135721
Vues:
9
>I have to print a report created in MS-Access 97 from a VB application.
>
>I have tried the following code:
>
>Private Sub cmdRapport_Click()
>Dim objAccess As Access.Application
>
> Set objAccess = New Access.Application
>
> With objAccess
> .OpenCurrentDatabase "C:\toto.mdb"
> .DoCmd.OpenReport "Rapport1"
> .Quit acQuitSaveNone
> End With
>
> Set objAccess = Nothing
>End Sub
>
>Now, I have my report printed BUT my database is protected by a password. When I execute the OpenCurrentDatabase method, a dialog box ask the password to the user.
>
>How can I pass the password using this method OR how can I print a report from a database object?


Il ne semble pas avoir de façon de le faire.
As-tu considérer utliser la sécurité avec usagers plutôt que le mot de passe ?
Ça serait sans doute possible.
Guy Barrette, MCSD
============
Blog http://weblogs.asp.net/guybarrette
Microsoft Regional Director, Montreal, Canada www.microsoft.com/rd
MVP, ASP.NET http://mvp.support.microsoft.com/
President, Montreal Visual Studio User Group www.guvsm.net
INETA Regional Rep for Quebec www.ineta.org
UniversalThread Magazine Columnist (.NET Books Review Column) www.utmag.com
Tech Chair French Track, DevTeach 2004 & 2005 www.devteach.com
Business Architect, Microsoft Team - Nurun Inc www.nurun.com
XBox Live Gamer Tag: Slomo QC CA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform