Search results for query: *

Hi All: I used DTS to move data from an existing Access 2000 database to a SQL Server 2000 database. I linked the SQL table back to Access. The Problem: Imported records will not allow any data fields to be updated via Access. New records can be added and updated with no problem! When I...

A2000 I have a column of textboxes on a form,. The bottom textbox displays a total of the values in the textboxes above (Control source = Val(txt1) + Val(txt2), etc) It worked properly for months, but has now started some bizarre behavior. The calculated total textbox is blank. It does not...

I would like to use an 'insert' trigger on a table to write a record into a similar table in a database on a remote server. (Replication is not an option for this project) 1. Is it possible to use a trigger to do this? 2. Must the servers be linked or can you use something like the 4 part...

I am trying to insert records into an existing table that has a specific format for dates and times in the existing records: Date format (Last_Chg_Dt) is '2005-09-16 00:00:00.0000' Time format (Last_Chg_Time) is '1900-01-01 12:26:16.060' Using GetDate(), I cannot find a format to replicate...

Good morning all... I need help with the syntax for a Select statement. Table = AROPNFIL Fields = Doc_Type, Apply_To_No, Reference I want to select the Doc_Type and (when Reference field is Numeric, choose Reference field, else choose Apply_To_No field). All my attempts at 'If...then' and...

This should be so simple, but I can't seem to get it! I have two databases that are identical (Demodata and Data_01). When a user inserts or deletes a record in a specific table in Demodata, I want to make the same thing happen to the same table in Data_01. I wrote an Insert trigger than works...

Hi All: I am trying to write a stored proc that will accept a single parameter as the input and parse this value into multiple 20 character strings. These sub-strings are then written out to a table. Example: Input string = "I want to be a better T_SQL programmer." Needs to be...

Hello All: Yes, another date format problem! I have read all the FAQ's and postings and followed all the links; I have looked in Books on Line and STILL can't solve this problem! In a Select statement, I simply need to return a date incremented to be the 10th of the following month. The date...