Search results for query: *

Many thanks for the responses! I shall investigate VB5CCE but if i do need to create an EXE. The machine I am replacing the file on is embedded WinXP on a Siemens panel PC. The problem I have is that the system has been set-up completely for VB5 and uses the relevant runtime files. I could...

Hey there all! I own both VB6 and VB.Net, but have a VB 5 project in which i need to modify the SQL table name that it writes to as this was, god knows why, hard coded into the form. I can happily change the code in the project using a text editor if needed but need to re-compile it into an...

Paul, Many thanks for the response. Adam [pc3] Adam [glasses]

Hi all, Sorry if this is in the wrong area but i could not find a SQL Server systems specific forum. I have just recently upgraded to SQL Server 2005 x64 bit system from SQL 2000 x32. I cannot figure out how to install the client tools (from the x64 CD's) onto my Windows XP (x32) desktop...

Just For Info, I have now managed to crack this. The code i have used for Previous Year (Year to Date) is as follows: SUM({Head(Descendants([Time].[Year].&[2005],2), COUNT(Descendants([Time].[Year].&[2006],2), ExcludeEmpty))}) Maybe not the best solution for rolling over years as will...

Nassy, Any luck With your rolling Last Year -YTD? Regards, [pc3] Adam [glasses]

Hi all, I have been using the YTD() and PeriodsToDate() functions in MDX to create rolling Year-to-Date calculated members. My problem arises while trying to use the item(0).lag(1) code to try and get the same YTD() period for a year ago. The problem with using either the lag function...

Hi all, We have a site up and running which collects data from our technicians that are working 'on site' and was wondering whether i can run sql from my location to pull out/update the results. I can log into the website my techies set up to browse the data but am trying to set up an active...

dwlerwill, Many Thanks, it appears that i can run it on various pc's with different versions of excel ,except my vb computer, so ill stick with the code and have to debug on those pcs then come back and figure out the problem before shipping. Think ill go to the pub now and down my sorrows...

dwlerwill, Thanks for your quick response, What i was after was not having to 'open' or create a 'new' instance of excel but to look at the one that is already open. Intrestingly i compiled my program and run it on a pc with Excel 97 (SR-2) and it works fine but on my 'programming' pc with...

Hey all,[wavey] I apologise if this question has already be asked. Im creating a pseudo add-in for excel which looks at the currently opened workbook and then pulls out most of the details such as sheet names, data ranges, headings, ... On my hunt for code to interact with excel i have found...

BNPMike, Why is it always so simple! ive spent days looking for complex ways of filtering them out! Many thanks for the simple answer [smile] Turns out the fields had ? in them but when your looking at over 1 million records and in number format i was just missing this fact. Once again many...

Hi All Im not sure if there is a previous post as am not sure what to search for. In my search i have not found anything of use so i apologise if i am repating someone elses question. [noevil] I am Linking/Importing (have tried both) to a text file source that i have tidied the formatting of...

Hi All! Wondering if you can help me get my head round the code for a calculated member that is a percentage of a fixed level within my dimension. What i would like to be able to do is work out the %age of the current level vs that of level 1 for it, but only if it has gone past level 1 (not...

Hi all! Hehe, cheeky me! [thumbsup]As i am experiencing the same problem think ill drag this post to the top! [wiggle] [pc3] Adam [glasses]

smurf01, when you say screen updating i assume you mean the function in Excel: Application.ScreenUpdating = False ... If so i use in Access Docmd.Setwarnings False Hope this helps! [pc3] Adam [glasses]

RobBroekhuis, Thanks for the reply, its looking like that is the way to do it, i had 2 concerns with that, 1. My system is being used by a 3rd person client and i didnt fancy the idea of more docs being created just to print. 2. The charts all realate to the same source cell which change...

Hiya all! [soapbox]**WARNING: ESSAY COMING UP **[soapbox] Ive been asked to add a 'Print All' button to one of my Excel workbooks and seem to be having some difficulties with the amount of pages/prints that i need to do. The workbook contains 18 sheets, 9 raw data sheets 8 charts and the...

Try printing 83 pages to a network priner using vba directly, seems to hang for me! damn customers with their silly requests! [pc3] Adam [glasses]

henio, Are your ranges individual or counted as one source? if it is a single range the 'record macro' function gave me range access like: Sub Macro1() ActiveChart.SetSourceData Source:=Sheets("YOY Pivots").Range("B62:E87"), _ PlotBy:=xlColumns End Sub If...