Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by GKWilly

  1. GKWilly

    CMDExec Problem

    Ah!, can't run it from cmd prompt so obviously I'm looking in the wrong place. (Disengage keyboard, engage brain) Gone Drinking [bigcheeks]
  2. GKWilly

    CMDExec Problem

    I can't even force the job to run now when there no connections to the share. The jobs are setup to run one each day, ie. the one that is failing is the tuesday job (have different backup devices for each day, db and log, so I can always restore to a specific day and use the log for point in...
  3. GKWilly

    Newbie: Insert Statement

    LizSara, It sounds like you need this script to UPDATE your record not INSERT.. Update choices set choice_id = 268275,at_id = 140706,base_id = 50, preference = 1 where stud_id =261555 Gone Drinking [bigcheeks]
  4. GKWilly

    CMDExec Problem

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

    xp_cmdshell Login problem

    Many thaks for that. I'll give it a whirl. Thanks again :o) Gone Drinking [bigcheeks]
  6. GKWilly

    xp_cmdshell Login problem

    Hi ptheriault, No I didn't know you can do it with Agent! Can you give me more info on how to do it please? Thanks Gone Drinking [bigcheeks]
  7. GKWilly

    xp_cmdshell Login problem

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

    Resize textbox in continuous forms

    Thnaks missingling, I'm kinda hoping I can get round the problem without using the zoom control though. Gone Drinking [bigcheeks]
  9. GKWilly

    Resize textbox in continuous forms

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

    Mouse Over Event of Bound Field

    Many thanks :o) A great help. Gone Drinking [bigcheeks]
  11. GKWilly

    Mouse Over Event of Bound Field

    Good thinking. Thanks for that. Is it possible to call the zoom and mybe put it behind the double click event? Gone Drinking [bigcheeks]
  12. GKWilly

    Mouse Over Event of Bound Field

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

    Search Help (code)

    I know i included all the code behind the form but all you need is the 'AddtoWhere' sub and the onclick event of the 'FindStudent' button. The 'AddToWhere' that is called in the 'FindStudent' assumes that your table fields are [Surname], [Forename] and [Dob]. You may need to replace these to...
  14. GKWilly

    Search Help (code)

    OK, I'll try and explain how it all works. 1) I have a form (student details)that is bound to tblstudents and contains the ref, surename and dob of of the students( in my case). 2) I have 2nd popup form (frmextendedsearch) that i use for the search and contains 3 unbound fields...
  15. GKWilly

    Yet Another Outer Join Problem

    Thanks vongrunt. I thought it's be something simple but been staring at it for hours and couldn't see the wood for the trees. [thumbsup2]
See more

Part and Inventory Search

Back
Top