mboley370

I would like to start out to say that if this isn't in the correct forum i am sorry.

I am starting this small project for work.

This is the problem. Right now the company i work for uses manage more for invoicing. When a web order is placed there are items on the page that need pasted into manage more invoice feilds, however when we paste them over you need to tab every time to make it paste the next part of the string. So in other words it will not paste tab into the boxes.

I would like to make a program that will allow me to paste the full string into each box feild, so in other words when i past the first part of the string into the first box it will fill all 3 parts of the string in so that we don't have to hit tab every time to get it to go to the next part of the string.

There are 3 parts of the string so it would have to tab 3 times 1 for item 1 for item number 1 for item price. RIght now when we click an arrow next to the item info it saves the string of info into txt file and then when we paste it, it wont paste what we need to tab.

My problems are i don't know the field names in the manage more invoice, so it has to be done by a txt feild of some sort unless someone can think of something else.


I am not asking someone to do this for me i am just asking how would i start such a project. I am a bit new to vb.net however i have taken 2 classes for it. I can build windows based apps and so on.

If anyone has any suggestions i would very much appreciate it. If you have questions please ask me i will try to be more specific in a certain area.

3321thec

With respect to the text you are pasting, if the text is a fixed amount of characters (ie xxxxxxxx every time) you could write some code to split the string into the 3 text boxes.

I would give an example, but I am pushed for time right now (got homework).

With regards to the inserting this data in the database (I'm assuming thats what you want to do), you need to find out a bit about the database schema (table names, field names ETC)

I'll see if i can get an example made.

Best Wishes,
3321thec

mboley370

That is my problem i dont know the feilds because we didn't make manage more it was software we bought. So i don't know how to go about finding those feild names since i can't view the code.

3321thec

If the database is hosted on a local server, you can try the SQL Management Studio Express Edition(assuming it is MS SQL). With this you can log in to the local server, browse to the database, and find all table names field names, data ETC....

Best Wishes,
3321thec

mboley370

Ok, i will have to do this.

Thanks

Matt

mboley370

Well lets say i just wanted to use a mouse click to click in the feild so i don't have to find out the names of the boxes. How do i paste something outside of the form i made.

For example the code below will allow me to grab whats in the clipboard and paste it only in my form, how do i paste it anywhere in any program i want to?

I first have to capture and be able to paste it in 1 box before i split the string up into 4 sections and then paste it.

If i can just get it to paste i will just split the string by telling it to tab when needed to.

Private Sub mnuEditPaste_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles mnuEditPaste.Click
'Retrieve data from clipboard and place it in text box
Dim oDataObject As IDataObject
oDataObject = Clipboard.GetDataObject()
If oDataObject.GetDataPresent(DataFormats.Text) Then
CType(ActiveControl, TextBox).SelectedText = CType(oDataObject.GetData(DataFormats.Text), String)
End If
End Sub