Search results

Thanks Gary thanks for the reply. I will give that a whirl tomorrow (DB is at work!!) I will post back. Phil.

Not Quite Colin maybe I misunderstand or am just doing it wrong but that did not do as I wanted. tblAssetID - Fields: AssetID/Description/Make/Model/Serial# tblAssetID stores data entered via 3 forms: frmComputerAssetIdEntry frmHardwareAssetIdEntry frmSoftwareAssetIdEntry Back to my original...

Interesting Thanks for the quick reply Colin. I have been creating them manually. I will take a look at the wizzard. Thanks, Phil.

Hi. I would like to auto fill fields on a form after the user makes a selection from a combo box. I have a form 'frmComputerAssetIDAllocation' that allows users to enter AssetID's and allocate them to computers. Here users enter the AssetID and then they select the Computer that relates to that...

Thanks I will check the link, thanks. Phil.

Are you able to post? Thanks, Phil.

Has anyone come across a Help Desk developed in access? Nothing too complex. Admin to enter support request, a unique ID generated, memo fields for notes? Any sample DB's available? If not then maybe this cpuld be my nect little project!! Still got a little bit of hair left................:) Phil.

Menu Update I have modified the main menu slightly. I have included revised instructions. Regards, Phil.

Audit Database Please find attached the updated version of the Audit database. I have attached a word document to explain the purpose of the database. I have tried to implement best practice regards normalisation, however it is not perfect! Improvements: 1) New Switchboard 2) AssetID...

Resolved I have resolved this issue (to suit my requirements at least!!). I will post the database in the appropiate forum for others to make use of once the project is complete. Thanks for your help, Phil.

Sample DB I have implemented DRathbone suggestion (see attached) as I was unsure regards the query option :confused: Issue: I would like to make it so users can only assign an AssetID once and once only. So if they assign AssetID A20100 to Computer A they are unable to then assign the same...

Thanks Thanks for the replies. I will have a play & post back. regards, Phil.

Hi guys. I have been attempting to add an asset tracking function to my database. I have a table 'tblAssetIdList' which holds all the available asset ID's. Asset ID's can be allocated to either Computers from tblComputers, Software from tblSoftware and finally Hardware from tblHardware. I...

Thanks Thanks Bob, that worked a treat. Phil.

Hi guys. I have a menu 'frmMenu' with a subform 'frmMenuSubform'. 'frmMenu' has number of buttons that when clicked display related data in 'frmMenuSubform'. i.e. If you select Input Form button the subform displays all Forms that allow for data input. Currently when for frmMenu opens the...

Good Work Thanks Keith, just what I was looking for. I wasn't a million miles away :) Phil.

Thanks Top man, will take a look. Thanks, Phil.

Can't Open Reports? I made a mod after adding a report but when I double click nothing happens? Private Sub Form_DblClick(Cancel As Integer) strType = DLookup("ObjectType", "tblMenu", "[ObjectName]='" & Me.ObjectName & "'") If strType = "form" Then DoCmd.OpenForm...

Mod Keith I have managed to do modify it. Many thanks for your hard work. I intend to include the menu in a sample database I am going to post in the database forum. Many Thanks, Phil.

Thanks Thanks Keith. I eventually worked it out!! Would it be easy to mod to allow users to select the text 'Setup Information' to trigger the form to open. Regards, phil.