Search results

Menu Keith Well kind of............. If you select a Menu option on the left related options are displayed on the right. You then click an optin on the right to open it. i.e. By selecting the cmd button 'Reports' a list of available reports are displayed in the right pane. Users can then...

Thanks Keith I will take a look and post back. Regards, Phil.

I would like to create a switchboard as follows: Display a list of Menu Options (text or cmd buttons) in left pane. When a user selects the menu option i.e. 'Reports' a list of available reports would be displayed in the right pane? See attached jpeg for example of my madness!! Any ideas/...

Download I have downloaded the auto update front end db. I will have a look and hopefully put it to good use!! Many Thanks, Phil.

Thanks Thanks for the replies guys. I will put your comments into action. Phil.

I have a database that resides on a file server share. I have split the database to create a backend. I then posted a shortcut of the front end to the desktops of two users who have access to the share. I then tried to access the front end from the two machines simultaneously. It opened on the...

Update The updated version is near completion (sorry for the delay). I will expalin the new functionality when I post the DB. Regards, Phil.

Still Trying!! OK, so I am no further forward but I have created another query that does something different :) qrySoftwareLicenses lists all software and the number of licenses purchased. qrySoftwareLicenseAllocated counts all license keys that have an allocation qrySoftwareLicenseAvailable...

Update I am in the process of improving the sample DB. I will post the much improved version when complete. Phil.

Getting Closer or Further Away? :) OK, so here I go again after having a play. New set of anomalies!! 1) frmComputerSoftwareAllocation. If you click in the SoftwareID field then the associated LicenseKey is displayed. When you click out it becomes invisible (mystery...wooo...woooo) OK joking...

Hi Hi Gemma. You follow my flawed design......... tblComputerSoftware is as it sounds, to hold information regards what software is allocated to a particular computer. I would like to record both the software and related license key. It does this currently by recording the softwareID and...

Db Hi Gemma. Many thanks for the offer of looking regards viewing the database. I posted the Database in my initial post 'Forum.zip' (2003 format), let me know if you need it saved as a previous version. This contains the tables & queries (stripped down version of the main DB). Phil.

Good Luck Thanks for the reply. I will need it!!!!! :D Phil.

Resolved Shades many thanks for your help. Phil.

Top Man Many thanks. Where is that on Office 2003 version? I selected 'Tools' Options then 'General' Phil.

Hi to all once again. I thought I had resolved this issue but the addition of more data has found a floor in my design. I have a small DB I intend to use for auditing my companies hardware / software. frmComputerSoftwareAllocation: Allows me to allocate software / software licenses to...

I have been asked by our sales department what generates the auto-backup of a number of excel files (configured by an old employee). I have attached a screen dump of the icons as they appear. Any ideas? Regards, Phil

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

I have developed with some assistance a small DB that allows users to record IT information: Users Hardware Software License Agreements etc........ DB opens at login form (bypass by hitting the shift key if you wish). User Name: Administrator Password: 123 Some work might be required with...

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.