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

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.

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.

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.

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

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, 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. (-:

Hi, I have Windows XP and Can anyone help me with this problem, I've set up Content Advisor in Internet Options when I acquired Broadband, and also I installed Norton Firewall, for the first few weeks Content Advisor worked well, every site we went on it asked me for a password to allow access...

Hi, I'm currently using MS Access 97, the query I have is that when I update a record the report which runs from a query needs to tell the report the current number I.E. The current status is at 'Issue 1' when I update a record and run the report I need the Issue to be automatically updated...