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 Rhinorhino 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: *

  • Users: nickotine
  • Content: Threads
  • Order by date
  1. nickotine

    Format to display Years & Months

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

    Date Input

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

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

    Multiple Values in Like Statement

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

    Pages in Different Colours

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

    Open Form on New Record

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

    Disable onboard Video

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

    Sub Query/Union?

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

    Lock Field Part 2

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

    Lock Field on Form

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

    How to disable integrated Sound Card?

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

    Medium Date Format in Uppercase

    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. (-:
  13. nickotine

    XP Content Advisor

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

    Raise of Issue on Update!

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

Part and Inventory Search

Back
Top