SaRa Ahmad

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

'On Error GoTo Error_Handler If rs.State = adStateOpen Then rs.Close rs.Open "select *" _ & " from [tablename] " _ , db, adOpenDynamic, adLockReadOnly DataGrid1.ColWidth(0) = 1000 Set DataGrid1.DataSource = rs Exit_Error_Handler: Set rs = Nothing Exit Sub Error_Handler: MsgBox Err.Number & " : " & Err.Description Resume Exit_Error_Handler

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

If rs.State = adStateOpen Then rs.Close rs.Open "select max(emp_id) from tablename", db, adOpenDynamic, adLockReadOnly If rs(0) <> 0 Then txtempid.Text = rs(0) + 1 Else txtempid.Text = 1

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 = (your subject here) olMail.To = "set the email you want to send for" ''olMail.Body = <the mail …

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

make sure that you are updating all table fields on your report

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