Recent content by jguillen

I have areport that I need to export to an excell template that contains some formulas that would work with the data from the report,. Here is the code. export_test ' '------------------------------------------------------------ Function export_test() On Error GoTo export_test_Err...

I have a report based in a crosstab query. it has 2 parameters pass from a form. My problem is that if I use the form to pass the parmeters the report misses fiels that has 0 values. If I use user input parameters the report works fine it shows fields that has 0 value. Here is the sql for...

I did put a refresh comand after the code and did the trick. Again thank very much for the help.

Thank Again Bob I did put the code in afterupdate event, and it seams lke it requery the subform, but it does not update!, I used a macro on the subform container to requery in the on enter event and it does refresh the data, but of course i need to click on the subform to triger the macro. do I...

I know this has been asked before but can seem to find the right answer to my problem. I have a main form with a subform, subform with the control source from a query based on the parameter of the data entry in 2 fields in the main form. It work good but only updates when I move from one record...

Sorry to be so newbe but where do I input that code?

Been working on this problem for a long time I know there is a simple solution please help.:confused: I have a combo box, the row source type is a query and the row source is based on parameters from the values of the 2 previous fields in the form. I have been trying to have the value in the...

Thank you Bob, I will change that in the tables, I did try to use an unbound field for the parameter for the phase and job in a test unbound form but it did not work I get no data when ever I try to use phase as a filter parameter.

yes, but the problem I see is, if you run the "query rpt task by job test07" and try to use a parameter in the phase to filter it does not work.

dbase attached Here is dbase the form does not represent the change that I need to make in it. I need to show the tasks for the phase and job so to limit the entry to only those tasks that correspond to that phase and job and to populate the trade field with the trade for that phase and task...

But it wont work in a query either, I tried setting parameters in the query for the job# and phase values to be enter manually and ignores the phase input and only takes the value of the job#, and when I just put the parameter for the phase it ignores the parameter it will not even prompt it...

I need some help please, I have a form with the following fields: Job# Phase Task# Trade Hours worked I need to use a combo box for the task# from data filtered by a query using the values from the job# and phase. I build the expression for the parameters and I get no data. If I use the data...

Thank you that did the trick.

Well to no avail, I created my form for the parameter input with a button to preview report, but the query gives me a error it does not recognize the field as a valid field name or expression. It works fine in a regular query, but not in a crosstab query, any ideas how I can fix this?

Thaanks again, I will burn the midnight oil on this