![]() ![]() ![]() You developed your database in a particular version of Access and cleverly had it interact with another application such as Excel or Outlook. That’s just Access teasing you and trying to throw you off the scent. It turns out that the problem isn’t the Date function after all. Even more confusing is that it doesn’t necessarily happen on every machine. Everything works fine so you roll it out with your client or colleagues and suddenly find that the Date function throws up an error. You have built your database with liberal use of the Date function in calculated fields on forms, in SQL in queries and in VBA code. In those days the Internet was new with little help available so if you had a problem you pretty much had to fix it yourself, not always an easy task especially when Access presents you with some very misleading clues. “Why Doesn’t the Date Function Work in My Access Database?” When I first came across this problem, many years ago as a novice Access programmer, I was really stumped. Here are some recent answers to a variety of questions: Fixing the Access Date Function Welcome to FontStuff – your source for Office tips and tricks. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |