Wow so trying to help private programming businesses with this information gives me a bad post. Guess i wont try to help anybody here.

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.

Hello,
I have been coming to this site for help and to add a little of my knowledge. I found a great promotion from Microsoft. This is called BizSpark. I wanted to share it with the community that...

I am wanting to display the PC's System Directory in a treeview. I have been searching for how to do this for some time now without finding anything. if anybody can help me out i would greatly...

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 & "",

This could be caused by many different things. Did you receive any error messages? Has the problem repeated? What were you doing when this occurred? There are many questions to be answered. My...

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 & "'"

called dell to get pricing on another graphics card. $550!. so they offered an extra year warranty for 150. i bought that right up and off my laptop goes to dell to be fixed. that works for me :)

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

i was afraid of that. not sure how much dell wants for one but i am sure its over 300 and i can get a new laptop for a little more then that.

i have no mouse connected. i have no operating system on the hdd. when i try to load windows after the files are loaded the computer freezes. when the os was on the hdd i could not reach the recovery...

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.

i have tried everything with this machine. i have removed the hdd and tried to boot with ERD and UBCD4W. nothing has worked. freezes at the same place every time. have even tried to put vista back on...

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.

I have a dell inspiron E 1705 with a nvidia geforce go 7900 gs. I believe the problem is with the graphics.
I have recently downgraded from Vista to Xp pro. Everything worked great for the first 10...

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

I am a little rusty at this but i think if you change the uid and pwd to "Uid=" & username & ";pwd=" & strPw & ";" you should have it

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

there may be another way but off the top of my head you can use "or"

SELECT id FROM dtlstbl WHERE refid = 1 OR refid = 2

actually i just did a quick search and found

SELECT id FROM dtlstbl...

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

have you tried to boot into safe mode? If you will do that and then take note of where it dies when loading and let us know.

Your missing your join from.

SELECT product.product_id, product.product_description, price.price_list_id from product join price on product.joiningfield = price.joiningfield where...

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

I have a raid 5 that I am attempting to setup. They firmware is Symbios and while in post I can view the drives and set them up to work on boot. The NVRam is active. Now when I boot the machine the...

only one field is displaying? if this is the case you need to add another listbox add to the loop

While dr.Read()
ListBox1.Items.Add(dr(2))
ListBox1.Items.Add(dr(3))
End While

took a quick, very quick look. to add the condition you need to finish the WHERE

cmd = New OleDbCommand("SELECT * from UMP WHERE ", cn)
'to
cmd = New OleDbCommand("SELECT * from UMP WHERE field...

that would have nothing to do with static or dynamic ips. does your router have a firewall?

msn messenger is a stable chat app. if somebody sends you something you have to accept it.

Are you using textarea?