Set rs2 = New ADODB.Recordset rs2.Open "select * from company_name", db, adOpenKeyset, adLockBatchOptimistic rs2.AddNew If pdfpath <> "" Then Set pdffile = New ADODB.Stream pdffile.Type = adTypeBinary pdffile.Open pdffile.LoadFromFile pdfpath rs2.Fields("pdf") = pdffile.Read rs2!co_no = Val(co_no.Text) rs2!co_name = co_name.Text ''' pdffile.Close Set pdffile = Nothing rs2.Update Set rs2 = Nothing … |
|
i need to know if i can scan an image or any file from vb6 form then save it to my database, if yes how i can do it ?? thanx in advance... |
|
'======================================================================================================= If rs.State = adStateOpen Then rs.Close rs.Open "select ActvID from activity_id where ProjectNo = '" & ProjectNo1 & " ' ", db, adOpenDynamic, adLockReadOnly If Not rs.EOF Then rs.MoveLast While Not rs.BOF ActvID.AddItem rs(0) rs.MovePrevious Wend Set rs = Nothing i need to add items without using While plz |
|
hi every one , i have this Question and i hope if i find an answer about it , can i convert a pdf file to image using vb6 ?? |
|
can't show non-modal form when a modal form is displayed |
|
how i can return multiple row in sql data base in one row using crystal report?? , for Example 1 DWG1 1 30-5-2013 1 DWG1 2 16-9-2013 in Crystal Report i need to show 1 DWG1 20-11-2013 30-5-2013 16-9-2013 Any Idea Please ?? |
|
hi everyone i need to show the form in taskbar , i set the Property ShowInTaskbar to true but the form didnt show , any help ?? |
|
Re:
how to insert data into datagridview from sql table using recordset in vb6.0 |
|
i need to know if there is way to open a file from groove directory using common dialog ?? more details i have a workspace and many accounts all connect to a server i need to make them upload and open the file using Groove path ?? any help |
|
hi every one , i need to know how to get a file path to textbox using browse button or common dialog , any body can help me ?? |
|
Re:
please help me to do with my system. i want my txtempid.Text is auto generated evrytime i will add new employee . Field = "emp_id" i'm using vb 6 as ADODB and Mysql database thanks in advance...God Bless |
|
Re:
How can i send an email from vb6.for example my driver’s license will be expired in a month. I want my vb6 to send an email to notify me about the expiration. Anyone can help me? Thanks in advance. |
|
hi again , how i can read a path of file that location on a server in vb6 ??? for example my server is 192.168.1.222 and folder is software |
|
hi everybody , i need to solve this case as soon as possible : i have the master table that include the following data : (SerialNo - integer (P.K), civil-bit, mechanical-bit, etc) and form that include the serial no text field that automatic increase by one each time the user … |
|
i have ProBook 4540s laptop with 8 G RAM , when i format it and install windows 7 - 32 bit i got an 2.63 usable RAM , how i can change the usable ram to 8 G . ??? |
|
this is my code , it should save a pdf file from sql server to a folder but nothing happened can anyone help please ?? Set rs = New ADODB.Recordset rs.Open "select * from PDFStore where filename='" & co_name.Text & "'", db, adOpenKeyset, adLockBatchOptimistic If Not rs.EOF Then Set pdffile … |
|
hi everybody , i would like to know how to view data in my crystal report depend on InputMessage that ask from the user how to sort the data to view on the report , as date or status , any one can help how to do that ?? |
|
hi everyBody, Can some one tell me the steps of how to make daily back up database from SQL Server 2008, when i do this Script and job it give me an error cant be completed, any help plz... |
|
Re:
when im adding some group header or footer in datareport i always got an error msg **report sections do not match data source** i fix the grouping on dataenvironment and everything nice but i could not find the way out of this. hope you all will help me..thanks in advance. … |
|
can anyone help me of how i can copy a file from user computer to a server that can anyone open the file??? my case is : i have a text field to read a path and command button to save a path and i have another command to view … |
|
If rs.State = adStateOpen Then rs.Close rs.Open "select Distinct ActvID where ProjectNo = '" & ProjectNo1 & " ' ", db, adOpenDynamic, adLockReadOnly If Not rs.EOF Then rs.MoveLast While Not rs.BOF actvID.AddItem rs(0) ActvID2.AddItem rs(0) ActvID3.AddItem rs(0) ActvIdA.AddItem rs(0) & " " & rs(1) ActvID2A.AddItem rs(0) & " " & … |
|
i used this code to send email from vb6 form that connect with out look email account 'Dim olapp As New Outlook.Application 'Dim olMail As Outlook.MailItem 'Create a new mail object form the 'Outlook98 Application object 'Set olMail = olapp.CreateItem(olMailItem) 'Set the mail fields of the olMail object 'olMail.Subject = … |
|
'Text2.Text = "C:\MyPath\MyDocument.pdf" 'Shell "C:\Program Files\Adobe\Reader 10.0\Reader\AcroRd32.exe" & " " & Text2.Text, vbNormalFocus this code correctly work for one user pc, but other users that use the system cant be open the file , how i can make the file published?? |
|
hi every body , i have recently developed a system using vb6 forms but i need a help o f how to save and view a file with the pdf and .dwg and view it in a form , any help plz ?? |
|
hi every body , i am finishing the design of crystal report that connected to data base and i have an Project in vb6 how i can add these report to the project ?? |
|
I need the steps to make an daily Back Up to my data base i am using SQL 2008 and when i do the backup job it gives me an error unsuccessfull complete , any one can tell me why ?? |
|
hi every one , can some one give me an idea or code of how to save .PDF file and .dwg into sql server and preview these file using image box in vb6 if can ???? |
0 Reputation Points
0 Endorsements
Ranked #4K
~13.0K People Reached
Favorite Forums
Favorite Tags