I know to use VB, Access and Crystal Report such as:
Private Sub Command1_Click()
cr1.DataFiles(0) = [Access/.MDB file]
cr1.ReportFileName = [Cystal report/.RPT file]
cr1.Destination = crptToWindow
cr1.Action = 1
End Sub
But how if the .MDB contains a password?
Urgently need...
Thank you, Alphanytz.
I have tried your suggestion, but it raised the message:
Run time error 3151
ODBC--connection to 'C:\MyApp\MyDb.mdb' failed.
Any other suggestion ?
I need your help please
I have an Access MDB containing password, and in my application I open it ReadOnly with DAO(3.6)
I wrote :
Set MyDb = OpenDatabase("MyDb.mdb", , , "Uid=Admin;Pwd=MyPwd;")
but VB always told me that my password is invalid. I'm sure I gave a valid...
I use ADO to access my Access 2000 database. But in Win2000, when run the line :
Set myConn = New Connection
an error appear with the message:
Automation Error
The specified module could not be found.
When I run the code in Win XP or Win 98, there is no problem with it.
The other strange...
Thank you guys,
but my form has a lot of textboxes, so I want as the form shown, the keyboard caps lock always on "On" position. For any reason, I use regular textboxes, not a MaskedEdit textbox which has an UpperCase property.
Hi..
Got a problem here...
I need to force the CapsLock on my keyboard on. How can we do it in VB command ? I have try it with SendKeys "{CAPSLOCK}", but it didn't work. Any suggestion ?
Thank you
Hi..
In my app, I put a splash screen after user login succeeded and before mdiform shown. Some procedures run while the splash screen shown, but I think it's too fast to shown. I want it can be a longer time seen.
So, is there a command in VB to delay the time for a seconds? For a reason I...
Got a problem here...
We can pass parameters to procedure or functions, but I do not know how to pass parameters to a forms, like what we do in VFP:
Do Form MyForm With "Hi..."
Can we do it in VB? Thank you.
Hi...
I need to place a picture on an MDIForm. User may select the picture they want from image files. If the image's size is smaller than the form, I want it can be centered or streched (like Windows desktop). I have try in many way, but did not get what I want. (In standard form, maybe I can...
I need your helps, please..
Say I have 2 MDI child forms, A and B. Form A show first, then form B. So, form B is the most top than form A. Now how can I make form A on top than form B by command (without click on it) ?
Thanks for your attention.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.