|
Hi,
I am working on an existing vb 6.0 application. i get this error
"multiple step operation generated errors. check each status value."
I am getting the the error at execution of if condition, where data in recorset field is null and TEMP_BIDDEADLINE is "1/1/1900". This code was supposedly working fine till now.
If (NVL(mrecFundData!bid_deadline, dt) <> TEMP_BIDDEADLINE) Then
'''do something
Else
''do else
End If
Any suggetions or solutions will definitely help.
Regards,
Gaurav
|
|
|
|
|
What you have is an "there are errors" error message, which doesn't say anything at all by itself.
The connection object has an Errors property that contains a collection of ADODB.Error objects. Examine each error message there to determine the cause of the error.
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
This means that the Length of the value inserting in the table column is more than the column definition. You have to check the column length and Data Length
Dana
|
|
|
|
|
I have the following displayed in textboxes:
Price: 1.8 Quantity: 6 , and the item (pencil) relating to the purchase in a combolistbox
How do i get this three bits of information in one line of a listbox:
e.g 6 pencils $1.80
|
|
|
|
|
You should use ListView Control instead for such output. Add a ListView Control to your form then change its 'View' property to 'Details' then add columns to its Column collection according to your requirements, use the SubItems property of Listviewitem to display the data for Sub columns.
AliAmjad(MCP)
|
|
|
|
|
I am not familiar with the ListView control, would you be able to clarify or help with the listbox control
|
|
|
|
|
I have told you the way of setting up a ListView control according to your requirements, use Property window to add columns to your ListView Control through its Columns Property after setting these values you can use the following code to fill it:
Dim lstitm1 As New ListViewItem("Pencil")
lstitm1.SubItems.Add("$11.0") 'For Price
lstitm1.SubItems.Add("2") 'For Quantity
Me.ListView1.Items.Add(lstitm1)
Hope it helps !
AliAmjad(MCP)
|
|
|
|
|
Works, thanks for all your help
|
|
|
|
|
How can I the sum of say(Items in a listbox):
6.78
9.05
5.56
4.45
displayed in a textbox with the answer given with 2 decimal places.
|
|
|
|
|
Iterate through the items in a Listbox by using its Items property and use a variable who receives the values and add them then display that variable in the Textbox you can iterate by using For Each loop. You can use FormatNumber function to display values up to two decimal places.
Hope it helps !
AliAmjad(MCP)
|
|
|
|
|
Can you give an example please
|
|
|
|
|
AliAmjad pretty much spelled it out for you.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Dim sum as decimal
for i as integer = 0 to me.listbox1.count - 1
sum += me.listbox1.items.item(i)
next i
|
|
|
|
|
Use Decimal for a variable then, as was said, Iterate through.
Regards
Zeldacat
|
|
|
|
|
I am creating and saving rtf files but I want to be able to put in the Author and comments about each file but I can't figure out how to set these properties in code. Can anyone help me. I appreciate any comments you can give.
|
|
|
|
|
Thanks paul,it worked with 0's and 1's.Now another problem
.This array is loaded from a text file.
when i check two numbers in an array if the numbers is more than 9
say if 9<10 it should go to the inner statements. But it is skipping. for numbers less than 9 ok .It is not sorting
say
4<9 it is going to the next statment and it is sorting
|
|
|
|
|
Paul may be able to make sense of this, but if you only want to make sense to him, you should respond on the thread, so he gets an email. Otherwise, start again. Post some code and explain in a way that makes sense to peopel who didn't see the original post.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi
I need to do aprogram for client and server that enables the server to have controll to the clinet and capture the screen of the client(see the client screen )
So , what are the built-in classes that will help me to do this program ????
Thanks
|
|
|
|
|
There's nothing built in that will do any of this core stuff. There's plenty of classes you can use to write the network communication stuff, and to capture the screen.
Why do you need to write the 1000th version of this program ? It's even built in to windows nowadays.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
because its my senior project ( project we do it before graduation)
i know that there are lots of software that do the same job but i want to do by my self
so i need to know which classes will help me (ex: winsock class this helps )
what are the remote class in VB
|
|
|
|
|
OK, so you want to write a web app, or you want to write a client side app ? If you want to run in the browser, you need AJAX. otherwise, any tutorial on any sort of client server app will be more than enough to help you. There's probably some right here on code project.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Computer-S wrote: what are the built-in classes that will help me to do this program
You can start by looking at the System.Net namespace ...
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi,
I am creating a web app using using VB 2005 pro and sql 2005 pro. When I send my data from the web form to the database it appears as 11/10/2007 00:00:00. How do I stop the time from appearing?
Here's a piece of code where I send to DB
Dim cmd As New SqlCommand("insert into tblDetails(adno,date) values@adno,@date)", conn)
cmd.Parameters.Add("@adno", SqlDbType.VarChar).Value = TxtAdNo.Text
cmd.Parameters.Add("@date", SqlDbType.DateTime).Value = TxtDate.Text
thanks in advance
jono
|
|
|
|
|
The datetime stores both a date and a time. If you don't specify a time this portion of the value will default to 00:00:00. If you don't want to display the time portion of the value in your web app, call the ToString method of your DateTime object with an appropriate format string e.g. dd/MM/yyyy.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi,
Thanks for the reply. I am a complete novice to programming so please bear with me.
I use a bound datagrid to view my database data so there is no VB data behind code.
here is the query the datagrid uses:
SELECT [AdNo], [Date], [Fullname], [Sex], [Tutorgroup], [Details], [Time], [Consultant] FROM [Viewallconsultations] ORDER BY [Date]
How do I use the ToString function?
On SQL server, why isn't there just a date datatype? if I change this datatype to text then my date shows up ok in VB view but this will cause issues if I wanted to sort by date, etc
any more help please?
jono
|
|
|
|