Search results

Hi. I have a query that works OK. However I would like to replace a couple of records returned with an alternate value. I would like to replace 0.0.0.0 with text "HP Procurve". I have the following that is incorrect: IP: IIf(="0.0.0.0"([qryDISPLAY_NWP_COMPUTER_SWITCH_MAPPING.IP]),"HP...

Hi. I have a table that contains licence details. LicenceAgreementID / LicenceKey / NumOfLicencePurchased Each licence agreement can have one or many licence keys, each licence key can have one or many licences I would like a query that groups by LicenceAgreementID then sums the NumOfLicences...

Hi. I was hoping for some advice regards creating Web Sites within IIS then adding a HOST CNAME record within DNS to allow internal users to enter a nice friendly url name in their web browser. Here I go.......................... I hope to create multiple intranet sites. If I create a Web...

vlookup Thanks Brian. Fourth is in the bag, very disappointing however...... Phil.

Vlookup Brian long time no speak, disappointing season. I have now imported excel sheets into access then did an inner join on part number. I do have another question however. Excel sheet has a column 'Priority'. I would like some form of combo box that enables the user to select a value...

vlookup I really appreciate that. I am waiting to receive the files this end. When I have them I will zip and post with a clearer explanation of what is required from me (or you!! :) ) Many Thanks, Phil.

vlookup Hi, thanks for the quick response. If speadsheet A & B has 10 columns and column A holds the Part Number (in no particular order) will vlookup look at every row then return the values where the part numbers are the same? i.e. S Spreadsheet A Column A row 1 Part ID was 1234 Spreadsheet...

vlookup vlookup? Any example or shall I search that big world wide thingy? Thanks, Phil.

I am hoping this is a commonexcel question and some clever person out there can advise a solution! I have been asked to compare to excel spreadsheets (containing stock information). Sheet one might have say 8000 records Sheet two might have say 1000 records I have been asked to return records...

Combine Tables Hi Neil. The database has evolved over a period of time (I am no expert but have made adjustments as my knowledge has improved). I have separate tables for Computers & Hardware as hardware is also classified as switches / printers etc......I have tables for RAM / Operating...

Tables Hi Neil. The problem I have is I have a list of static IP's. I have tables for Suppliers & SupplierProducts. I then have tables for Computers & Hardware. IP's can be assigned to either computerID or hardwareID that's why I created the allocation tables? Hope that makes sense!! Phil.

Thanks Thanks that works a treat. When I have ironed out one last issue I will post to the sample DB area (Audit Database), labour of love............ Thanks, Phil.

Thanks Wayne thanks for the reply. I will give that a whirl, shall I stick the code on 'After Update'? Many Thanks, Phil.

Normalize Hi. Firstly I would Normalize (create seperate related tables for classes, employees etc...). You could then have a class allocation table (ClassID, EMPID), you could then query this table. tblClasses (classID, ClassName etc....) tblEmployess (EmployeeID, Firstname, Surname etc....)...

Update Just had a play and a Union query appears to list all IP's that have been allocated. So can I then go a step further and prevent allocation of an IP already allocated? Hope I am making sense! :) Thanks, Phil.

Hi guys, back on the development trail!! I have a database, the 3 tables of current interest are: tblStaticIP (IP) tblComputerIPAllocation (ID - IP - ComputerID) tblHardwareIPAllocation (ID - IP - HardwareID) Realtionship via IP (no RI enforced). I would like to be able to list all allocated...

Thanks Ted I will have a play and report back. Regards, Phil.

PDF from cmd button Hi Ted (sorry for hijacking this thread)!! My brother has requested I do simliar for him. Currently from a sales order form he hits a cmd button that allows him to preview his formatted report. He can then hit send as email attachement then select format to send in (rich...

Example I have posted an example database, hope it helps. The password is set to: 123 Phil.

The choice is mine then........ Neil I am always confusing myself!! :) The choice is mine then........just need to make a decison then stick with it!! Phil.