Recent content by Sontec

I'm no programmer but I though i'd be able to manage setting up this simple asp client check asp script, but try as i might, I can't get the script to look at the database. I keep getting error 2147467259. Below is the script that includes the db location (as you can see its aimed at...

I knew it'd be something stupidly simple. Thanks for solving it so quickly!

This seems to me like it should be really simple, but I can't work it out for the life of me. What I need to do is pull a field from 1 table if a job exists in it, otherwise pull the same field from a different table. If that doesnt make much sense, i'll explain a litle further. Our system...

Hey! A fellow East Anglian :oD Don't you just hate it when theres a really simple answer that you did'nt think of yourself? Thanks alot for your help..much appreciated.

This is going to be a hard one to explain... We need a formula to total the amount of time spent on a repair job. Our database contains sevearal lines for each job (with distinct job number), each containing a period of time where the engineer has done something with the unit. What we need to...

Hi all, I'm hoping that someone out there can help me with something thats got me stumped within an Excel macro. We have a requirement to pull certain information from a spreadsheet when the delivery date field is the next working day. (i.e. if we run the macro on a Friay, we need to pull out...

Thanks for all your help... It turned out to be quite simple...all I did was setup a normal date range paramater without default values and made the filter refer back to the formula using the 'is equal to' option...i was always looking at 'is in the period' cos it was a date range.

OK, I understand that much, but the report needs to prompt users for the date range they need each time they run the report...we don't want the report to run the same date range each time. I need to add a filter that selects the date received from a parameter where the user has selected the...

But how do we get the date into a parameter? Maybe i'm missing something... As an example, we want to pull out a report of all spares receivd between 1.1.2003 and 20.1.2003, but because there are no crystal recognised dates in any of the tables, we haven't been able to set the range defaults...

We are trying to extract data from a SQL database that has been written by Clarion. The clarion date is in a number format (76431) and we have a formula to convert it for printing on the crystal report. However we need to use a date parameter to select certain data from the database and this...

Our company has recently bought a consignment of new machines from Evesham. On 4 of the machines, 2 out of 3 times when you send a file to the network printer (a Ricoh Aficio 450), the screens go black, sometimes with graphical corruptions, and the computer is totally locked up forcing a hard...

Our system is set up to play the night time message at 5:30pm every day, which it does, but we want the system to transfer straight to our general delivery mailbox after the message. Instead, it goes on to ask which extension you require, and puts the call through the 3 receptionist phones as...