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 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...

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...

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...

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?

Hello I’m kind of new to Access I have a question on a form I’m developing, the form contains fields: 1-Job# (has a look out list based on a query) 2- Trade (this field has a list; the options are Plumbing, Sheet metal, and Hydronicks) 3-Phase (here is where I need a drop list based on the...