Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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