Suppose that the second form is named frmSecond and has a Textbox named txtInput. The first form has a Command button named cmdFillInput.

I'm pretty sure that you can use:

Public Sub...

How did you display the return value?

Oooops. I was right about the name. http://www.xbeat.net/vbspeed/

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.

The easiest way is to use the Format function.

Format(expression[, format[, firstdayofweek[, firstweekofyear]]])

Use something like:

Result = Format(VariableName, "##########.00")

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

Do you want the code for the random date generator, or changing the DueDate Column, or both?

The random date generator could get messy, but I'll see what I can do.

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

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...

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...

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...

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...

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.

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 for a database?

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...

Hmmm Oracle connections are complicated. I'm not sure this is the place to ask for something that specific. Try some research on ADO, but most of the examples will be for connecting to Access or SQL...

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...

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...