Search results for query: *

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

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.

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 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 am trying to compare columns in two tables to see if there is a match. I want to trim or remove part of the data in this columns before looking for a match. I have a table titled v_WIN_PRINTERS_T_TH and the column name is WPT_WPN_PORT. Data in this field is similiar to this...

I need to insert data into a text field but do not want to overwrite the existing data in this field. I only want to add the new data at the end of the line. The code I currently have to do the insert is listed here Insert into dbo.Deployment Set dbo.Deployment.Comments = dbo.NewData.Comments...