Calendar View in Access Forms

[enfinity]

Hi *,

At the moment, I'm working on a data entry form that lets the user input data in a calendar format. I attached a screenshot of the design I'm thinking about.

As you can see, I would like to be able to present a view of the current month. Here the user should be able to directly insert the hours worked on a specific project.

Seems like quite a complex task to accomplished. Maybe someone in this forum did something similar in the past.

Thanks a lot!
Steve

 

[Oldsoftboss]

I have seen several poor examples of similar things in access, but nothing as detailed as your screen shot. If this could be developed to a usable level, then you would be on a real winner.

Dave

 

[dreamdelerium]

yeah, its doable

yeah, i created a calendar similar to that awhile ago. it took a long time. then, some a** hole stole my laptob anywho, i had the calendar attached to a table so appointments could be stored, settings saved, etc. although i dont have it anymore, i still remeber a lot of what i did. let me know if you have any questions.

 

[Oldsoftboss]

I hate it when "some a** hole stole my laptob"

PS: what was the password again

 

[enfinity]

Thanks for the sample! It looks like I can actually use a lot of it!

One more question about the input2000 database:

When I try to insert a new entry into the database, the system gives me the following error message:

Syntax error in date in query expression '(([tblInput].InputDate=#01.06.2008#)'.

I guess that is a problem related to the different time formats around the world. In Germany we use DD.MM.YYYY. Is there a way that I can configure my Access 2007 so that it uses #YYYY-MM-DD hh:mm:ss#

Thanks!
Steve

 

[Oldsoftboss]

Not sure, but TRY editing line 42 in the frmInputbox code to:

sql = "SELECT * FROM [tblInput] WHERE (([tblInput].InputDate=#" & Format(f.[InputDate], "YYYY-MM-DD hh:mm:ss") & "#));"

As the date format on my PC is different, I'm finding it hard to replicate.

Dave

 

[Oldsoftboss]

Is there a way that I can configure my Access 2007 so that it uses #YYYY-MM-DD hh:mm:ss#

The format is set globally on your PC through windows.

 

[enfinity]

Thank you! The forms work perfectly now. Seems like there are 3 parts that have to be modified in order to make the db compatible with different time formats:

(1) Line100 in modCalendar: rs.FindFirst "InputDate = #" & Format(myDate, "YYYY-MM-DD hh:mm:ss") & "#"

(2) Line 43 in Form_frmInputBox: sql = "SELECT * FROM [tblInput] WHERE (([tblInput].InputDate=#" & Format(f.[InputDate], "YYYY-MM-DD hh:mm:ss") & "#));"

(3) Line 92 in Form_frmInputBox: sql = "DELETE tblInput.* FROM [tblInput] WHERE (([tblInput].InputDate=#" & Format(Me!InputDate, "YYYY-MM-DD hh:mm:ss") & "#));"

 

[Oldsoftboss]

Good to see you got it working.

Dave