Recent content by BartekSollie

Hi, Could someone give me any idea to solve this problem: When you enter, for example, this date 40-Apr-06, the has to come a msgbox with a message like this: incorret date or daynumber is'n possible. Can i do this with vba idate() or datepart() Any idea is welcome, to solve this.

SQL statement Table1.NR and table2.NR Try this one, SELECT Table1.NR FROM TABLE1 WHERE (table1.nr NOT IN (SELECT Table2.NR FROM Table2)); The results are de different values of NR, except for the values (a,b,c and d)

Could someone solve this problem for me. I want to insert a SQL result into a declared string variabele. In Oracle it is posible and i dont have find it out yet with vba. In Oracle the statement is like this ** sample code DECLARE strNumber NUMBER; INSERT COUNT(*) INTO :strNumber WHERE etc. **...

When, id do press the 'RecordWeergeven' button, Microsoft Visual Basic returns with a error. Method or data member not found. I think the error is located bij Me.Keuzelijst0. Do i have to declare a Listbox or create a second recordset. Please help. Private Sub RecordWeergeven_Click()...