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!

  • Congratulations SkipVought 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. Tapew0rm

    SharePoint Comment From Approval Task

    Hi, I have the OOB approval workflow running on sharepoint 2007 that assigns tasks to the assigned approvers. When the task is sent out to the user they have the opportunity to approve reject etc. and also to add a COMMENT. I have a custom workflow that sends out various emails that runs...
  2. Tapew0rm

    Company system updates rebooting SQL server

    My company has system updates that go on at night and re-boot my amature sql server. When I come in in the morning I have to log in and re-do all the jobs that were supposed to have ran. Is there a way to have the jobs run even though i'm not logged in?
  3. Tapew0rm

    Linked Server & MS OLE DB Provider for Oracle problems

    I am trying to link to a Oracle with a new sql 2005 64 bit server I just set up on my xp 64 system. When I go to add the new server the provider 'Microsoft OLE DB Provider for Oracle' is not available. I have since installed new MDAC and Oracle 10g client and it is still not there. Anyone...
  4. Tapew0rm

    Sql server dropping connection with Access view

    DISCLAIMER!!!! I'm just got my hands into SQL, be warned, this is just a work around. I had a similar problem with an xl link. I changed the view to a procedure with all of the views calculations and had it make a table then edited all the calculations out of the original view. It worked...
  5. Tapew0rm

    Don't laugh, Easy one, Avg a case statement

    Hi, Ok this should be easy but I obviously woke up on the stupid side of the bed. Here is what i'm tring to do basicly... AVG (( Case When X = Y Then 1 Else 2) - (1)) End as Field_Name, I keep getting incorrect syntax near ')'
  6. Tapew0rm

    Is the owner of the database I'm using being unreasonably picky

    I'm no DBA for sure so before I decide that the DBA is indeed being a bully I want to know if you find his very frequently repeated requests unreasonable. "Please limit to one sql query analyzer open at a time if possible. And close out when you leave at night." I'm linking to his server...
  7. Tapew0rm

    [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData

    I'm getting this error... [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()). from SQL Query Analyzer. I don't get it consitently, it depends on how hard I make the server think and what kind of mood it's in. I've searched all of google and I even tried...
  8. Tapew0rm

    Transfer Spreadsheet ...

    I had the same problem today because the file name always had a diffrent date. This is what ended up working (only i was doing it for a text file.) Hope it helps take your macro and convert it to a vba module. Then do somthing along these lines with the code. Private Sub Command27_Enter()...
  9. Tapew0rm

    Sendkeys Macro for data entry needs to read from txt

    No im using visual basics 6.0. I do alot of access stuff though so that must be were my termanology is off. Here is the synopsis of what im doing. 1. fill out an excel sheet with data entry details 2 import to access export as text delemited (im lazy) 3. I have a visual basics program that...
  10. Tapew0rm

    Sendkeys Macro for data entry needs to read from txt

    Okay nevermind I just had a serious brain-fart on that one. Now I have 2 new questions that I can't find previously posted. 1. I need this macro to perform a mouse click on a button but I have never done or seen a macro with that ability. Does anyone have some snipets of code or an idea on...
  11. Tapew0rm

    Sendkeys Macro for data entry needs to read from txt

    I have a macro used for data entry that reads from a txt file and spits it all back out into a database. The problem is I need it to perform a diffrent behaviour based on a character in the txt file. This is what im trying to do. Do until Trim(Cstr(strTextstring2)) = "X" I cant get it to...
  12. Tapew0rm

    My backend blew up.

    No I didn't eat to many burritos.... I have a DB with a front end and a back end. The front end is MDE and the back end with the tables is a MDB. It's is used by up to five people at once and works like a charm when I first set it up. But by the time i get in the next morning it's either...

Part and Inventory Search

Back
Top