Recent content by AiArch

Sorry about that. Thanks for the help.

I used that at first but I keep getting #REF! error message in A1 on Sheet1. I am stumped why. I have never had this propblem before.

The values look like this CH01, CH02, TB01. Then it returns a value like for CH01 - Chair 1, CH02 - Chair 2, TB01 - Table 1. I tried the regular LookUp Function and it seems to work only if the values are in Ascending order. This is the functino for that...

I am having a problem with the VLOOKUP function. I keep getting #REF! error message in A! on Sheet1. I am not sure why. Below is the function i am using. =VLOOKUP(A1,Sheet2!A1:A61,2,0) Is there a limit to how many values you have have in a lookup function. If so is there a better option...

Do I need something like this in open function of the sub report Me.Filter = Reports!rptCustomResume.OpenArgs

Do I need to type code into the Open event of rptCustomResume to pass the filter to the subreport? If so how would I do that?

I tried things like this. DoCmd.OpenReport "rptCustomResume", acPreview, , , , OpenArgs:=strFilter this is from the click event of the button i have to preview the report. i know its not right but didn't know if it would help to see what i am doing wrong

I am messing around with the OpenArgs and i am still having problems. Do you have an example of what i would type for the OpenArgs. I have not used this before so i am still trying to learn as i go. Thanks again

Do you mean using a parameter within the query itself? ([Enter projects] or someting along those lines). I was using DoCmd.OpenReport "name" , acPreview , , strFilter Is there a way to filter the sub report with the projects selected form the list box. When main report opens it ask you to...

I have a form where you select an employee and then there is a multi select list box where you select the projects you want to print for that employee. I can get the main report to open with all the employee information but the problem I am having is I am not able to pass the filter (the...

Does anyone know of a good third party vendor/application for Access Charts?

IS there a way to total the Columns of a Crosstab Query if it is used as a subform/subreport?