SQL extend a Recordset / VBA DAO etc.

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

  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

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