Date problems
May have problems using =Date() for a default value and in using date() in queries, forms or reports gives an error message of #name? or Function isn't available in expressions in query
expression'Format ([Register Date],"ddmmyy"] = Format[Date(),"ddmmyy"])'
Using =Now() may work but inconvenient as includes time.
pop up the Debug window and check these functions work well there. Even a module may not be referenced in a query, report or form try to recompile all modules, including in forms where
Access Basic may be hidden away in command buttons (look at the design of a button by pressing the three dots by the onclick event)
It may be caused by having a field called date- a reserved word- rename the field
If you receive an error message such as "Undefined Function" or "Function not available in query expressions," you probably lost some of your library references when you last upgraded. Open a
module (if you have no modules, go to a form with buttons and look at the Access code, or click New on the Modules tab) and select References from the Tool menu. Check the listing in the
Available References control. verify you have (the following apply to Access 97):
Visual Basic For Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.5 Object Library
Microsoft Common Dialog Control 5.0
Microsoft Windows Common Controls 5.0
If you find one tagged Missing, uncheck it. From the Debug menu, choose Compile and Save All Modules. This should resolve your missing references.
Similar to above:
1. On the Modules tab, click New.
2. On the Tools menu, click References.
3. In the References dialog box, pick any single reference that is not already selected, click to select it, note which one you selected, and then click OK.
4. On the Tools menu, click References again.
5. Click to clear the reference that you selected in step 4, and then click OK.
7. Rerun the query, the form, or the report on which you saw the errors mentioned to see if the problem has gone away
Blijkt te werken
:thumb:
