Search results

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

Thank you. I don't know how that is done do you happend to have an example I could download to see how that is made?

I have a report based on a crosstab query with one user input parameter. Sometimes the parameter input window pops up several times before it executes the report and sometimes it executes on the first input. Any ideas?

Thank all for your help I figured it out and fixed my form it works good so far. What I did I change the task field as a Combo box and used a query to extract the information with the parameters from the Job# and Trade fields from the form. Here is the SQL code: SELECT [test task lookup].[Job...

Thank you Liddlem I do have a table that has the information on job# (job# refers to a project site), Phase, Task and Trade, but I need to generate a list for the phase and task corresponding to that job# and trade.

Yes, sorry I have 2 tables payroll and job info. The form I'm creating is for the payroll, As the user inputs the job# and the Trade I need to generate a list from the job info table based on the values of the 2 fields(Job# and Trade). As to limit the input on the phase and the Task field...