AndreRet

You will firstly need to reference "MS Scripting Library" The code will be something like - [CODE]Dim oPict As StdPicture 'Change this for other objects, formats etc... Dim sDir As String Dim sTempFile As String Dim iFileNum As Integer Dim lFileLength As Long Dim abBytes() As Byte Dim iCtr As …

You need to set a new instance to your connection conn - [CODE]Set conn = New ADODB.Connection[/CODE]

Sashka, please read our posting rules. This is a very old post that has just been raised from the dead. This is however your first post, so no harm no foul. Shell is still the shortest and quickest route to interact with cmd. Read the link belkow for more options …

You can also use the "Recordcount, BOF or EOF" properties. [CODE]If Not Adodc1.BOF = True Then 'There is a record existing... End If[/CODE]

What new plans are on the charts for Daniweb in 2011? Add your comments on what you would like to see getting improved upon, added features etc.

Welcome to Daniweb Corey.:) Good luck with your studies.

What databse, access, sql, MySql? What language, VBA, VB6? What field names etc, etc?

Before the mouse move, get the X and Y coordinates - [CODE]Dim X As Integer, Y As Integer X = MouseX 'Not the correct code, correct with whatever you use to get the coordinates... 'The same with Y... Now call the move ... X = X - 1250 Y = …

I think this might be a nut cracker on VB4/5/6 forum. To ensure a quicker response or solution, try the web development forums, most of your code is HTML. I have asked the mods to have a look and see if they can place it for you.:)

I'm not sure hoew the report printing can be manipulated at all. I normally just go for print and thats that. One option would be to try and pause the report printjob after page 1, then print the first page of the terms and so on. Another way would be …

Welcome to Daniweb RJ.:) I Guess I'll see you around the VB6 forum.

Unfortunately for you to manipulate any application, you will have to tap into its dll, in this case Adobe. Without using the adobe (pdf) dll, you will not be able to do much, sorry.:)

Welcome to Daniweb Anthony.:) You can also become a sponsor here on Daniweb which gives you a lot of features not experienced by other members, one of those being free advertising.

Have a look at [URL="http://en.kioskea.net/faq/6200-excel-vba-selecting-the-next-empty-cell-in-a-row"]This[/URL] link to determine the next empty row. Now have a look at [URL="http://www.exceltip.com/st/Copy_a_column_or_columns_from_each_sheet_into_one_sheet_using_VBA_in_Microsoft_Excel/556.html"]This[/URL] link which will copy and paste the values over. The magic of Google.;)

Are you using VBA or VB6?

Is NewFolderPathName an actual folder that was created BEFORE calling the function above? It seems that the code is searching for a folder that does not exist.

Nice Jhai. The poster needs to understand that we are not here to do THEIR homework for them. Show some effort, play with the samples given and find the solution. Do you really expect Jhai to do ALL of the coding and solution for you?

Smart Bear is quite a nifty tool to use. You can download it for a trial period [URL="http://smartbear.com/lp3/sb-aw-int-code-review.php?gclid=CNSjwci1gqUCFYY14wodXUTCNg"]here[/URL]. Project Analyzer is also nice to use, find it [URL="http://www.aivosto.com/project/project.html?source=google"]here[/URL].

Welcome to Daniweb Magnus.:) [QUOTE]If you know how to copy and paste with little intelligence, your future is bright so bright[/QUOTE]LOL So true... ;)

Welcome to Daniweb.:) I've asked the mods to have a look...

Welcome to Daniweb.:)

Welcome to Daniweb Robert.:)

Welcome to Daniweb.:)

Welcome to Daniweb.:) [QUOTE]Actually that's the reason I have such a high post count because I've spent some time to do just that[/QUOTE] WITH some bragging rights.;)

Welcome to Daniweb.:)

Welcome to Daniweb Steffi.:)

If you are using Vista or Win7, Sendkeys will throw an error. Try the following which is working fine in all OS versions - [CODE]'Set a reference to MS Scripting runtime... 'Under your text box keypress event... Dim WshShell As Object Set WshShell = CreateObject("WScript.Shell") If Not IsNumeric(txtIdNumber.Text) Then WshShell.SendKeys …

