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. cpark87

    Trigger Help

    I found this question posted and it basically is the same problem has mine.. Just looking to see if there is a fix or this is just an issue when using a front end like an access project http://www.tek-tips.com/viewthread.cfm?qid=535231
  2. cpark87

    Trigger Help

    I read that in an article and tried. My trigger doesn't currenty have the @@identity in it. The select @@identity is being picked up from the trace I ran and it only occurs when adding records to sql using access adp, data access page, or in sql enterprise manager. I haven't found a way to stop...
  3. cpark87

    Trigger Help

    I am having trouble with an insert trigger: Here are some quick facts. 1) Using Data Access Page with a SQL Backend to enter data and then save into a table 2) I have an insert trigger on a table titled tblMapping_Sft that will take the values entered on the data access page and insert then in...
  4. cpark87

    Update Trigger Write Conflict

    The first table is my standard table the second I am using for audit history. The trigger sits on the table tangram.tblIssueLog. The field a_issueID is not an identity field and is used to store the issueID from the main table. I am not currently running this through a stored procedure just on...
  5. cpark87

    Update Trigger Write Conflict

    Here is the trigger code: Create TRIGGER tangram.Insert_tblIssueLog ON tangram.tblIssueLog FOR INSERT AS Insert into tangram.tblIssueLog_Audit (a_IssueID, a_DivisionID, a_DeptID, a_CategoryDesc, a_Issue_Desc, a_Contact, a_DateFirstReported, a_Est_ResolutionDate, a_Actual_ResolutionDate...
  6. cpark87

    Update Trigger Write Conflict

    Refresh does not seem to be a valid command in a SQL Server Trigger. Do you have any additional info on the refresh command
  7. cpark87

    Update Trigger Write Conflict

    Have any of you run into this before.. I have an insert trigger on a table that takes the inserted record and copies all of the fields into an audit table to keep track of when someone inserts a record. However when using Access ADP and SQL Server I get an error on the table with the insert...
  8. cpark87

    Data Access Page - Redirecting Hyperlinks

    I've created a data access page with an inline frame. I am trying to redirect a hyperlink to the inline frame instead of a new window. I've added the code to move to a frame titled iFrm however it continues to open in a new window. Any ideas why this keeps happening.
  9. cpark87

    Data Access Page - Formatting Question

    How about performing this action with an Access Form??
  10. cpark87

    Formating a Continuous Form

    I have a continuous form where I would like to change the backgroud color for every other record. I've seen some example with conditional formatting but not sure if this will work. I would like to do this with code and not by some value present within the table.
  11. cpark87

    Data Access Page - Formatting Question

    I have created a data access page in a tabular format. The page works great however I have a lot of fields in the page which force the user to scroll horizantally. I would like to know if there is a way to add a freeze panes to the page like in excel. Or is there another way to arrange the page...
  12. cpark87

    Update Trigger Write Conflict

    I did want to mention that even know I got the error while trying to do the update, the changes did take affect. I also wanted to mention I received this error only in Access Project and not in Access 2002, 2003 or SQL Server Enterprise Manager. Ive decided to go with a different method on...
  13. cpark87

    Update Trigger Write Conflict

    Were you able to find a solution this problem. I am encountering the same issue.
  14. cpark87

    Question about Triggers

    Another question.. This trigger does work however I am using a Microsoft Access Project as the front end and I receive the following error in access but not in sql enterprise manager Key Column Information is incorrect or insuffient.. Too many rows affected by update.
  15. cpark87

    Question about Triggers

    I came up with this without needing the the temp table and joining through a common field that will not be updated CREATE TRIGGER Sft_Filtered ON tangram.XPC_Software_MasterList_Combined FOR UPDATE AS IF UPDATE (Sft_Filtered) BEGIN UPDATE tangram.XPC_Software_MasterList SET...
  16. cpark87

    Question about Triggers

    I am new to using Triggers and have create one using the code below. I need to enhance it thought and do not know how... CREATE Trigger ti_Filtered on tangram.XPC_Software_MasterList_Combined FOR Insert, Update AS Update XPC_Software_MasterList Set XPC_Software_MasterList.Sft_Filtered = 1...
  17. cpark87

    Combining Records

    Here is my current situation: Table called tblSoftware_Master I have fields within this table labeled Sft_Path and Sft_FileName. Many of the records in this table will have the same value for Sft_Path but different fileNames. I would like to create a view or sp that Groups Together the...
  18. cpark87

    Extracting data from a text value

    I would be running in SQL. Thanks for the feedback I will try doing some more research....
  19. cpark87

    Extracting data from a text value

    Thanks... That did work.. Say I wanted to trim off the \\SomeValue\ of that field and insert into a different table. I have seen some references on using the LEFT or RIGHT commands but usually referring to the amound of characters.
  20. cpark87

    Extracting data from a text value

    I know what you are saying.. If I was going one by one it would work... I wanted to try and run a query and build a relationship between the two tables to come up with a match. Here is an example... v_WIN_PRINTERS_T_TH.WPT_WPN_PORT = \\ATR110F03\PQ_CLP1620_TEST jetadmin.IPX_Name =...

Part and Inventory Search

Back
Top