Recent content by TripperTim

I have a simple form that I am working on, and I would like to have one of the values be equal to True if the form is opened. This particular form is only opened by the user if this value is true, so I don't see a reason for them to click the box if they don't have to. Is it a simple = command...

Sorry for the delay. Had to eat dinner. I realized I needed to add "From theTable" to the end of the code and now it is working perfect. Thanks!!

I will have to apologize for my lack of knowledge, but the SQL code above is causing my Access to crash. I changed "theTable" to my table name, but am not sure what else to change to get this to work. When I try to save the query I get a "Syntax error (missing operand) in query expression...

I am working on a database where different activities are entered in a field 'Time' which I then sum for a total cumulative time. I am using format hh.nn.ss and the total wraps back to 0 at 24 hours. What is a good way to get a cumulative time back such as 38:10:05?

Can someone let me know how to get Access to view Monday as the start of a calendar week (european calendar) instead of Sunday (american calendar)? I know in Excel it is a simple parameter in the formula, but this is my first try in Access.

Can someone let me know how to get Access to view Monday as the start of a calendar week (european calendar) instead of Sunday (american calendar)? I know in Excel it is a simple parameter in the formula, but this is my first try in Access.