There are controls that support database connections.
I think that they are faster than the code that you are using.
You can find it at project/components/Microsoft Datalist Controls 6.0 (VB 6.0)
You have to set the datasource -, datafield - , rowsource - and boundcolumn - properties.
then...
I think that you should fill in the LISTFIELD-property of the datacombobox.
That is the value that apears whe you select a value
I hope this solves your problem.
Maybe it 's a silly remark, but if you use this control very much, why not concider creating a user control that you have to program once and you can use it time after time again.
Maybe it's very stupid what I say but that's something that I would think about.
You could do it much more simple.
You should fill in the 'datasource' and 'datafield' properties in the propertieswindow.
I have don it in a project and it works there.
It is possible to find out the resolution of the screen.
Just use this code.
Screen.Width \ Screen.TwipsPerPixelX & " x " & Screen.Height \ Screen.TwipsPerPixelY
this should give you the resolution in pixels.
Make sure that your boundcolumn is OperatorID
that means that if you use the boundtext property it wil return the value of the field OperatorID.
I think that in your case the boundcolumn is empty or operator
If that is a string and you want to compare it with a number, the compiler gives an...
One way to solve this is to copy the connectionstring into the code and where it states the path
(Data Source=f:\stock\databesename.mdb;...)
replace it with
Data Source=" & APP.PATH & "\databasename.mdb;...)
then you have to delete the connectionstring in the property's
Normally...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.