Search results

Thanks Thanks for the links. Looking forward to the challenge. Phil.

Thanks Thanks guys. It is more of a training tool. I want to have a greater understanding of SQL so I thought what better way than to import a database then play about with some meaningful data. As you rightly say I can then start scratching my head over stored procedures etc...... :) Thanks...

Guys I will shortly be installing SQL 2005 in a production environment to house my companies new system. I wanted to get familiar with it prior to 'Go Live' . I was looking to install SQL 2005 in a test lab environement. I have an Access database with around 20 tables, 30 queries etc.... As...

Many thanks for the the detailed response, your time is very much appreciated. I will give a great deal of thought to the current table design. The database in question is a labour of love. I will post the revised version as a sample DB when I finally decide I can let go!! Many Thanks, Phil.

Code Guys here is what I have: I copied tblComputers as tblScrapComputers. I added 2 additional columns to tblScrapComputers: date_scrapped & reason_scrapped. I then created relationship ComputerID-ComputerID (did not enforce I referential integrity). Added a button to frmComputers then the...

Thanks for the reply doc. I have opted to have a table tblRAM which lists various configurations i.e. 0 / 64 / 128 / 192 /256 etc............... I then allocate total ram installed rather than concern myself with individual memory slots. Thanks, Phil.

I have decided to normalize further and now have brain freeze. I have a table 'tblComputers'. I have removed Computer Make + Computer Model to own tables and linked via ComputerMakeID & ComputerModelID, this is working OK. I then decided to remove RAM to its own table. I created tblRAM. I...

Sample Thanks for the heads up, I will have a search. Phil

Duplication I am the only user. tblScrapComputers would just be a holding table. Phil.

Duplication I agree regards the duplication. However it seemed the easiest solution! tblComputers is related to many other tables..........computers are allocated to users, hardware is allocated to computers, software is allocated to users, computers are allococated to network ports...

reply Hi. I currently have that set-up. However software etc.... is allocated to each computer. If i simply flag the computer as 'scrap' it does not delete related records thus free up licences. If I delete the computer object then the deletion will cascade to all related tables. Hope I am...

Hi. I have a table 'tblComputers' from which I have created a query then a form 'frmComputers'. I want to create a new table that contains identical fields 'tblScrapComputers' then add a button to 'frmComputers' that copies data from 'tblComputers' to 'tblScrapComputers' then deletes the record...

Resolved Bob many thanks for your time (not forgetting Rabbie). That has worked a treat, will sort out the licensing issue (will ask a programmer this end to have a look!!!) then post to sample DB's. Hope you had a better nights sleep than me, dam wind playing a tune through a dodgy window...

Db Bob see attached, hope I caught you in time!! Phil.

Post Bob give me 5 minutes to strip down to fit on forum!! Phil.

Be Patient With Me!! Bob be patient with me!! :) Still getting #name? in unbound field: 'Expirydate = DateAdd("yyyy", Me!WarrantyPeriod, Me!DatePurchased)' DatePurchased (Date/Time) = 01/08/2007 WarrantyPeriod (Number) = 3 Expiry Date = #Name? Now both you and I know it is ME....hope above...

Nearly There? OK. Have added new field to form 'WarrantyPeriod' (now NO default value). I input 3 (for 3 years). I have an unbound field on the form: Expirydate = dateadd("yyyy",WarrantyPeriod,DatePurchased) This displays as #Name............. so basically I have done it wrong!! Probably...

Warranty Hi Bob. Are you suggesting I create a seperate table to hold warranty information or add a new field to my tblHardware? I must admit my tblHardware could be a little better designed!! It holds data for printers, switches, monitors etc....seperate table for monitors would be good...

Speedy Thanks guys. It has been a while since I did any access work. Do I add an unbound field to allow input for the warranty length (yyyy)? I would then add the code in Rabbie post to an unbound field on the form to calculate the expirary date? Currently only have DatePurchased field...

Reply Bob speedy reply many thanks. I will have a play about and post back. Many Thanks, Phil.