Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Adamba

    VB 5 Compiler

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

    VB 5 Compiler

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

    SQL Server 2005 x64

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

    SQL Server 2005 x64

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

    MDX Statement For YTD Last Year

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

    [b]YTD and Previous YTD Comparisons - Assistance Required [/b]

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

    MDX Statement For YTD Last Year

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

    Running PHP? on Foreign Website

    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...
    • Adamba
    • Thread
    • Replies: 2
    • Forum: PHP
  9. Adamba

    Modifying The Current Worksheet in Excel (using vb6)

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

    Modifying The Current Worksheet in Excel (using vb6)

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

    Modifying The Current Worksheet in Excel (using vb6)

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

    filtering invalid data type

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

    filtering invalid data type

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

    Calculated Member

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

    DTS runs slowly when called from within DTS

    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]
  16. Adamba

    screen updating in access

    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]
  17. Adamba

    An Interesting Printer Problem?

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

    An Interesting Printer Problem?

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

    How can I crash an application ?

    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]
  20. Adamba

    Chart Macro help needed

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

Part and Inventory Search

Back
Top