Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Copy record button does not copy all data
I inherited and am making alterations to an access db that stores prospect bidding information. All of the bidding data is stored all in 1 main table, with supporting tables to hold predefined values for columns in the main table, basically foreign key type stuff. There is a form set up to...- gbankos
- Thread
- Replies: 0
- Forum: Microsoft: Access Modules (VBA Coding)
-
Hour must be between 0 and 23
I am trying to write a report that does a datediff or dateadd, such as: Dateadd("d", 1, {@DateTimeTaken}) < CurrentDateTime. The error message I get is 'Hour must be between 0 and 23'. Now, the formula field I created that is causing the problem is: @datetimetaken...- gbankos
- Thread
- Replies: 14
- Forum: Business Objects: Crystal Reports 1 Formulas
