Search results for query: *

Hello Phil, I tried your code in both an HTML and an ASPX page, and unsurprisingly both worked, so I guess it is something else that caused the error in my project. I'll have a fiddle about and see if I can replicate the error in a new little project. Thanks Kat I'm such a noob

I'm a bit of a novice when it comes to JavaScript and I'm slowly getting there using bits and pieces in my project where needed, but this morning something utterly baffling occured. Let me explain... I had two ASP HiddenFields, one with an ID of WO and the other STEP, both populated on page...

Hi guys, Thanks, knew someone here would know! Kat I'm such a noob

Hi all, I need a bit of help understanding SQL server 2005 and custom stored procedures. I’m by no means an expert at using SQL, I can do quite a bit of querying and manipulation, but this has me stumped because the terms I use to describe the potential issue aren’t right (or they mean...

Well, thanks all for your inputs guys. I've been Googling since I last posted to find the answer and you were right. I haven't found the answer. I know it's got to be possible, because it's just software (ones and noughts and all that), but I have exhausted all avenues now. Thanks again...

OK, I've been on holiday for a few weeks, and haven't had a great deal of time to get back to this. I appreciate all your inputs, and points of view. After further discussions with the customers, they need to know what document/spreadsheet etc was opened and when, and if the PC was idle (i.e...

OK. We build bespoke aerospace components (equipment that is bolted on to the payload of a satellite). Each one is bid for using data not generated from anyone even close to manufacturing, so we usually overspend, and are asked to justify it. This is getting worse because we are also trying to...

Hi, For my work, I've been asked to investigate creating an application that monitors what applications are 'active' on a PC for completing time sheets. So for example, from time hh:mm:ss until hh:mm:ss user was using SAP (application has focus), did nothing (PC was idle) for half an hour, then...

Hi Skip, Thanks very much for that - I never though of doing text to columns (I kind of get stuck in my ways). I still don't understand what the differences are between what Excel does and what the VB does, but I think I'll just forget it and carry on! Cheers. Kat I'm such a noob

Hi All, I have a spreadsheet exported from another application into Excel, which has a column with a 'date' in it which is in the format dd.mm.yyyy - this needs to then be formatted to a date for calculations etc. There are four of these column types and the rows regularly exceed 20,000, so for...

Hi, I've tried removing any spaces in the query, but I noticed one thing. The eels table doesn't appear to be joined (there is no where clause to join it to anything) So I've added it in (probably wrongly) and have this (now not formatted): SELECT ee_empno, ee_title || ' ' || ee_inits || ' '...

Hi, I have an old query (not written by me) which is running against an oracle database, but I get the error "FROM not found where expected". The from looks to me like it is in the right place! I am not used to Oracle, but am ok with SQL. I am using MS Query because I don't know any other way...

Thank you very much, this does exactly what I need - I hadn't thought to use row numbers with a cte for this. Nifty little trick that. It seems to be pretty quick too, 15 seconds for 200k rows. I can now have a play. I'm such a noob

Hi all, I need some help getting the next record in sequence - I have already tried numerous things to get this done and haven't found an answer that will do what I want. The only thing I have found out is that what I want to do isn't 'good practice'. So here's a snippet of my table...

Hi guys, Thanks for the suggestions, I have tried to stop the users pressing enter, but they had a paddy about it. I'll just make them choose whether they want to edit comments or press enter!! Thanks I'm such a noob

Hi all, I've got an issue with an application and carriage return characters, and after researching and Googling haven't found a solution. In the application a user enters the first comment, then when a subsequent comment is added to the existing, the existing comment(string) is separated...

I fixed it. Firstly, there is no ":" after LPT1. And secondly, I needed to use the correct ZPL for my machine. I should have known. I'm such a noob

Hi all, I'm trying to create a .net app that prints a label. Normally the Zebra printers are all networked but for the purpose of development work I have a printer directly connected to my PC via LPT1 (avoids confusion, and the networked ones are in a different building!). I can successfully...

Hi, I started to receive this error today in a DGV, and I've managed to solve the issue. I had a NULL value in the column I was trying to sort, which made the app error out. It might be worth checking the dataset for NULL values. Just an idea. Kat I'm such a noob

So this morning I try to log in to my application with my admin account, twice, putting in an incorrect password each time. Now oddly, the account I'm logged into the PC with is completely different to the account I'm testing the application with, but the code locked my normal account anyway...