Search results for query: *

All of the documentation on Common Table Expressions specifically mentions that you can create and reference a CTE within a CREATE VIEW statment. Trouble is that I can't find an example of this and I've run out of things to try. Has anyone used a CTE in a view? Any suggestions on the correct...

I have a virtual cube that I would like to save as a local cube for portability reasons(my end users cannot have access to the analysis server). Can this be done? If not, can anyone think of a work-around? I can't think of a way to get what I want without using a virtual cube... Thanks in advance!

I am trying to use a calculated measure which has a different formula depending upon whether or not certain dimensions have been used to limit the results. I am trying to get a Per Member Per Month (PMPM) figure in a healthcare environment... normally not the hardest thing to do - except in our...

I have a situation where I am recieving very large data files in csv or text format which (due to our less than good network) I have to break into smaller files in order to load them into SQL Server. I need files of no more than 500,000 records - so it needs to be split by record count as...

Forgive me if this isn't the appropriate forum for this question. I know very little about networking - I was hoping to get this groups opinion on something I'd like to do. I am new to a company which is currently using a 10 mbps network. We have somewhere between 30-40 servers. Several hundred...

I'm trying to determine the name of the pivot table where the activecell is located - or if the active cell is not loacated in/on a pivot table. The reason being that I have certain code that alters pivot tables and I'd like the code to work only on the active pivot table (we usually have...

I am trying to create a form which contains several listboxes in excel using VBA. I want the form and listboxes created via code so that the code can be transfered easily to many users. I know how to create a form and I know how to create a listbox - problem is I don't know how to create a...

I'm trying to use vba (in Access) to determine which page fields have been selected in an Excel pivot table. Specifically I need to determine which fields have been hidden (or conversely are showing) in a specific page field. Problem is that some of the fields are hidden by double clicking on...

I have lots of code that was written using DAO and also uses the Microsoft Excel 10.0 Object Library. Of course I set these references using the Tools...References menu options in the module. Problem is that in order for this code to run on someone else's machine I have to manually set the...

I'm trying to change pass-through queries using code - but for some reason I can only 'see' the queries I'm trying to alter some of the time - other times I can see them and change their QueryDefs("qryName").Sql property - which is the real goal here. Is there something I'm missing -...

I'm working with Excel 2000 pivot tables/charts that unfortunately have hundreds of categories at the lowest level of drill down. To better analyze the individual categories we'd like to look at only one or two of the categories at a time. Unfortunately the Excel default is to select and...

I'm attempting to search through all of the macros in a db to find if a certain query is referenced within it. For example, I want to see if the query named "qryThisIsMyQuery" is run from any of the several macros found in the database. This will be used in different databases - so the...

Anybody know how to copy a scheduled task to another PC? We are doing systems upgrades to XP, and we have many scheduled tasks that would take a long time to recreate. I'd guess that the upgrde might not overwrite the tasks, but we can't take that chance. I can't seem to just copy and paste...

I'm trying to write a sub to place a subtotal (or count) at the bottom of a specified column given the spreadsheet, the first cell in the range and the type of summary operation to perform. This is easy if you hardcode the first cell in the range - but I can't get it to work when the top cell is...

I have a formula along the lines of ="Report date range: from " & C5 & " to " & C6 The problem is that I need the first part "Report date range" to be bold - and the remaining characters to be normal. Any thoughts on how I can do this??

I have a need to update both the titles and underlying graph data in a PowerPoint presentation from an Access VBA module. I can't seem to get a handle on how to populate the slides/titles/graph data - I can't even figure out the naming conventions of the PowerPoint objects! Any...

I'm working on sending the results of a recordset to Excel - in my effort to do this I've found a lot of repetition when sending the results to the cells... I'm currently sending one recordset column at a time like so: X.activecell.Offset(row, col).Value = rs![ColumnNameHere] What I'd like to...