Search results for query: *

Hi All, I have started working with Oracle and I have some very basic questions I am sure. Anyway, I want to check the a field contains 4 letters then 2 numbers : 1234ab = true 1234 ab = true ab1234 = false 1a2b34 = false 12a = false 1a234 = false 1234abc = false abc12345 = false...

I have done a search for Trigger questions an answers and there are lots... but I just can not get it working. I have a simple table with 3 fields: ID(autonumber);Value1;Value2 I want Value2 to always be 100 higher than Value1. So : CREATE TRIGGER ValueTwo ON testTrigger FOR INSERT AS UPDATE...

Hi 'yall I have a simple problem, but I just can not find a way of getting the SQL server to see that it is simple :) I have two tables, one with 10 records (TableOld) and one with 9 (TableNew). 9 of the records in both tables match. I wish to update TableOld with the one record that does not...

Hi all, Basicly, I need to extract the short (16bit) folder and file name into a table. If I use the parameter 'c:\' I want it to return strings like: C:\Proram`1\Kazaa`1\My~1\IN2043~3.WAV Is there a way? Thanks Derick

Hi All, I am trying to cerate a *.bat file but I need to somehow get a list of the files in the short name format. I have used dir /X and this brings back the name of the files in short, but I also need to get the name of the directory in short?? I am using a .exe where I need to place the...

Hi All, I have a job that runs every morning at about 04:00 and about 30% of the time, when I arrive at work the job is still 'executing'. I then have to stop the job and re-start it, and 60% of the time it works fine. When it runs correctly it only takes 1 minuet.... Is there a way to say, If...

Hi All, Thanks for taking the time..... I have a form in an asp page and as a security messure would like to Prevent people pasting information. This means that they have to type it out every time. Is this possble? Thanks alot again, Derick

Hi All, BASICLY: I want to have an Item in a list box selected automaticly? FULL: I have 4 list boxes next to each other. (Left to right) In the fisrt box you have 5 items, if you select one item, it brings up the relevant options in the second box, If you select an item in the second box it...

Hi All, Thanks for taking the time. I have a Database that imports all the folder names from a specified place and puts them all into a single column table. I would then like to go through each of these folders and delete the folder and all contents. So the original folders contain many more...

Hi All, Thanks for taking the time.... I have a table that contains two coulombs. 1) Proccess_Step 2) Expected_Time Proccess_Step is a single step in a life of a file : Step1 Send file to Manager Step2 Print Step3 Mailing Step4 Questionnaires Returned Step5 Data entry ..etc...etc.. Step20...

Hi all, I have found some code on this site that can copy a string to the clipboard : thread705-303001 It works great, just as it should. But I am wanting to copy a recordset to the clipboard. For this to happen I would like to convert the record set into a string, and then I can add the...

Hi All, Thanks for taking the time to try and help me. On out intranet server in Italy we have installed Crystal Developer 8.5 so that we can run reports. When I run a report in Italy, no data is displayed, no error msg's appear, nothing appears in the log file for the server... but the...

Hi All, I want to close a form as soon as it is deactivated. So I place : DoCmd.Close acForm, "frm_MoveToStep" on the 'Deactivate' event. It brings back the error "This action can't be carried out while processing a form report event" Am I doing something wrong? What is...

Hi All, I have about 85 tables that need to have the same query run on them. I can set up each query manualy but, this does take alot of time and if something is wrong....... The Query is : Update dbo.Customer0001 SET REF = CASE LEFT(ORDER, 7) WHEN '123123' THEN 23 +...

Hi all, A small problem that should be straight foward.... I have Form 'A' that lists all the People in the company. The user will highlight one of the names and press the button 'Summary' This will open form 'B' that contains data using a query that combines all the Persons information. I...

Hi All, The problem is very simple to explain but sounds stupid, but if I can do this then I can do what I want (which is slighlty more complicated and Harder to explain) : Say I have, 100 forms. Each form is the same but with diffrent names. Each form contains a text box, a Dropdown box and...

Hi All, I searched and could not find the answer...so I am asking.. I have two forms : Form 1 Contains a drop down box, where you can select the Persons age. Form 2 Will then display all the people who are that age. I want it so you select the age, click on 'Next >>' Form 1 closes and then...

Hi All, Thanks for taking the time..... One of the most frustrating things is once you have made a new Access Database, is having to go round to all the computers that want to use it and set-up the correct ODBC connection, through the control panel. This is a real pain if someone needs to use...

Hi Ya'll, Thanks for taking the time..... Very simple: I would like to know how to create a folder by just pressing a button from within a form.... Thanks alot, DerickD

Hi all, Thanks for taking the time..... ;) I am wanting to gether data from a web page that contains information regarding weather. It is possible to access this data unrestricted and with no copywrite so I am asking for you help. The Data is spread over many pages and it is just a matter of...