Search results

I managed to fill a combobox through code: cbo.AddItem rs.Fieds("field") Problem I have now is that I need to have 4 columns, the code above will only give requested field. If I use & sign it will add the fiels, however in the same column. How can assign fields to a specific column? Thanks...

Yes you are right, however I am dealing with a SQL Server Dbase and this does not allow me to filter a query with [Forms]![Formname]![txtfield]. I need to build a query that will filter on CustomerNo, that is chosen on a Form. Dirk.

I want to fill a combobox from a recordset. I building the required records in a recordset. Now I need to get the data in the combobox. I know the AddItem method, but do not know how to use this with a recordset. Dirk

In my referencelist I have the following checked: - Visual Basic for Applications - Microsoft Access 10.0 Object Library - Microsoft ActiveX Data Objects 2.5 Library - Microsoft DAO 3.6 Object Library - OLE Automation - Microsoft ADO Ext. 2.8 for DDl ans Security - Microsoft Visual Basic for...

The previous line contains: Dim rst As DAO.Recordset Dirk.

I have problems with the line below in my Dbase: Set rst = CurrentDb.OpenRecordset("SELECT * FROM tbl_BA_Deb WHERE Debiteurennummer = " & Me.cboDebiteurennummer & " ORDER BY Debiteurennummer", dbOpenDynaset) Every time I open de combobox and select a customer, it comes with the error 91...

Thanks for the help, works fine.

I know that solution, but the existing DBase is using the same table as I am going to use for the form. Is must be numerical. The field is customernumber, which we choose by a combobox, the combobox is build from a query in which is the customernumber, name, address. If you choose the desired...

I have to make changes to an existing Dbase. Problem is that in this Dbase it is on one form possible to put text in a numerical field. I need to do this again, however it does not work, Access gives the message that Text will not go in a numerical field. I am talking about a combobox. What...