Search results for query: *

Hi All, I have a filter in my report which gives me a Dwell time of how long a Asset has been in a location, dead simple it's current_date - [TRANSACTION_DATE], however when this is displayed on the report it gives something like '4956 days 9 hours 1 minute 39 seconds' against a record, I have...

Hi, I have a Variable field that I need to set to a Date input in the format of dd/mm/yyyy, so if an end user puts in any other format it displays an error message. Cheers

Thanks for the help finally got it to work. Cheers, Nickotine.

Hi thanks for the reply, I did forget to mention that the field i need to remove the last 2 characters is a varable length.

I have a field which I need to remove the last 2 characters from. I.E. 123h456789d-C1#* this needs to read 123h456789d-c1 I have tried Trim and Left to no avail. Help Please. Nickotine.

Help Please. I am trying to insert Multiple values in a LIKE statement, I.e. select object, bin from ourhouse t where t.rowid = :rowid and bin = '*' and store like ('EL%','TA%') I keep getting a message saying Missing Right Parenthesis. Thanks in advance.

I have been asked to replicate a one page Form. I need to create 4 pages, each page is a different colour. I have created the Form in Crystal and now need to, on print produce a different colour for each page of the same Form. Please help. Nickotine

Hi everbody, I have a simple Form (4 Fields) which reads from a table, how can I make this Form on a New record. Please Help. Thanks, Nickotine.

Phew, I don't know what all the fuss was about! Entered the bios set the 'INIT DISPLAY' to AGP, rebooted, P&P detected it, Installed drivers and away we went. Thanks. Nickotine

Hi I need help to disable the on-board video chip, as I have purchased a New Video card. I have a HP Pavilion 710 the Motherboard is a ASUS TUSL-L I've been trying to find a Manual for this motherboard but to no success. I've tried the HP website but to no avail. Please help Nickotine.

Absolutly Brilliant, Thanks for the reply it worked!! and am I happy. Cheers, Nickotine.

I am using 'Oracle version 7', I am querying against 2 Tables, the join between the tables return more than one matching row from the second table, the records in the second table contain a date/stamp, I only want to select the row with the latest date/stamp. Please can you Help.

Thanks Jim I created this form (name, age) as a test on the original where their are 4 fields: - Charge number delivery note number temp number No number inputted If any of the first 3 fields are inputted then the 4th field I want to be able to lock (no number inputted) Nickotine.

Hi Problem, I've got 2 fields in a Form (Name & Age), what I want to do is: - once a name has been entered I want to automatically lock the age field so if anybody try's to enter a number value then the field wont allow input. I've tried this: - If name Is Not Null Then age . Locked = True...

Hi Bob, Thanks for the reply, but I still have a problem the Formula doesn't seem to work. This is what I did. Created On change Event Procedure on Field1. Used the Formula and Tested but it didn't Lock Field 2. Both Fields on the Form update the same Table.

Hi, I want to be able once a value has been entered into a field on a Form LOCK a different field on the same Form to prevent data entry. What would be the best solution. Expression, Macro? and most important how do I do it? Cheers, Nickotine.

Thanks to everyone who replied to my question, went into the BIOS and disabled from there, installed new Sound Card and worked perfectly. Easy when you know how!! It's like adding another Sweet to the Jar!! Live long and prosper. Nickotine.

Hi, I've just acquired a Sound Blaster Live! 5.1 Sound Card and I want to disable the Integrated Sound Card on the PC, the PC I have is a HP Pavilion 710 how do I do it? Cheers, Nickotine.

Hi, After a lot of fidderling I eventually got it to work. Thanks for your help Nickotine.

Hi, I have a Date field in Access which is Medium Date Format eg. 01-Jan-02 ('an' in lowercase). I require Medium Date in Uppercase Format and the Year in 4 numbers eg. 01-JAN-2002 Please can you help Nickotine. (-: