from the question. i take they want it to work if any of the conditions = a b or c. if thats the way it works then yes the first if statement will work

yes that will work the way you want.

you grab its text.

"UPDATE product_line set qtydb= qtydb + " & qtydba & " WHERE product_id = " & productid & "",

ok we need to set it where the productid = the productid

"UPDATE product_line set qtydb=" & qtydba & " WHERE product_id = " & productid & "",

my mistake

in your query you are only pulling from one table. i guess its throwing me off. what are the fields from the other table you are using? can you test your query in your db's query analyser?

if you are pulling data from one table only why use the join?

"SELECT UserID, Role FROM tblRoles where UserID = '" & roleUserID & "'"

scanners do the same thing as a keyboard. read from the barcode and places the text in the program. thats about it

try this

"WHERE [tblUserAccount].[UserID] = '" & roleUserID & "'"


single quotes around roleuserid

okay lets see what we can do ;) lol. so you get the data from the product id. you are updating the table with the values in txt boxes? if that is the way your are working it lets try this.
...

what are you using to connect to the DB? i am guessing something like this:


Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset

Set cn = New ADODB.Connection
cn.Open 'connection string...

cant step through and see where the hangup is?

once you have your rs setup you can do this

Do Until rs.EOF
Combo1.AddItem rs!Field
rs.MoveNext
Loop

that redline means that you are exceeding the report size. in your designer if you will widen from 7.5 to 8.5 you should be okay.
and that bottom is because the active reports is an evaluation copy.

if it is a specific item you are looking for why search through mulitple records?


sSQL = "Select fields from table where id = " & productid & "


then you can run your do while.

sorry for the delay in getting back. had other projects that had to be complete.
thanks for all of your help.
not sure why i had the problem in the first place because that code is working now....

after looking at my posts i see how it is confusing.
what i need is to set the text of the cbo to the salerep name (works already). I also want to set the rphid to the text. so when the user...

this is connected to sql 2000 db. it is not solved as of yet.

the with statement contains about 150 lines of code so i didnt post all of it. the .salesrep is the id that is set in the table to associate the salesperson to the product. The .salesrep is pulling...

I am having a small problem locating any information on this little problem on the net so I am coming here for help AGAIN.
I have a VB6 project that has a combobox. This is needing to display data...

sorry that should be

checkstock = ( val(rs!pstock) - cint(textbox2.text))

you should see a button that says solved

did this problem get solved? if so mark it as solved so if others run into a problem then can see the solution and create another thread for a different problem

sorry about that take out the first order by srno and that should fix it

rs.Open "select srno, productname, qty, unit from mrtemp where req_no = " & strlistrequest & " order by srno", con,...

try changing the query to

rs.Open "select srno, productname, qty, unit from mrtemp order by srno where req_no=" & strlistrequest & " order by srno", con, adOpenDynamic, adLockOptimistic

is there an error number with that?

need to add & " after strlistrequest

what type of DB are you connecting to?

it looks correct for checking if the value is less then 0 or if it is null.
if you want to check the value from the text box then you can add another if statement. also you may want to change if the...

go here. http://www.vb6.us/tutorials/formating-dates-and-times-vb6
it gives different date formats and examples

Found my problem. I was passing 4 params. I found an article on Parameter Sniffers in 2005 SQL. Once I added another set or params with an existing value it all worked great.


@param1 int,...

I have a Stored Procedure that is called through VB6 for a report. The Reports were working great until yesterday. Now all of the reports that use that sp are timing out. The default time is set to...