Hi, I think he had given it. He assign values in those variables along with ',' also. I cant find an error. Thank you.

Hi friend, We can write comments by using single quotes. For example : - Public sub getMax() 'This is to get maximum number Useful codes. End Sub OK. Waiting for next question.:zzz:

hi everyone... I m looking for an example code for making my exe run while startup... Any help will be appreciated...

Hi friends, Please help me. I am creating a time scheduler in VB. It produces alarm messages at predefined time. It works. But i want to run that application on the starting of windows (log on). Please give me instructions and samples for this problem. Thanks in advance.:->

Hi, I dont know how to create crystal reports by using VB6. But i can help u for calling report from VB6. Here is a sample code gtRptDsn = "DSN = " & ServerName & ";UID = **; PWD=****" .Connect = gtRptDsn .Destination = crptToWindow .Destination = crptToPrinter in report function .ReportFileName = tcpath & "ReportName.rpt" //stored procedure parameters .StoredProcParam(0) = GiSbuid .StoredProcParam(1) = iProjectId .StoredProcParam(2) = iVendorId .StoredProcParam(3) = ICategoryId .StoredProcParam(4) = IGroupId .StoredProcParam(5) = IMaterialId //for header(like company name and addresss) use Fomula .Formulas(0) = "Company='" & GTEnterprise & "'" .Formulas(1) = "Add1='" & GTSbuAdd1 & "'" .Formulas(2) = "Add2='" & GTSbuADD2 & "'" // to show report RptQuotation.Action = 1 RptQuotationReport.PageZoom 100 // to make the report as a child of MDI form .WindowParentHandle = mdiFormMain.hwnd By Dileep I love my bug since she is my best friend.

Hi all, Sorry to be late.

Dave Kreskowiak wrote:

So what does this mean?

I meant, I can open any picture i stored in sql database in a picturebox. I stored picture as bytes. Opening of first and second picture (randomly from database) work smoothly. But when i try to open third image then it will show that error. I used following function to retrieve image from collection of bytes. Public Function PictureFromBits(abPic() As Byte) As IPicture ' abPic() as a byte array Dim nLow As Long Dim cbMem As Long Dim hMem As Long Dim lpMem As Long Dim IID_IPicture As GUID Dim istm As stdole.IUnknown Dim ipic As IPicture On Error GoTo Out GlobalFree (hMem) nLow = LBound(abPic) On Error GoTo 0 cbMem = (UBound(abPic) - nLow) + 1 hMem = GlobalAlloc(GMEM_MOVEABLE, cbMem) If hMem Then lpMem = GlobalLock(hMem) If lpMem Then MoveMemory ByVal lpMem, abPic(nLow), cbMem Call GlobalUnlock(hMem) If (CreateStreamOnHGlobal(hMem, CTrue, istm) = S_OK) Then If (CLSIDFromString(StrPtr(sIID_IPicture), IID_IPicture) = S_OK) Then Call OleLoadPicture(ByVal ObjPtr(istm), cbMem, CFalse, IID_IPicture, PictureFromBits) End If End If End If End If GlobalFree (hMem) Exit Function Out: MsgBox "Out" End Function I think this is a problem regarding memory. Please help.

Dave Kreskowiak wrote:

How big are these images, in bytes?

I opened images with almost all sizes. eg: 57060 Bytes. Thanking for your interest.

ma se wrote:

How do I return columns only and not the rows of the records

Hi, You really mean column names?. If you are using recordset then you can take field anmes by adors.fields(index).name.

Hi all, I am trying to code for storing images into database as bytes and for its retrieval. It worked well. But if we try to load more than two pictures one by one then it shows an error as follows. --------------------------- Visual Studio Just-In-Time Debugger --------------------------- An unhandled win32 exception occurred in VB6.EXE [1160]. Just-In-Time debugging this exception failed with the following error: No installed debugger has Just-In-Time debugging enabled. In Visual Studio, Just-In-Time debugging can be enabled from Tools/Options/Debugging/Just-In-Time. Check the documentation index for 'Just-in-time debugging, errors' for more information. --------------------------- OK --------------------------- I used GlobalAlloc function to allocate bytes of memory in my heap. I allocates almost 26347868 bytes in memory. I tried to free memory by using GlobalFree. But the result is same. I will be thankful to you for your help. Dileep trying to work as a freelancer.

Hi all, I am trying to code for storing images into database as bytes and for its retrieval. It worked well. But if we try to load more than two pictures one by one then it shows an error as follows. --------------------------- Visual Studio Just-In-Time Debugger --------------------------- An unhandled win32 exception occurred in VB6.EXE [1160]. Just-In-Time debugging this exception failed with the following error: No installed debugger has Just-In-Time debugging enabled. In Visual Studio, Just-In-Time debugging can be enabled from Tools/Options/Debugging/Just-In-Time. Check the documentation index for 'Just-in-time debugging, errors' for more information. --------------------------- OK --------------------------- I used GlobalAlloc function to allocate bytes of memory in my heap. I allocates almost 26347868 bytes in memory. I tried to free memory by using GlobalFree. But the result is same. I will be thankful to you for your help. Dileep trying to work as a freelancer.

Hi, I think you mean .State property. For eg:- dim adocn as new ADODB.Connection Then we can check whether connection is open or not by adocn.State

Hi Graus, You said VB6 is a dead language. But nobody have a little experience in working with VB should'nt say like that. They would say it as the most flexible language. We can write a complex coding in other language in a very simple way in VB. By Dileeeeeeeep.

Hi friends, I am using VB6 at front end and SQL/SERVER 2005 on back end. Now i need to save pictures (in jpeg or bmp) in SQL database. And i have to display it on front end when it needs. I saved one image into database into a table field of type 'image'. It was saved. Is this the correct way to save picture in database?. Then how can I display this file in VB6. by Dileeeeeeeeeeeeeeep. :doh:

Hi' a file is created but it is not a picture format.

Hi friend, I was not at site for these days. That's why i cant reply you. So what is this 'ShellExecute' i can't made it. Is there any references to add? by Dileeeeeeeeeeep.

Hello friends, I stored an image from my front end(VB) into SQL database on a datatype image. Then how can I show that image in VB. Please help While loading it through recordset I get this '????' .

Thanks for reply. But is replied as it were in VB.

Why do you need to encrypt your connection string. It would be hidden after making its exe. Ok, waiting for more questions.

:-DHow can I create HTML help file for an application. I mean i amde html file, but cant call it from my application. Will you please give a sample code for it. By Dileep P A

what is Vb Dileep

poda poda