Recent content by Avaughan

What is the correct syntax for Requery. I have a form with two sub forms. I need to update the underlying query for subform2 when I add registers to subform 1. Works with macro but would rather use code

I am trying to add additional link criteria for a form and subform. The employee Id is the link fields but I also need to throw in a "year" unbound combo box on the master form and filter the child (subform) info also with that. Can use code if necessary. Any ideas?

I am programing a form to be used to input search criteria on a table. I have several variables that will filter throught the table and only provide registers that fulfill with the search crieria. Can someone offer code that will sift through the null values. In the search screen, the user does...

what I would do is build the form from the quesry instead of the table. It will be easier for you. If you are using the assistant just select the feilds from your query name instead of the table. If you have already put your calculated field in the query then it will pass, along with the...

The absolute easiest way to do this is to join the fields in a query with the & symbol SectionId:[SessionDate]&[ModuleId]&[Semester] The next way would be to create your new field in your form as an unbound object using the expresion builder. It would use the same function as above

I need to calculate the number of workdays between two fields in VB. Is there afunction or how should I do it? I am launching the following as an event procedure After Update. Me![Days] = Me![End Date] -Me![Start Date] gives me total days. I just need work days. Thanks