Nasty runtime errors over Date()

March 10, 2006

To put the long story short I was finishing up some VBA code on an Access database project. I have been wrestling with a few problems at the beginning, largely arising from how to write If Statements effectively…(I am a still a newbie at this stuff), but I have been able to get the code running.

However this particular time, I hit a runtime issue when i pressed a command button. Basically the code updated some fields in the tables. I was scratching my head wondering why it gave such errors. Eventually I happened to notice that there were two records. Thats funny I thought. This form I am doing is suppose to be unbound, yet it says that I have two records.

Then it hit me. The record source was bound to a table, so I took out the record source, and hey presto its working. I’ll dig up the run time error I was experiencing for your benefit. 🙂


Started afresh

March 3, 2006

This is my the new site for my discussion on anything relating to computers, electronics toys, and gadgets. I will be discussing my experience with Microsoft Windows based products, Apple as well as opinions and perspectives.

Hello world!

March 3, 2006

Welcome to This is your first post. Edit or delete it and start blogging!