rstkw

The easiest way is to use the Format function. Format(expression[, format[, firstdayofweek[, firstweekofyear]]]) Use something like: Result = Format(VariableName, "##########.00")

A module is just a container for procedures, functions or global declarations. All of the functions in all modules in a program are visible/available to be run from anywhere, unless they are declared Private, which, as I understand it, means that they can only be run by procedures or functions …

This is from VBHelp. If you use an error handler, I would suggest that you disable it, as in the example, because Kill can generate non-fatal errors. For instance, the file the example tries to delete doesn't exist. Public Sub ErrDemoSub() On Error GoTo SubHandler ' Error trapping is ' …

Or you could try the KeyPress event and count the number of decimal points.

I wrote this for someone else but it will work for you, except it adds a random number.

[QUOTE=smile4evr;677245]please can u help me with all basic VB coding like... if command button is clicked from one form how can i link it to another form in the same project and a few examples of simple codings at the basic level... thankx a lot![/QUOTE] Suppose that the second form …

I'm not sure why I want to do this, but it seems like I used to know how. Now I cant get it to work. The code would be something like: Public Sub FormattedString() '*** I want to break the string up into an array of '*** characters and reverse …

There is a website that makes highly optimized VB code available. Something like VBSpeed or something like that. Does anyone have a link to it?

Any time you use a timer, put a DoEvents in the loop. The timer object is basically unreliable. There are better substitutes.

[QUOTE=vbdave;712653]Hi, I need a function that would randomly update the orders due date in the table (orders). I would like to input a starting date and a range (30,60, Etc.) in a text box and have the function randomly create dates based on the start date and within the range …

I think that the Mid Function would be your best option.

There's another problem you can run into that will give a Null error. If one field is empty there is nothing to concatenate. So how do you check for that? If you read the textbox into a text variable and check for Null, it will never be Null because it …

What are you trying to do with the strings? I don't open other people's code, either. VB can handle strings up to 32767 characters fairly fast if the algorithms are optimized. Beyond 32767 characters you need to use something like C. I've tried it and VB6 can get lost when …

I think you are headed in the wrong direction. What database are you using? With MS Access all I had to do was change the database properties and possibly add a locking parameter to the connection string to allow several people to use the database simultaneously from different computers.

I had to do this a while back. Use the COM object and it is trivial. I may still have the code I used, but check out the COM object while I am looking. You might be able to do it better than I did.

[QUOTE=bruce_geo75;721232]i dnt need any code on a plate.i need some advises hw to make codes.i need help hw to make programs.thats all.thanx 4 ur replay[/QUOTE] I've found that, if I don't have a goal, I flounder. What would you like to do? Process file? Do abstract mathematics? Build a frontend …

[QUOTE=asaness;719527]i dont know how to post a question so that, i can create my question in this link... my question is all about how to create an oracle code database in vb6, im a student and beginner programmer...[/QUOTE] Hmmm Oracle connections are complicated. I'm not sure this is the place …

I have a degree in engineering. I spent 16 years in the military. I never liked computers until I built one. (Remember DOS 2 and the NEC V-20 processor chip?) I spent 10 years as a controls systems engineer, which, in my case, meant programmer. Visual Basic was forced on …