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

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

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

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

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

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

I have a list of names in a spreadsheet, however some of these names have an asterix on the end of the surname. The names fields are made up of Surname, first names So they look like this:- smith, neil smith, michael smith, michelle etc. However in some of the list, the surnames are...

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

I have created a crosstab query, and it works ok. I have the following: Targets: which is an area the reps need to address Notes: Which are notes for the targets Source: which are the reps ID numbers asource1: which is the paper report the rep completes The code for the query is: TRANSFORM...

Here is a puzzler. I have a database which has in it a number of participants, a number of products, and the testing grades given. The participants test a number of products, usually 3, a number of times, each time they grade the products for look, which is A - E, Useability which is 1 - 5...

I have a database set up, and I have created a combined report that will print certain fields from a number of different records. This works OK, however what I am wanting to try and achieve is this:- I want the report to compile as it does at the moment, I then want this report to ask the user...

I have a database, with a number of users who input direct there reports. What I have set up is a simple sheet which brings me back the list of users, and there total number of reports. I have done this with a simple count query. This works fine. However, when I try to ammend the query and...

I have a number of reports in my database, some landscape and some portrate. However when I try to print some reports that are set to Landscape, they print out and display portrate even though I have set the margins and layout, and saved the changes. This seems to occur when I have exited the...

I want to set up a simple query, which will bring back the results from a table for the last amount of days. i.e. the records inputted in the last 5 days etc. I have tried in the query criteria: day()-5 This just brings back though any date with a 5 in??? Any help apreciated.

I have a database, and have a number of reports that will print. From the main table I have a querie that will return the order sheets that I need. This query is presented in a Form, so that I can scroll through the records. From the returned records I want to create a combined report which...

I have created a search criteria in a field, I have used: ' Like "*" & [text] & "*" ' If I put in 'LON' it will return entries that include text like 'LONDON' 'LONGTON' etc. If I leave the text blank, and just click OK then it will bring back all entries, how can I change it so that if...

I have a database created. I am trying to create a query where I can search a number of fields with the same search text. I can do this for individual fields with no problems, but I want to create a criteria like ' Like "*" &[Enter search text]& "*" ' But I want this to search a number of...