Search results

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

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.

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

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.

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

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

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.

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

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

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

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

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.

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

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

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

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

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

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

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

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