Search results

Thanks again. That worked great and I can build the the pivot table off of the union query directly. Off hand do you know if is this a 2007 feature of will I want to push it to a temp table for the pivot table date for 2003 users? Thanks -JP

I hadnt thought of it that way. Think I could use that Union query behind a Access pivot chart? I think Ill try that. Thanks for the imput!!

Not sure if this is even possible in Access or Excel Pivot charts for that matter but I would like the ability to look at the overall average of a group of data and compare it to an individuals average for the same time period on the same chart. I have not seen anything when searching google or...

I have found if I create the query in Access and duplicate it using the form I can compare the 2 from the imediate window where the debug.print prints to to see what I need to tweak to get the code correct.

Am I missing where you set or open the rst recordset to equal anything?

It can be but as far as using an array this should not cause a problem. You can redim from the sub if it is dynamic and it will carry the data between forms and modules during a run.

Have you tried to delcare the ArrFilesfound(i) as a global variable and not specific to the form you are using?

Im sure the syntax isnt exact since this is from my DB2 query but this might do what you want modified in the SQL case when [listkey] in (883) then '883' when [listkey] in (879) then '879' when [listkey] in (884) then '884' else '' end As Whatever

Are you trying to filter the results to only contain those values or to get only those values to display if they are present in the [listkey] field of the results?

The dialog box code came from here: http://www.tek-tips.com/faqs.cfm?fid=2484 I changed it so I could pull the Filename as a public variable to pass between the different modules I had. Option Compare Database Public FileNameO, FileNameR As String 'full file name And then open the file...

My excel file comes from a shared drive on our nextwork. I will have to find where I Got the class from but it uses the windows file dialog to locate the file and get the file path/string. If the file is the same path/string you could just hardcode that.

Ok.. to make sure I understand correctly I make 2 global var. Dim AppExcelOr as object Dim AppExcelRs as object and just refer to which ever instance I need.

I have 2 workbooks open. How do I identify which one I want to use? I can not seem to tell Access which one to use.

I am importing Excel data into Access. I have code already writen that pulls the sheet names from user selected excel files, populates a form with the sheet names(opens files to get names and closes), allows the user to chose with Sheets to import, and then imports those sheets(opens and...

I ended up using a temp table to combine the data with VBA running and putting the data into the correct fields on the table to generate the report. It actually works well since this report generates 4 lines of data per day from 2 seperate tables (10k+ lines and 2k+ lines) per day. This allowed...

That actually occured to me on the way in today. Im not sure how to work it since I will be dealing with the same problem for both queries possibly having different data that I want to group on. I think the best solution may be to use a temp table and write some VBA logic behind it to ge the...

Hello all. I have been unable to solve this and need some help. I have a large amount of data that needs to be looked at from a number of angles and am having a problem with getting it all to show. running the individual querys I obtain the information I need but I need to combine these into...

Hmm.. my mistake then.. I know in excel I am unable to undo anything after I run any code. I assumed it would be the same here.. I will have to do a bit more research into that then. Thanks for the correction.

Whenever code is ran, the capability to undo anything prior is erased. I believe this is what applies here as well?

Not sure about how to limit that but you can create a matrix based off the tables to generate the data you are needing. 　 Dim m1(1), m2(3), m3(9), r1(27) as string or () if variable to set later dim i1, i2, i3, rn as integer 　 'set the m1, m2, m3 values. can be set from table 　 rn = 1 　 for I1=...