Search:

even worse. no validation at all...

dg : thank you for your reply. I havent tried your last suggestion, hope that it could work fine :)

See attachment, i cant assign - value

tried dg's and shuja's suggestion. it works fine, except that we cannot declare negative value.... still fails...

haven't. will try it tomorrow, new more important task to do...
anyway,thx for the answer, hope that it will be able to solve the annoying text box filter. hahaha :)

it doesn't work... i cant even assign the "-" sign.. and then, we still can type 000056. by right, it should be changed to 56 automatically.

does it mean that we have to add extra validation to...

i am trying to filter text box, to be number only.

i have found the way to filter the input to be1,2,3,4,5,6,7,8,9,0 or - only.
However, the problem is that user still can input 432-22 (minus...

fast and accurate answer like usual from dg. hahaha..
thx a lot ;)
feel so stupid....

Ah yes !!
i assign the tab index to the "index" property instead of "tab index"...
my own stupidity...
thx for your answer !! =)

Hi guys, i have searched the forum for similar question, but i still cant get a satisfying answer. So, is there any way to "un-select" the combobox with style 2-DropDown list ?

so, i have 1 style...

i am just wondering, previously my program is working fine using this statement :

Private Sub chkHoldLot_Click()
EnableDisableControls ChkHoldLotCheck, chkHoldLot.Value
End Sub


but...

The problem is, i cannot change how the application works since it is not designed by me. This list box is for listing down all the product that we have. Actually, there are some workaround for this...

Hi guys,

I found that the max item for list box in VB is around 32k items (index will be negative if more than that amount). Is there any ways to add more than 32k items in List Box ? maybe use...

Hi mark, You can use a timer to do this. And put your function under the timer. You miss the right bracket :



if image1.left=image2.left then
msgbox ("game over")
end if

I found it !!! since after i try to comment all of the events and it still doesnt work, i try to comment the line with that textbox, and it turns out that in the form initialization stage, there is...

it does not work... i even try to comment all the textbox event, but it still happens.. could it be because of another event ? this is not my code, my role is only to maintain the existing code......

Then the code should do fine, because if no record with the mentioned DetID, then the query will return nothing, which means rs.EOF will be true, and the error message will be displayed.

ah okay, you get a point there... i was thinking to use 1 collection for each, so it means that we will have 5 collections/ComboBoxes. But now after i re-think it again, it is quite troublesome to do...

I have just noticed that comITsolution has highlighted the reason, which is :

conn.Execute SQL

It is missing from your code... and maybe if you want, you can try to review your primary key ?...

Ah okay, but it works fine, doesnt it ?
I dont know which database you use, but i think there is some kind of command to update database, maybe like rs!update ?? or maybe rs!execute ? Sorry, i am...

Maybe he also can use Collection ? or maybe can define ComboBox as a buffer to store all the data ? Because we dont need to define ComboBox.Count, rite ? Is it applicable ?

I think i didnt explain it clearly, sorry for that. the problem is not with the UpDown button, but it is with the TextBox.

The textbox, cannot receive input '-' only, so if i want to type '-100',...

If you still want to use your code, you can just make slight modification to your existing code. Your problem (6 times error message pop up) is because your previous code, will pop up the error...

Nope, i dont think that it is the reason. The min/max value have been set to -99999/99999. I have tried to make 1 new form, that only have Change, GotFocus, LostFocus & Validate event and it works...

Hahaha, so basically all of your advice is for me to learn from forum ? It is a good advice, but sometimes i can only understand several topics. For most of other topics, i am really really lost......

I just want to ask for any advice of which book i should read first if i want to start to understand VB deeper. What i know for now is only the basic thing of VB, so i dont think i will need to go...