Recent content by Chris1112

I am using a nifty Workday function to calculate a date X number of workdays from another date. I can pass days of week and holidays not to calculate. Now that I have this function, I need to calculate variance, in the form of workdays, between two dates. I am hoping that this code can be...

I've attached my database. It is a new database, so there is only a very small bit of sample data for testing. I've placed a calendar function in there, but don't have it working yet. I appreciate the help very much. Edit: The form is frmCTEntry. There are a series of four text boxes...

I am trying to write formulas to project completion dates of tasks based on a number of work days. Unfortunately, the number of work days varies by task, project type, and each task has a separate calendar to specify which days qualify as work days. This calendar is custom, with the underlying...

I have a form to calculate cycle time based on 26 different possibilities, which are events in a sequence. I need to start with the first event that does not have a date entered and calculate estimated date of occurrence from there. The entries that do have events entered need to have a simple...

Thanks a ton for the help. I'm going to go be ashamed now. ;)

I am trying to calculate the value of a text box on a form with one of two formulas based on the value of another box. I would prefer to do this with the formula and not in VB (although if I must, I will). I attempted using =IIF(Isnull[KRecDate], [SalesDate]+2, [KRecDate] - [SalesDate] -2)...

I'll need to modify it a bit, but that's far better than creating it from scratch. Thanks a ton Bob!

This requires code but it can be done. I'm assuming that this is a continous report. It's been a bit since I've done this and I would need to grab the specifics of the code from a currently inaccessible database. Here's an example of some code I used to make this happen. Private Sub...

Generally this is done the other way around. Subforms are populated based on the main form by default. In order to alter it, you will need to code the behavior, unless I'm ignorant of another solution.

You should have no problems doing this. The data can get a little hard to look at if the information is not related in some way though, in which case you need to link the subforms to the main form.

I appreciate the responses. That is unfortunate to learn. Could a custom calendar control allow me to do what I want? I don't want to develop one from scratch, but I do need to be able to show events on the calendar. I intended to make rectangles visible based on the days that events...

I am using the built-in Calendar Control 12.0 with Access 2007. I have placed rectangles on the form over the calendar but the calendar seems to always be on top of them. I have brought them to the front, sent the calendar to the back, and they are still not there. I have verified that they...