Search results for query: *

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

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

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

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

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

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

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

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.

How about performing this action with an Access 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.

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

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

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

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.

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

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

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

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

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.

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