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!

Search results for query: *

  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]
  16. GKWilly

    Yet Another Outer Join Problem

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

    Emailing Recordset Problem

    Thanks to both PHV and Harleyquinn Stars for you both :o) Your help is very much appreciated guys
  18. GKWilly

    Emailing Recordset Problem

    Sorry to be a pain and take up your time but the problem I'm having now is that after the first email is sent and it moves to the next record, the email it creates is the same as the first one but with the first and 2nd emailto, ie, the first person gets their correct email then the 1st and 2nd...
  19. GKWilly

    Emailing Recordset Problem

    Thanks Harleyquinn, works a treat. Could I ask you one more question though? How would I update the emailed field in the recordset to 1 so I do't end up looping through?
  20. GKWilly

    Emailing Recordset Problem

    Hi Harleyquinn, What I'm trying to do is send out the user details to the individual user when the emailed flag is zero, I'm only testing this on one record so far so I may have made a mess of it. Anymore guidance you can give would be great. Thanks

Part and Inventory Search

Back
Top