Search results

  1. scouser

    Calculate Warranty Expirary Date

    Back on the development trail............ So what do I want to achieve? I have a form frmHardwareEntry based on a query qryHardwareEntry which in turn is based on a table tblHardware. I have a field in table hardware 'Date Purchased'. Within the frmHardwareEntry I would like to add a field(s)...
  2. scouser

    Computer Disposal Best Practice: Table to Store Retired Hardware?

    Thanks Thanks, I will look into that tomorrow. I must confess that I am a soft southener........my dad is a scouser, lives in Bootle......can never think of a good name for forums so tend to use Scouser!! Red thru and thru mind :) Phil.
  3. scouser

    Computer Disposal Best Practice: Table to Store Retired Hardware?

    Hi guys. I have been working on a database to store network information, computers, software etc...... I have a table (tblComputers). I allocate computers to users on the network. My question. When they come to the end of their shelf life I have the option to delete them from the database...
  4. scouser

    AfterUpdate Event

    England in Europe I can't see many Mancs cheering Liverpool on............... I was right behind Arsenal last year as I was Bayern Munich in 99:D Milan are a class act, however we will not give them a 3 goal start this time round.................. Phil.
  5. scouser

    AfterUpdate Event

    Europe What a shame. Still only the truly GREAT teams triumph in Europe......... :D
  6. scouser

    AfterUpdate Event

    Common Event More common than I would like!! However we were the better team at Anfield & still lost 0-1..............bogey team........ Shame we will never find out COME ON MILAN............. :D
  7. scouser

    AfterUpdate Event

    Db Brian the answer you gave is sufficient for my needs. I was in a pub surrounded by Chelsea supporters......amazing how brave you get after 5 pints!! I am also hoping for Milan as our record against MU is not so good.....plus I would NEVER get over losing to them!! Many Thanks, Phil.
  8. scouser

    AfterUpdate Event

    Get In GET IN................is this becoming a football post? What game was Mourwhingio watching? Best team won I feel on the night. Feel free to argue. :D
  9. scouser

    AfterUpdate Event

    Thanks Thanks Brian. Lets hope tonight goes as well!! Phil.
  10. scouser

    AfterUpdate Event

    License ID Had a thought. Maybe the code is being driven by the software ID. So if: SoftwareID 40 has 2 licenses associated to it: License ID 1 = 50 user License ID 2 = 5 User So if I run the licenses down for license ID 2 but there are still licenses available for software ID 40 then the...
  11. scouser

    Help!

    Post Post your current DB with a description of what you want the DB to do and I will have a look. Phil.
  12. scouser

    AfterUpdate Event

    Head Spinning Brian my head is spinning. I have spent 2 days solid on this DB trying to improve the licensing side of things!! Every time I thought I had it I found a flaw. I had that many versions I didn't know what query was doing what!! Nearly there.....no more improvements!! Phil.
  13. scouser

    AfterUpdate Event

    It works I eat my words. It does work (kind of)? If I allocate license 1 down to zero but license 2 still has 5 available then the message does not appear. If license 2 reads 0 then I allocate the last license 1 then the message pops up? I think one of the problems might be that after you...
  14. scouser

    AfterUpdate Event

    Good Effort Gemma good effort. No errors. However the message does not appear? Just allocated down to -1. Any thoughts? Phil.
  15. scouser

    AfterUpdate Event

    M...... Can't even bring myself to utter the words............. Joking aside you have to admire United & Chelsea. Liverpool have spent a fair bit over the past 6 years......just not well.......... Not sure on the query as my ideas are great but execution CRAP!! DLOOKUP would sound like a...
  16. scouser

    AfterUpdate Event

    Trying 2-1 and we are out so lets try 2-0 :D Thanks for trying Brian. Phil.
  17. scouser

    AfterUpdate Event

    Game Pessimist.....can't see Chelsea NOT scoring. Can we get 3.......only if Robbie plays!! OK. The code returns as error: Object Required: Private Sub cboLicenseID_AfterUpdate() If (qryALLOCATED_LICENSE_AVAILABILITY.Available <= 0) Then MsgBox "You must purchase additional licences" End If...
  18. scouser

    AfterUpdate Event

    I would like to put a check on a field on a form. The user selects a computer they wish to allocate software to. They then select the Software and finally the license associated to the software. After they select the license I would like access to query a query...
  19. scouser

    Query to Return Computers without Allocation

    Two Days Later OK, after nearly throwing in the towel I edge ever closer to completion. I have created 2 new queries: 1) qryLICENSE_ALLOCATION_STATUS (96 records) 2) qryLICENSE_AVAILABILITY_STATUS (96 records) 1) Displays list of Software / License 'Allocations' displaying a zero value if the...
  20. scouser

    Query to Return Computers without Allocation

    Spoke to soon....... There is a design floor. Unresolved. I will post back if and when I manage to fix it!!! Phil.
Back
Top Bottom