Search results for query: *

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

...that records and captures the changes made, and by who. This works purfect. Anyway, here is my problem: - What I want to do is to use the 'TOP ** PERCENT' type arguement, like you can with a simple select statement, but this time I want it to say something like - UPDATE the Top **...

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

...create procedure usp_full_text(@findtext varchar(255)) as select set_id as URN, input_date as date_of_record from set_records where freetext (*, @findtext) There are a few union selects under this, but If I search for perhapse 'SMITH' from within access, then this will bring back all the...

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]

...neil smith, michael smith, michelle etc. However in some of the list, the surnames are followed with an asterix, and look like this:- smith*, neil smith*, john I have tried to delete the asterix, by using the find and replace, but this will delete everything, as it is taking the asterix...

Thanks for the help. I have tried it on another machine and its as you say, but it is strange cause my notebook has got a number of printer drivers, and it did not work on this. Anyway Is there any way of Zooming the text down, so that I can print as though on A3 but in fact on A4. Other...

I have created a report, which is set to Landscape, which works fine, but this prints out on 12 Peices of paper. Is it possible to change the paper size to A3?, I have tried the page setup but A3 is not an option. Alternatively can I change the text zoom??? If I change the text zoom so that...

Thanks very much, it worked a treat. KP [2thumbsup]

How would I do this?? So that for each target, I only get those source fields that have a figure in, and not the figure itself. This sounds very easy as most things do, but to get them is much more difficult. ?????????