Recent content by Anthrax

Thanks, solved it. The reason I'm wanting to change the data type is because I want to stay away from calculated.

I am trying to change the data type of a field in a table from calculated to something else. It gives me the error "this data type cannot be changed once the field has been saved" Is there any work around to this? If not its not the end of the world.

One more question, how do I get historical dates to show up so I can input old data all at once? What I mean is that its more rare for an employee not to submit a time sheet so I want it do default to showing up as submitted.

That was helpful in getting a few things sorted out but I'm still confused as to why I don't need the Boolean field. How would somebody mark whether or not a persons time sheet was submitted? EDIT: never mind after looking at it and inputting data I understand why. Thanks a lot.

The project I am currently working on requires me to build a database for checking off if a certain person has submitted a time sheet for a certain date. I have a table for the dates that has the fields "date" and "Submitted time sheet?". The time sheet field is a checkbox. I also have a...

Id really like to normalize the database better, trust me I would. I really am just having trouble meeting the functional requirements that have been given to me with a properly normalized database.

I have a button in a form that brings the user to a table to add a new record. I want the feild of "dates" to be automaticlly populated with a value that is 7 days after the previous date in the feild. the code i have currently is Private Sub Command14_Click() DoCmd.OpenTable "Cincinnati...