Last post Mar 23, 2015 08:23 PM by JohnBert
Jun 12, 2012 09:00 AM|isi_rajah19|LINK
So i have two tables 1 Reserves which has reserveID,SellerID,ReserveLetter,description.
And the second is AuctionRoll which has a Description,sellerId etc.
I need to select the data from the reserves table,to populate data into the Description column on the Roll
The workflow is as such the user will enter products into the reserves table and for each seller if the seller has more than 1 item will be given a letter(4products= 1a,1b,1c,1d) seller ID will be the number and a will be the letter in the reserves.
Then if the user enters 1a under the sellerID in the AuctionRoll it must select the description in the Reserves for that record.
Oct 21, 2014 04:57 PM|sen338|LINK
I think based on the Enter Text(ReserveID + SellerId) , get those id and write a query like below
select * from Reserves where (reserveID + SellerID) = '1a'
this will pull the data, which u need .
I am just giving you the idea, i think you can implement by yourself
Mar 23, 2015 08:23 PM|JohnBert|LINK
If My.Computer.FileSystem.FileExists("path_to_file") Then
Dim ioFile As New System.IO.StreamReader("path_to_file" + "filename")
If My.Computer.FileSystem.FileExists(OpenFileDialog2.FileName) Then
Dim ioFile As New System.IO.StreamReader(OpenFileDialog2.FileName)