Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kp1279

    Use VBA to open word or excel, but disable their features

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

    MULTIPLE SELECT STATEMENT

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

    Update only a set percentage?

    ...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 **...
  4. kp1279

    Calandar controls and format

    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]..
  5. kp1279

    Calandar controls and format

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

    FULL TEXT INDEXING - FREETEXT

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

    FULL TEXT INDEXING - FREETEXT

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

    TRIGGER TO UPDATE TABLE FROM IT OWN VALUES

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

    TRIGGER TO UPDATE TABLE FROM IT OWN VALUES

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

    TRIGGER TO UPDATE TABLE FROM IT OWN VALUES

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

    Date Format

    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]
  12. kp1279

    Date Format

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

    Date Format

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

    Export report to word?

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

    How can I remove an " * " from data in a sheet.

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

    How can I remove an " * " from data in a sheet.

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

    Changing to A3, or zooming the text??

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

    Changing to A3, or zooming the text??

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

    * HELP IN A CROSSTAB QUERY *

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

    * HELP IN A CROSSTAB QUERY *

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

Part and Inventory Search

Back
Top