Check Software installed does not exceed licences

[psbrown]

Hi
Background
I have a inventory database for our computers, I am trying to tie in the software licenses to make sure we do not exceed our qouta.

I have created a table (call it A) with a softwareID and the quantity of licenses we have.
I have Created a table (call it B) that ties a computerID to the SoftwareID.
I have created a query (call it C) that counts the number of SoftwareID's in use and contains the fields Software and CountOfSoftware.

I want to create a form based table B that when you enter the softwareID against the Computer ID some code checks query c and flags that the qouta of licenses has been exceeded.

Any help would be greatly appreciated

Thanks

Paul

 

[ZmrAbdulla]

Look for "DSum()" and "DLookup()" in the VBA help file.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Seek counsel of him who makes you weep, and not of him who makes you laugh.

 

[psbrown]

Thanks for the guidance I have used the dcount function to determine how many licenses there are in table b and assign it to a variable (Call it varA).

I now want to assign the value of a field in table A (Call it FldB) to a variable Call it VarB where a field in table a (Call it FldC) is equal to a txtfield on my form so I can do a comparison between VarA and VarB

Could anyone please indicate what functions/sysntax I should be using to acheive this or where I should be looking.

Thanks

Paul

 

[PHV]

varB = DLookUp("FldB", "[table A]", "FldC='" & Me![txtfield control] & "'")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886