AndreRet

Will the values you showed us above be the same always, or is it returned from a database etc. How will you know what are the IP's you want to display from an entire list?

What exactly are you having problems with? Is the errors generated in VB6 or in Access?

Have a look [here](http://www.vbdotnetforums.com/ado-net/40271-dataadapter-selectcommand-property-needs-initialized.html). You need to use your "firstsql" or "secondsql" strings to build the selectcommand, which will then initialise it, it seems.

I almost s*** myself for his part, that is just plain out creepy stuff. I hate heights. If God wanted me to go that high he would have given me wings... Red bull doesn't even let you fly that high, lol. Awesome clip though. :)

Welcome to Daniweb. We'll see you around.

Please mark this as solved, it still shows as an open thread in forum, thanx.

This should do the trick - if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } header('Location: running.php'); mysql_close($con); exit();

Have a look at [this](http://www.bigresource.com/VB--Scroll-thru-DataGrid-Rows-iPzNe9oz3i.html) link. might contain your answer..

Add the following code to a module (.bas) - Public Sub ClearTextBoxes(frm As Form) Dim Control As Control For Each Control In frm.Controls If TypeOf Control Is TextBox Then Control.Text = vbNullString End If Next Control End Sub Now, in your Form 2 under form unload event - Private Sub …

I am totally stuck and hope that someone here might have had the same problem in the past. When I test my code under localhost, all images displays perfect, not so when uploaded from my hosting server. What it does: It uploads data from the database as a description of …

Rather use you adodb to connect to your database. Once you have the connection open and you selected and opened a recordset, just set the datgrid's datasource to the recordset - con.Open ...... F:/super.mdb.... rs.Open "SELECT * FROM ..... Set mshFlexgrid1.DataSource = rs All records that has been selected will …

You are returning ALL records because you have not set a where value... SELECT `id`,`price` FROM `edit` ORDER BY `id` WHERE `id`='2345'

This is a common mistake when writing a new application. When you start a new project, create your database in the folder that you have created for the application... You should then use the path to the database to make sure it works 100%. path(c:\mydocuments\super.mdb) is incorrect, use the following... …

You will find everything about binary and varbinary [here](http://dev.mysql.com/doc/refman/5.0/en/binary-varbinary.html). The BINARY and VARBINARY types are similar to CHAR and VARCHAR, except that they contain binary strings rather than nonbinary strings. That is, they contain byte strings rather than character strings. This means that they have no character set, and sorting …

No idea what you mean... I get thye folder in one coloumn part, the second part "square" and then marked thing... no idea. We will not know if pictures is better because you need to give us much more information.

Your page are trying to read from a folder where access has been set to be denied, hence your error. You need to check which part of your code it is that is returning the error to find the folder that has access rights on it. Then clear the access …

This sounds like a school project, which we will unfortunately not develop for you. This is a help site, show us what you got and we will assist in error resolving etc. Also, this is a vb6 forum. I've asked the mods to move it to asp.net

First, not sure what this is, a timer or some time controlled sub? tmrAnswer.Start() Ahhh, don't worry, vb.net timer enabled code. This is a vb6 forum. Lets see if we can see you through this. I'd rather make use of proper timing sequences used. This is what I have been …

What do you have so far? At this stage from your asking help above, it's all guessing work to us...

"Arguments not optional" - Not exactly sure what was set previously... This error will normally return true when you have ste the values differently, i.e you have set a value between 1 - 10, you now want the sub to return say a string "hello". the error will tell you …

Not sure what you mean? :)

Have a look at [this](http://www.ozgrid.com/forum/showthread.php?t=82119) link with sample code for various options in excel

I need to add an image (saved path in mysql - image from file on server returned from $image_id) to my page according to 4 rows returned. There will always be 4 rows returned from db. My problem is that it shows the same image (main with 3 thumbnails) in …

Try the following code or give us more information... listView1.Items(0).Selected = True To select an entire row - Private Sub Command1_Click() ListView1.MultiSelect = True For a = 1 To 10 ListView1.ListItems.Item(a).Selected = True Next ListView1.SetFocus End Sub Private Sub Form_Load() For a = 1 To 20 ListView1.ListItems.Add , , a …

Try something similar to - Dim cnCheck As ADODB.Connection Set cnCheck = New ADODB.Connection Dim rsCheck As ADODB.Recordset Set rsCheck = New ADODB.Recordset cnCheck.CursorLocation = adUseClient cnCheck.Open "provider = microsoft.jet.oledb.4.0;persist security info=false;data source = " & App.Path & "\MyDatabaseName.mdb" rsCheck.Open "SELECT Field1, Field2 FROM TableNameHere WHERE Field1='foo' AND Field2='foo2'", cnCheck, …

In your popup application you need to use a timer that will check the database for new records. First assign a value to the current recordcount in your database. When the timer runs, it will check against this value. If the value changed - bigger = new record, - lower …

You need to install the "Crystal Reports Runtime Engine" from the following address: [here](http://www.businessobjects.com/jump/xi/crvs2010/us2_default.asp) Download and install either the 32-bit or 64-bit depending on your OS and your Application you are trying to run. This will have to be done on each client machine that wishes to run your application. …

Agreed, seems that William is not as bright as we thought.

Declare your "n" value in a module - ''In a module... Dim n As String ''In Form1... n = Text1.Text ''In Form2... Text1.Text = n

This is a vb.net question. I have asked the mods to move it there... Your error occurs because you are looping through "intNum" but the last loop can not find the number. Remove the -1 at the start of your loop, should be fine then. For intNum = 0 To …

First error, in row 60 (last) you have rsVehicle.Update again, after you called the update on row 43... Show me the code where you select the record from database BEFORE setting the datasource of your flexgrid. Your error lies in the selection, you need to show the grid what to …

In your grid its quite simple... DataGrid1.Clear Getting to your deleting of all records, are you sure that is what you want to do. Why set up a table, add data to it just to delete it all again? Why not just delete the records you don't want anymore....

Grabbing the inner text from a web page means that you are grabbing ALL of the source code contained within it. a List view is to display certain values in different coloumns. You need to get a value from say a textbox on webpage, bind it to a string value …

Show me the code you have where it calculates the sum.

Go to your friends Google, Bing etc... Have a look at [this](http://www.pbdr.com/vbtips/gen/Article-UsingFlexGrids(2).htm) link for sample code on a flexgrid...

It works much faster and less error free when you grab the values from your database using Active x Data Objects. First you need to do the connection, then set a recordset and open it. Then based on your requirement (daily, weekly, monthly) loop through the records to return the …

Guys, ladies and so on, please note that this thread was started 2 years ago. I'm sure that the OP has found a solution by now, please do not raise the dead.;)

Your code looks fine. What error are you getting and where?

Divine, I think we are confused with the exact sums involved. I'm quite good at excel macros, even I'm stumped. ;) Try and attach your worksheet and I will play with it. The only way I'll be able to help you get a solution.... I need to see what the …

You would use something like - Sub FormatNow() Dim myWorksheetName As String myWorksheetName = Format(Now, "mmmm_yyyy") MsgBox myWorksheetName End Sub

Poster does not even answer, seems like a dead post to me. :)

What error do you get and on which line?

We will need much more information... which database, what tables, append which fields etc.

I prefer to do it the following way because of a shared recordset... Private Sub Command5_Click() Dim cnGrid As ADODB.Connection Set cnGrid = New ADODB.Connection cnGrid.Open "provider = microsoft.jet.oledb.4.0;persist security info=false;data source = " & "G:\ShopManProject\" & "\dbShopMan.mdb" cnGrid.CursorLocation = adUseClient ''or adUseServer depending on your connection... Dim dbRecordset As …

Nelson Mandela, took South Africa to new heights, dissolved apartheid, Combined ethnic groups as one united ed nation, got the entire world to look at us with a new perspective.

It seems that you have the incorrect version installed under your system 32 folder... Have a look at [this](http://support.microsoft.com/kb/889114) link for a solution.

Have a look at [this](http://serverfault.com/questions/82007/how-do-i-get-this-sql-server-odbc-connection-working) link or the google search with error 17 [here](https://www.google.co.za/search?q=sql+server+doesnt+exist+or+access+deined+sql+state%3A+08001+Native+error%3A+17&oq=sql+server+doesnt+exist+or+access+deined+sql+state%3A+08001+Native+error%3A+17&sugexp=chrome,mod=9&sourceid=chrome&ie=UTF-8)

> Also this code is only printing the first row data That is becuase you are not looping through all the rows in the grid... Dim xQuantity As Integer, xPrint As Integer, PageNo As Integer Dim strCode As String, strPrice As String, xRow As Integer ''Added xRow above... For xRow …

HibaPro, this is your 4th question about the exact same error but with a different object. Surely you must know by now how to solve this, we can not go through your (which I still suspect to be someone elses code) entire application with the same error. Have a look …

The value returned by HourWorkedTextBox.Text is not an integer. It seems you are returning something between 5 and 60, which is an integer. the textbox is returning something else...