Recent content by kp1279

Hi I have an Access database project, with plenty of vb code. What I have is code that will check the linked files, for their file extention, and open the correct programs for the file, and display those files. Such as .doc opens winword .xls opens excel etc etc What I want to know is can...

I am fairly new to SQL, so please bear that in mind with any responce. I have a database, that someone else had created, but I want to extract some data from it in a set way. there is a name table with a urn there is an address table with a urn there is a document table with a urn and there is...

I am fairly new to SQL, but here it goes. What I am trying to do is run two different procedures within one. One sets a value within existing rows to show that someone is working on the records, and the other copies those records to another table, where editing can be done. The reason it has...

Exactly what I am looking for. Many thanks. I would like to be able to havve the ability to have more than one entry per day, but I think I will be able to sort that from what you have given. ..[2thumbsup]..

Hi I have an SQL 2000 database, with an ADP (Access 2000) front end. I have a table as an events calandar, with the columns: Event_ID as int Date_Of_Event as smalldatetime Event_Description as varchar(1000) Person_responsible as varchar(4) I have created a form with the calandar controls on...

That is exactly what I want. The only other thing I can do, is to create a new temp table, of certain fields, and use a normal search of LIKE within that. I was hopeing that the Full-Text index, was better than it seems. If anyone has any other idea,s of how a user of the access front end...

I am very new to SQL and Access projects. I have created the full text catalogs for my tables, so that I can search all the tables at the same time, from any of the fields in the catalogs. I have created the following procedure:- create procedure usp_full_text(@findtext varchar(255)) as...

Many many thanks [2thumbsup] I am new to this, I have only been creating a database for two months, after 3 days tuition, so all your help is apreciated. I went with option 1, and used the caluculated column, which worked fine, what I did then for the other tables is went into the table...

Thanks for this code, however there are still problems: I have changed the code to suit: CREATE TRIGGER trgConcat ON set_records FOR INSERT AS begin declare @s1 varchar(10), @s2 varchar(10), @s3 varchar(10) select @s1 = type_id, @s2 = URN, @s3 = year_id from inserted update Test...

I hope some of this makes some sense to you? I have a number of tables, all with the same problem. one of my columns is a concatenation of 3 other columns, how can I create a trigger that will update this column automatically when the records have been created? The columns in question are...

Many thanks to all of you. I have changed the field from 'smalldatetime' to 'char' and used the default value of year(getdate()), and it works perfect, it now brings in the current year the records are created. Many thanks again. KP [bigcheeks]

I must be doing something wrong!! I have tried the datepart(yy,getdate()) and YEAR(GETDATE()) I have put this into the default value field, but when I create a record, I now get 29/06/1905 WHY????? I have checked the system date, but that is right, and if I use just getdate() as a default...

Hi I have a database I am building in Enterprise manager, What I am looking at achieving is having a fields to return the current date. The field, I have set as Smalldatetime, and have the Default value set to (getdate()). This returns the whole date and time, however, how do I get this to...

I need the facility to export a report into word, I will then need the ability to password the file. (I am running Office 2000) Both these seem very simple, I can export into word, and then ammend the options to set passwords etc. The problem lies where I want to have an exact copy of what I...

Worked a treat. Thanks a lot. KP [bigcheeks]