Search results for query: *

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...

Can we set the picture in report designer at run time ? I use LoadPicture, but not work. Help me..., please help me....

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...

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... My procedure contains For... Next statement. How can I stop or interupt the loop by pressing the Escape key while the loop run ? 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.

Help me, please I have a problem to save the Date data type if it is empty. Say I have a textbox to input date. I can save to disk if there is a data in it, by : rsTable!InputDate = txtInputDate But if the textbox is empty, an error 'Type mismatch' will appear. How can I do it without an...

I'm writing an app and it needs to print both landscape and portrait orientation print report. But I have a problem, how to set it by program ? I've tried to do it with : Printer.Orientation = 1 'to set it portrait and Printer.Orientation = 2 'to set it landscape before the datareport shown...

Hi, all. I have a problem here I wrote a procedure with parameters, using ParamArray to pass variative number of parameters, and it is exactly same as the sample in MSDN. Sub AddLists(ByVal TheKey As String, ByVal ParamArray NamaFields() As String) ... ... End Sub But as I leave the Sub...

Anybody please help me ... Say I have a form and a textbox on it named : txtSupName (as textBox) I also have a variable named : varSubName = "txtSupName" '(as string) Is it possible to set the textbox's properties by the variable's value ("txtSupName" as string) not by...

Hi, All ! How to check if a form is exist (shown) ? Thank's

Sorry, I'm asking a simple question, because I really don't know how to do this simple thing: How to delete a file in a specific folder by command in VB ? e.g: I want to delete the file "C:\MyFolder\MyFile.txt" Thanx for your help !

Somebody please help me My DataGrid (not the two others grid) control binded to an Adodc control. I want to customize it by coding, not at design time. Say, I have 5 fields in the ADO table, but only 3 will displayed in the DataGrid's rows, and then the titles of the rows will be changed, too...

I want to build an application uses a form, and its size is same as the paper's form (A4 Portrait), then I add a scroll bar. I try to set the form's height to the size I want, but it seem that the maximum height is only 9000 twips. Is there any way to solve my problem? Thanx.