Search results for query: *

I have jobs setup to copy my backup dump files to another server offsite. They all run fine apart from on which has now started to fail with an 'Access Denied' error. My command is just Copy E:\mssql2k\MSSQL$UNIT\BACKUP\mytuedump.bak \\fpstaff\2ks-unitsvr-backup$ All the working jobs are...

Hi guys, I'm trying to run the following script... exec master..xp_cmdshell 'copy E:\mssql2k\MSSQL$UNIT\BACKUP\CrontDump.bak \\2ks-mis\e:\UNITBackups' ..and getting the following error message.. The referenced account is currently locked out and may not be logged on to. Can anyone help me...

I hope someone can help with this strange and probably easy problem I have. I have a field in a continuous form that displays various lengths of data. I want the user to be able to change the width of the field (by double clicking) if there is more data that they wish to see. I thought I'd...

Hi Guys, The problem I have is that I have a bound field on a form and sometimes the data string is too long to disply fully. I can't make the field any biger than it is. I was hoping to be able to use the ControlTipText to display the actual data or a mouse over event but I can;t figure out...

Hi Guys, Been reading through the posts on this topic but can't find the answer. I have the usual one to many relationships and want to return each one record with one of the many if it exists. Each record has a possible two fee types. The sql I have is like this: select distinct...

Hi folks, I have a module that calls a recordset and emails to the relevant person. The problem I have is that I can't manage to get all the data into the message body, the variable 'strmessage' fails to grab the data. If anyone can see what's wrong with my code any assistance/advice would be...

Is there any way to link two tables in a crystal report when they aren't indexed?

moving on from my problem earlier I now have a slightlty similar one. I have table and data similar to this; ID Address 1 1 first ave widnes Cheshire 2 -----extra unwanted carriage return 2 First Ave widnes Cheshire The addess...

I have a table that stores addresses in one field with a carriage return between each line. Unfortuantly some users have been inputing addresses and hitting carrigage returns more than once, hence I have blank lines of data stored. Is there a way I can delete the unwanted carriage returns and...

Does anyone know how to store the system date in a table when a record is created. I've used getdate() as the formula in a field but this won't store the date just return the current date everytime the record is called. Many thanks in advance Martin

I'm sure that there is a simple solution to this but I'm having a bad brain day. I have a table of data as below. col1 col2 Manders Data Input Manders Exams Manders Applications FBloggs Exams FBloggs Applications I'm trying to get results as follows: col1 col2...

I'm trying to write a function that calls the Search Worksheet function from Excel to find the position of a character so I can use it to perform a Mid function from that posistion. The character can appear anywhere in the field. I've referenced the Excel 9 Object Library and my function still...

Hi :o) What I'm trying to do is turn a recordset into one column of data with mutliple rows ie: SourceData = ID Firstname Lastname Country 1 Martin Anders England and I need Col1 Martin Anders England I've tried to write it as a cursor but my experience of cursors is...