Search results

I think it's better that I explain what I want to do from the beginning. I'm constructing a database of suppliers and the fisrt option for the user is to select which supplier in a combo box to be illustrated. After that the user should get the oppurtunity to choose between displaying a specific...

I use Access 2002 and DAO 3.6 object library is loaded. Thanks anyway!

Forgot the code!! Private Function AddAllToList(C As Control, Id As Long, Row As Long, Col As Long, Code As Integer) As Variant '************************************************* '************** ' FUNCTION: AddAllToList() ' ' PURPOSE: ' Adds "(all)" as the first row of a combo box or list box...

Actually I don't know! This error occurs when I open the form containing the combobox. The thing is that I have used the function AddAllToList from microsoft's support and tried to modify the code to work with a query as rowsource instead of a table. Before the modifications I got an Error...

Can someone please help me to find the errors in my code. I've used the following code: Private Function AddAllToList(C As Control, Id As Long, Row As _Long, Col As Long, Code As Integer) As Variant Static DB As DAO.Database, RS As DAO.Recordset Dim PRm As Parameter Dim Qdf As QueryDef '...

I have a minor problem that makes me frustrated! I have managed to add All to a combo box when using fields from a table as rowsource. However, I want to use fields from a query instead and this causes an error: Too few parameters. Expected 3. Any help on this issue is welcomed!

I have a minor problem that makes me frustrated! I have managed to add All to a combo box when using fields from a table as rowsource. However, I want to use fields from a query instead and this causes an error: Too few parameters. Expected 3. Any help on this issue is welcomed!

Thanks allot! However, when I now try to view the Combo Box in Form view I get an error displaying "Type mismatch". Why does this error occur? Please, help me!

I have problem with the AddAllToList function, related to issue Q128881 in the knowledge base. I haved followed the instructions, but a problem occurs when I try to compile the module. I get a compile error: User-defined type not defiened on expression: Static DB as Database I'm using Access...