Recent content by ftpdoo

Thanks Glenn this works PERFECTLY - I'll be in fine tune now! Thanks again, Jonny

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

WOW -Thank you so much!!! This was exactly what I was trying to do! EXCELLENT! :)

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

Yes your right that moving the bracket would be the easiest option probably! Its just it'll mean getting a longer wall bracket made. The keystone options help a little but the image is smaller at one side that the other because of the angle that both the projector and screen are at.. Was...

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

THANKS.. that appears to be running.. Theres millions of records but its def doing something! :O) Jonny

Im trying to do an INSERT from my select statement. In Microsoft Access I can run this query straigh off but Oracle isn't happy with it?? Any ideas? Been playing about with it for ages but it just won't run.. Thanks, Jonny

Im getting the error "Invalid SQL Statement" with the statement below: INTO R4130_Temp If I specifically name each field that im entering into I get the following error: INTO R4130_Temp.Premise_ID, R4130_Temp.Premise_ID2 Produces the error "Missing Keyword" Any suggestions? I know its...

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