SQL extend a Recordset / VBA DAO etc.

by | Sep 17, 2014 | SQL, VBA

Sometimes you will get a problem if you want to add a data entry to a recordset, it can be done without the need of inserting the data entry to the table. It is a little bit tricky but with a union statement you can do following: your normal statement looks like:...

Microsoft Office Performance

by | Jul 27, 2012 | Microsoft Office, VBA

  Over time or after installing new programs, you may notice that an Office product has become slower. It is also possible that an Office product behaves strangely, e.g. in Word an hourglass appears after every typed letter. ...

VBA runtime error 91 or 1004

by | Jul 24, 2012 | VBA

Error messages: Object variable or with-block variable not set Object not found Remedy: Sub Example() Dim objExample As Object Set objExample = Nothing If objExample Is Nothing Then MsgBox ("") End...
en_USEnglish
de_DEDeutsch en_USEnglish