Search results

Ahhh yes...I misunderstood your question there. :rolleyes: That is a new one to me. Wish I could be more helpful but I'm sure some of the others can.

Sorry for not posting the updated code and causing confusion. Here is the updated code: Option Compare Database Public Function NextBizDay(intNumDays As Long) Dim FSDate As Date 'FOC Supplemental date Dim FODate As Date 'FOC Original date Dim MyDate As Date 'Last FOC 'Determine value of...

Thanks RuralGuy, I went with your code because it seemed most elegant and solved the problem rather well. I am having one embarrasing little problem though. When I set the Control Source of the text field to "=NextBizDay(10)" I don't get the value that the function is returning. The text...

history Under the "Tools" menu there is an option called "StartUp". You can specify a form (usually a custom or default switchboard) to open when the app starts. This is the easiest way. I would be surprised if you could not also code for this using VBA. You can also set the Database...

This problem has been brought up before and solved in a number of ways. I have been working on a module to do this...but in my own unique way. Here is the grist of it. I am trying to setup several textboxes with "target dates" that will give me the next business date (Mon - Fri). The...

In the query that is the data source for the report, you can calculate the week number by using the DatePart function. Weeknum: DatePart("ww",[Date],2,1) Then you can filter or group based on the week number. In the example above the last two arguments (2,1) are optional and used to...

There have been a number of posts that are similar, but not quite what I have been looking for. Most only check to see if the target date is a weekend or holiday, but I am looking to "skip/not count" any holiday or weekend day that occurs within the period of time. For example: If given a...

Nevermind!

Correct. If someone creates a record without a project manager value then it screws up lookups on that record in the future. A PM contact is always assigned and should always be present on a workorder. I can require that a record exists that matches the workorder table...this can be done...

I have a table that contains all the contacts for a project. This table consists of 5 fields. | ContactID | ContactType | First Name | Last Name | Workorder# |. There is one particular record that must be created for each work order before it can be saved. That is a record where...

I found the problem. It was actually quite simple as these things often are. All my forms are based off queries. This makes adding new content to an existing form much easier. That said, my query was setup with an improper join. It was only showing records where the fields on both tables...

Thanks for hanging in there with me Gemma-the-husky, I have removed the referential integrity checkmark and verified that there are no default values specified in the field properties. This is apparently not what is causing the problem.

Right, and I get that...this is exactly how a lookup table works, but you are suggesting that on the form I add the combo box and that in the Combo box Wizard I specify 2 columns and enter in a column with ID's and in the second column the value to be referenced. When a selection is made by the...

The problem I see with this methodology is that for each record you are storing the same value from the form's list over and over again. For example, if I create a combo box and type in the values to be available, each time a record is created the user selects a value from the list. This value...

Hmmm...tried this tonight to no avail. I still receive an error message indicating that the Jet engine could not find a record in the lookup table that matches the field in the workorder table. So basically, if I don't select a value for this field through code or manually then the record...

I am not opposed to avoiding lookup tables and instead using forms, but how do you avoid using tables with a constantly updating data source such as a table that is maintained by another department which contains hundreds if not thousands of records? This is not the case with this lookup, but I...

I have a table called tbl_workorders. One of the fields on this table is optional but because the lookup table is on the one side of a 1-to-many relationship using an auto-number key it is requiring that this field be populated to create a record on the workorder table. This is a problem...

Bob, thanks for the near-immediate response...you are prolific! And this works great...with one exception. I have code set for the ondoubleclick event that inserts the current date. That seems to prevent the subform from requerying. I tried adding the dirty = clean code to that subroutine...

Ok, I believed I had the correct VBA code but this is still not working. It must be how I have this tab setup. Here is the database. Can someone look at this and see what it is I am missing? Just the code for the tab called Project Milestones...if I can see how that is done I can do all the...

Thanks ajetrumpet! That being the case, the source is frm_sub_milestones2. How does one "go to the form's module"? Is this done by entering code builder?