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: *

  • Users: ftpdoo
  • Content: Threads
  • Order by date
  1. ftpdoo

    Change Music notes into columns

    Hi - I have a list of music notes and I want to covert them from the following: AAAABBCDGGAABCD'A To the following columns: A A A A B B C D G G A A B C D' A NOTE the tricky D'!! Does anybody have any ideas how to convert these music notes into columns in excel? Many thanks, Jonny
  2. ftpdoo

    Excel find if Value is within range and assign number

    Hi, I have a column with numeric values ie: Column 723 6 2 1342 234234 and I want to say if it falls within the range > 1000 then assign the value 10, or if 500-999 assign the value 8 and so on. Is this possible in Excel? The full list of values are: >1000 = 10 500-900 = 8 250-499 = 6...
  3. ftpdoo

    Excel - Count between an upper and lower limit

    Good Afternoon :O) I have an Excel spreadsheet with the following ranges: Percentage Figure 55% 85% 33% 80% 55% Scoring Key: Total Percent of sample 75% - 100% = Good 2 50% - 74% = Acceptable 2 0% - 50% = Poor 1 I need to work out how many...
  4. ftpdoo

    LCD Projector at funny angle

    Hi, My church has just got a new LCD projector and we mounted in on the wall. The screen is also mounted on another wall - but the presentations are coming out at a funny angle. The projectors adjustment only allow a little playing around. Is there any software out there that allows you to...
  5. ftpdoo

    Problem deleting a record (URGENT)

    Any help would be much apprichied: The problem is i'm getting an error when i run the line: DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 and get the following error: the command or action 'SelectRecord' isn't...
  6. ftpdoo

    can i delete from a form populated from a query?

    Hi I'd like to delete a record from my form. I currently have a delete button at the end of each record but this form is populated from a query.. Is it possible to delete from the orig table?? Does anybody know the code to delete a single record?? Thanks, Jonny
  7. ftpdoo

    VB.Net Connecting to a SQL Server Database

    Hi.. I've just installed VB.Net and SQL Server.. I've got the microsoft sample database Northwind and have added it to SQL Server. To connect to this database do I still need to setup an ODBC connection? Or can I go direct? I keep getting the error "test connection failed because of an...
  8. ftpdoo

    Excel totaling Christmas Menu

    Hi, I have a Chrismas dinner menu in excel with over 100 menu choices on it and I want to total each menu choice. ie The excel sheet looks like the following: Turkey Beef (well done) Beef (rare) duck Turkey Beef (rare) I want a total at the bottom to say: Turkey 2 Beef (well done) 1 Beef...
  9. ftpdoo

    SQL "into" works in Access but not Oracle 8i?

    Im doing the following SQL but the into statement is giving an error. Any ideas? The rest works fine. ========================================================== SELECT CUSTOMERICE1A.PREMISE_ID, PREMISE.PREMISE_ID INTO R4130_Temp FROM CUSTOMERICE1A, PREMISE WHERE CUSTOMERICE1A.PREMISE_ID =...
  10. ftpdoo

    Replacing a character in a string

    I have a file name psFileName the contains the value "file/1" But a "/" can't be part of a filename.. How can i replace the "/" with a "-"?? Thanks in advance..
  11. ftpdoo

    FileSystemObject not available in Access VBA?

    Im want to save a text file from Access VBA.. But get the error "User defined type not defined"! When i try to use the FileSystemObject object. Any ideas how i could do this? Thanks, Jonny ================================================ Dim pobjFso As FileSystemObject Dim pobjStream As...
  12. ftpdoo

    Write / append to a text file..

    How do i write to and save a text file from access vba? Thanks.. ted
  13. ftpdoo

    How to run SQL in an MS Access module

    Dim tbl As TableDef Dim db As Database Dim rs As Recordset Set db = CurrentDb Set rs = db.OpenRecordset("SELECT * FROM Electricity") I've written the code above.. How do I view the contents of this SQL? ie rs.item(1) to view the first item etc? Have I even got this setup right? Its...
  14. ftpdoo

    Exporting from Access to CSV

    I have a table in MS Access which i imported from a CSV: Requested Action Code,17,17 Requested Action Code,18,18 Requested Action Code,19,19 Requested Action Code,20,20 Requested Action Code,21,21 Meter Period Number,01,01 Meter Period Number,02,02 Meter Period Number,03,03 Meter Period...
  15. ftpdoo

    No idea if this is possible in Oracle?!

    I have just ran some SQL which generates the following results: Requested Action Code,17,17 Requested Action Code,18,18 Requested Action Code,19,19 Requested Action Code,20,20 Requested Action Code,21,21 Meter Period Number,01,01 Meter Period Number,02,02 Meter Period Number,03,03 Meter Period...
  16. ftpdoo

    Creating New CSV files from a master

    I have a csv file (C:\test.csv) in the following format: Requested Action Code,17,17 Requested Action Code,18,18 Requested Action Code,19,19 Requested Action Code,20,20 Requested Action Code,21,21 Meter Period Number,01,01 Meter Period Number,02,02 Meter Period Number,03,03 Meter Period...
  17. ftpdoo

    Kicking off a VB dll from JavaScript

    I have some temp code which does this from within VB: Dim pobjArchive as FDCS.Archive.clsRemoveFiles Set pobjArchive = New FDCS_Archive.clsRemoveFiles call pobjArchive.Archive() How can I this from within JavaScript? I've tried: FDCS_Archive.clsRemoveFiles.Archive(workOrderNumber); But no...
  18. ftpdoo

    XML DOM VB6

    I've loaded my XML DOM object into memory: Dim Dom As Object Set Dom = CreateObject("MSXML.DomDocument") Dom.async = False Dom.Load "c:\Standalone.MetaData.xml" Now how do I naviage through the DOM to fin d the node im looking for? Thanks, JD
  19. ftpdoo

    XML DOM - How do I delete a node?

    Hi, I have an XML DOM built up in memory: <WorkOrder> <Script> <Code>MLT05</Code> <Mandatory>MANDATORY</Mandatory> <Status>Not Started</Status> <StatusCode>NS</StatusCode> <Description>Work Order</Description> <FileName/> <FileLocation/> <ResultSetName/> </Script> <Script>...
  20. ftpdoo

    JS Can't read my VB Array??

    Im returning an array from VB6 as a array of string: Public Function getStatusUpdate As String() But in my Java Script its being picked up as three square boxes!? function GetStatusUpdate(workOrderNumber) { update = FDCSScriptPlayer1.GetStatusUpdate(workOrderNumber); x =...

Part and Inventory Search

Back
Top