Type: Posts; User: DataMiser
Search took 0.30 seconds.
February 2nd, 2016, 11:52 PM
You would just need to add the correct number of hours to your current system time. I'm not sure what the difference is to Hawaii, 6hrs maybe? Should be easy to find out with a quick internet search....
February 2nd, 2016, 10:32 AM
Well I told you what function to use and showed the syntax. Have you tried it?
What did you try? What result did you get?
January 29th, 2016, 07:42 PM
Probably because you are doing both concatenation and addition using the + sign on the same line. As a general rule always use & for combining strings and + only for addition. Also should always use...
January 29th, 2016, 04:17 PM
hmm to bad there is no way to display the actual query when using the method you are using.
Just for the sake of trial try this
cmd.CommandText = "select isnull(max(increment),0) from forma...
January 29th, 2016, 03:26 PM
Did you try changing the case in your query to match what is actually in the DB?
Is it possible that there is a space or other character in the textbox that is causing the query to fail to find a...
January 29th, 2016, 10:59 AM
You should set a break point here
If maxrptnum = String.Empty Then
then check the value of maxrptnum to see what it really is
Sounds like it is not getting a value from your query.
January 29th, 2016, 02:08 AM
What is the value of the increment field in the db? Is it a numeric field?
Have you set a break point to see if the query ever returns something other than an empty string?
You really should...
January 28th, 2016, 11:00 AM
I have not really did much with data tables in VB.Net but I would think searching for something like working with data tables in VB.Net would return some useful results.
January 27th, 2016, 06:36 PM
Well I do see a few places where you are assigning a string to a numeric field there so one of those could be causing the issue. I have saw this happen using a money field where the value was a...
January 27th, 2016, 06:24 PM
I'm not sure what replacenewlines would do but if it replaces them with anything other than the <br/> tag then that is not going to work and is going to stop the other line from working as well.
January 27th, 2016, 11:52 AM
It looks like you are having an issue with a listview control rather than that combo control.
Be aware that most VB6 controls do not support unicode
January 27th, 2016, 11:50 AM
The error message will generally show you a pretty good hint as to which field it is. I have ran into this same error recently. While the error message did not state the field it did show the value...
January 27th, 2016, 11:44 AM
It is very simple, you just need to replace the CRLFs with the proper html tag before or as you place it into the html.
I asked if you know how to replace them but you did not really give an...
January 26th, 2016, 07:21 PM
So does that mean that it actually has CRLFs embedded in the text? You say that it is multiline which would indicate that it does but textboxes do word wrap so must be sure.
If there are CRLFs...
January 26th, 2016, 02:34 PM
Well, is the text truly multi line to start with? Meaning does if have CRLFs in it or is it just using the word wrap feature of the text box?
If it has CRLFs then you could replace those with the...
January 25th, 2016, 02:33 AM
You can simply append an empty string to the result returned by the query to avoid getting an error there but then your next line will also have to be changed as it will never be dbnull at that...
January 19th, 2016, 02:15 PM
Moved from VB6 to VB.Net forum
January 17th, 2016, 11:30 AM
Have you tried setting break points in your codoe to see if the click event is being called?
January 17th, 2016, 11:27 AM
Create a new project in the Vb IDE
Add a treeview control to it if possible then save the project.
Open the vbp file of both the new project and the troublesome project with notepad
January 17th, 2016, 11:23 AM
How are you calling the function from code?
Which function is giving the error?
Have you tried using the debugger to locate which line is throwing the error?
What OS are you using?
January 12th, 2016, 08:32 AM
The function you are looking for is Name
Name Source AS Destination
Would most likely need to use run as administrator also since it is in program files
January 6th, 2016, 10:13 AM
I see you renamed a dat file to mdb.
Is that dat file and actual microsoft access mdb or is it some other format?
You can not just rename a file and expect it to magically turn into a database....
December 24th, 2015, 08:48 AM
In this case it denotes a filenumber
Open FileName For Input as #x
December 16th, 2015, 09:26 AM
It is hard to follow what you have there in the OP and I am not really sure what it is supposed to be doing.
I assume those vars you are referencing have been defined in the proper scope and...
December 16th, 2015, 09:12 AM
What is it you are trying to set? =() is not a valid assigment
Click Here to Expand Forum to Full Width
This is a Codeguru.com survey!