Posts by debasisdas

ehe he he :D

now the gal is in trouble

translating non-english english to queen's english.

Then, you are off topic .

That is considered thread hijacking.

Yes, it has to be done through SQL queries by placing some extra controls like a pair of combobox and textboxes on the form.

Expecting the world to treat you fairly because you are good is like expecting the bull not to charge because you are a vegetarian. ~Dennis Wholey

Oh god ...oh god ...oh god ...oh god ...oh god ...oh god :scared:

Argentina, Brazil......:-O

Some one please tell him ICC does not organize soccer.

Hi Philip,

Welcome to daniweb forum.

so what is the problem ?

are you facing any issue with the code ?

You need to read this .

35600 index out of bounds

which line ?

show some effort ans show the code that you are working on.

Table ?

Which table ?

654

6 5 4

654

654

you need to insert a page break after each record.

652

try this sample

Dim C As ColumnHeader
 Dim i As Integer
 For i = 1 To 4
 Set C = LV1.ColumnHeaders.Add()
 C.Text = "Field" & i
 C.Width = LV1.Width / 4
 Next i

@Dani:
great job.

I can only imagine how fast you cooked it. :D

If you read the root post of this thread carefully, soon you will realize the question was to create a command button at run time and then change the color property.

650

650

650

648

646

646

and i am with a trigger.

640

640

640

You need to read this and this.

As i have already suggested, yuou may need to use some third party control.

That's what i am trying to explain to you. you can't handle the windows key in VB. But can still handle some of windows + key combination through API calls.

In form laod

Combo1.AddItem rs("itemcode")
Combo1.Itemdata(Combo1.NewIndex) = rs("description")

on combo_click

text1.text = combo1.itemdata(combo1.ListIndex)

Only the 1st one.

As i mentioned you can't handle the windows key but can call some of the API to handle some of windows + key combinations.

The problem is because of the software of the scanner (may be the driver) is corrupted. Try to completely re install the software of the device.

Also check if the reference to the scanner components is removed accidentally from Project---> references

is that code not working for you ?

what you want to display if item code is not assigned .

Instead of displaying from multiple tables, create a view based on your desired logic and pull records from the view to display in the application.

Hi Cathy,

Welcome to daniweb.

You should not hate cricket, specially when the cricket world cup is going on.

You can't handle windows keys.

alternate method:

Use the item data property of the Combo Box.

populate the combo like this

Combo1.AddItem rs("itemcode")
Combo1.Itemdata(Combo1.NewIndex) = rs("description")

and display the Itemdata property in the textbox.

No, not in any grid directly as is as in Excel sheet.

640

and even worse cricketing knowledge :twisted:

634

Because South Africa has a lot of countries and a lot of countries would want to send their own teams.

:D :D :D :D :D

Bad bad ...bad geography.

620

check if you are trying to put a string into a VARCHAR field that is too long.

Yes.

That should work for you.

620

I am a Sleepwalker.