Where oh where am I going wrong??

[scouser]

Hello once again. I have been working on a small database that records all IT records (Desk Info / Software / License Info / Hardware etc...) Somebody out there might even find it useful!! Will post to DB forum when working

Where to begin. I thought it would be a good idea to normalize a little more........(still not 100% but an improvement). I seperated Software/License information. I now have tblSoftware & a tblLicenseDetails.

Basically the clux of it all centers around a form 'frmDeskSetup'. You can search via three methods (Desk ID / User ID or Computer ID). I would like to amend the Installed Software Form (last form on frmDeskSetup) to include the License Information.

I have also tried to create a query linking tblComputerSoftware tblSoftware + tblLicenseDetails. My idea was to create a form that would allow users to Add Software/ Add a License for that Software and then allocate the licensed software to a computer all from one form. The query run OK but would not allow data entry via the form!!

Sorry for the length of this post. I have attached a stripped DB for forum in Acess 2003 format.
Thanks in advance,
Phil.

 

[scouser]

Making Progress

Making a little progress but still have minimum of 2 design flaws (gurus will argue plenty more!!).

Flaw 1: frmComputerSoftwareAllocation. The combo on the LicenseNum field lists the licenses OK but does not refernces the software that it relates to so pretty dam impossible to allocate it!! (struggling to combine neccessary tables via a query to get desired result)??

Flaw 2: frmComputerSoftwareDisplay. On frmDeskSetUp frmComputerSoftwareDisplay now displays the Software License Key but not the Software description (only Software ID).

I have attached amended database (2003 format).
Thanks in advance for any tips, advice.
Regards,
Phil.

 

[le888]

For first question, not quit sure what you want? See the attachement for second question.

Le888

 

[scouser]

Finished

I have managed to complete my little project (others might argue against!).

Le888 I will have alook at your DB to see how we differ, in the mean time I will post my completed effort and hope others can make some use of it.

Many thanks for your efforts Le888.
Phil.

 

[ghudson]

I have a few critiques for you...

1) Odd that you have your own custom record navigation buttons but you still display the built-in Access record navigation buttons.

2) I would hide the record selectors

3) Instead of the Continuous Forms view I would use a Single Form view and then display the related records in a subform. Then you can use the current record event to trap for data entry errors.

4) Your Software and License form is missing the switchboard button

5) You should try using popup forms instead of maximized. Then customize the size of the form to view what is necessary.

Check these threads out for some samples techniques you might like to try in your db...

A Better Mouse Trap?

Enable/Disable The Control Box X Button

Audit Trail

Record X of Y

Change Background Color

Keeping Forms the same size

Hide all Access Toolbars and Menubars

Good luck!

 

[scouser]

Comments

Thanks for the constructive comments. I will tidy things up over time taking on board your recommendations.
Phil.