Have a look at the attachment, something I used quite a while back. It will give you all the basics of a count down timer.:)

@HappyGeek, the way I see it, this was only the introductory event to your birthday on Friday. As ancient suggested, use the present as a flower pot and obtain a larger beverage holder... for Friday AND the next day (refer frogboy's steps 2 to infinite loop).;) @Ardav, when doing the …

I would not be able to say, don't have a clue what Lego games are all about.:)

@Bilzz, Thanks for your efforts in welcoming new members, it is appreciated. Do however try and refrain from replying on threads as old as this one, thanks.:) You will find that Daniweb gets about 5 new members per day. There are plenty for you to welcome.;)

[QUOTE]hi! im the newest member of your group[/QUOTE] That you are indeed!;) Welcome to Daniweb. Thanks for keeping to our posting rules.:)

If you say LeaveCell, does this mean that another control must get the focus, or just move on to the next cell?

First load the saved user name and password from your table - [CODE]Dim strUserName As String, strPassword As String Set rsLogin = New ADODB.Recordset rsLogin.Open "SELECT Username, Password FROM MyLoginTable",cnLogin, adOpenStatic, adLockOptimistic strUserName = rsLogin!Username strPassword = rsLogin!Password If Not txtUsername.Text = strUsername Then msgbox "Ooops, Invalid user name" txtUsername.Setfocus …

When you say VB (I take it that you are talking about VBA) opens up, is it the macros ? What exactly opens up?

I thought we have covered this already in your previous thread about using mouse scroll. Google "Using mouse scroll in vb6". There are plenty of solutions that you can use, referring back to your previous thread as well.:)

Welcome to Daniweb Fred.:)

Firstly, the IP needs to be where the camera is uploading, which it seems is fine. Yes you can use multiple web browsers on the same form. Use say, command buttons to load the required browser. What exactly is your problem though?

I think the problem might be with the range not specified. Try the following - [CODE]xlTmp.Activesheet.Range("A1").PasteSpecial Paste:=xlValues, xlNone, False, False[/CODE]

From the bottom up - Yes, you can create different folders on a users pc. I personally like to create my app folders on the users C:/ drive because it does not come with restrictions like program folders does. I'm sure you know how to create a folder using code.:) …

Welcome do Daniweb Charlie.:) Enjoy the beer.;)

The sql statement will be something like - patient details and it has fields as name,id,height,weight,bmi,email,phone etc. [CODE]Rs.Open "SELECT * FROM [patient details] WHERE id = " & "'" & txtId.Text & "'", cn, adopenstatic, adlockoptimistic If Rs.BOF = True Or Rs.EOF = True Then Rs.AddNew Rs!name = txtName.Text 'and …

Two questions, 1) Is the application running on a server? 2) Have you closed the first document when trying to open the same again? Is the above code all the code under the command button?

I have asked to move this to vb.net, the second post of course is a different story... [CODE]Dim charArray As String charArray = "My string here" Text20.Text = charArray[/CODE]

Welcome to Daniweb. I hope you find your answer you are looking for soon.:)

It seems that the original port was never closed. When it is still open, the following connection will open a new port. Close the original when exiting the server.

Try to use [CODE]Format:=wdOpenFormatAuto[/CODE] before your [CODE]W.activedocument.SaveAs "documentname.doc", 0, 0, "". 1, "", 0, 0, 0, 0, 0[/CODE]

You can use the following - [CODE]Text1.Text = Datagrid1.TextMatrix(Datagrid1.Row, 1) 'The 1 at the end refers to the coloumn value in the grid, in this case coloumn 1...[/CODE]

Welcome to Daniweb Laban.:)

Abe, you should know by now that you can not just ask for code, show your efforts first.:) [CODE]Option Explicit Dim oConn As ADODB.Connection Dim oRs As ADODB.Recordset Private Sub Command2_Click() 'Using MS Access database... Dim sConn As String Dim oConn As New ADODB.Connection 'Declare a new connection... Dim oRs …