Search results

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...

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...

Resolved I managed to resolve this once I applied my tiny brain!! I created a query to sum the licenses allocated. I then used this as part of an expression so ended up with: LicenceAvailable: [tblSoftware.LicencesPurchased]-[qryLicenseUsed.SumOfNumberOfLicences] Probably a better way, but...

thanks Thanks for the reply. That gave me an error? See attached screen dump. Must be me!! Thanks, Phil.

Hi guys. I have been away a while and boy am I rusty. I would like to show how many available licenses there are. Here is what I have: Software (Office 2003) license purchased (8) license used (2) I added an expression along the lines of: Available: Sum([tblSoftware]![Number of licences...

Reply Thanks for replying. I have been away on holiday (hence the delay!!). I will take a look at the links. Thanks, Phil.

May Help Others? Guys I have found this link that helped explain it all to me :) http://www.databasedev.co.uk/split_a_database.html Phil.

Thanks Thanks for taking time to answer. I will keep searching regards splitting the DB. Regards, Phil.

Hello. I have just started work at a new company and have been asked to 'Network' 5 different DB's to enable multiple users (around 5) simultaneous access (Dept A - DBa / Dept B - DBb etc.....) Currently if User A accesses the DB User B gets read only access. I have googled and also searched...

Hi Guys. I have taken over management of a windows server environment. The servers have been upgraded from NT to 2003 Standard. The company uses veritas backup exec for windows servers 9.1. The System State is backed up. Question. What is best policy regards the WINNT directory? Should I back...

Remove You could move the folder: C:\Documents and Settings\All Users\Start menu\Programs\Accessories remove from the user account also? Just a thought. Phil.

Thanks Thanks for the explanation. Never dealt with secured database (creating mde's). Any links on how to do it as I have MS Virtual server so I could have a play :) Phil.

Shift I actually know that one!! Tried it before posting, no luck. Yes great forum. I was quite an active member in 2004, bit rusty now! Phil.

Filter I was able to view the properties for the form when open (obviuosly not what you meant :) ), however the 'view design' option was greyed out? The user is a novice so can't imagine they would have set up a filter. The DB views fine on her other machine. Any way to way to get round the...

Filter I would tend to agree, but could not see a filter. Thanks for the replies. Consider this one closed. Phil.

Nope Looked at form properties. No filter? Form created from table. Unable to view design of form as locked. Thanks for posting. Phil.

Thanks They are viewing the records from a form so I will take a look. Thanks, Phil.

Hi guys. I am trying to help a client regards an un-supported access database. They have a DB that is shared across a network (only have experiance on database on single client, never set up security etc....). The DB is installed on the Server. The DB is access via a mapped network drive. The...

Thanks Thanks for the replies guys. I will have a good think regards your suggestions. Phil.

Thanks Thanks for the reply. From what I can gather plant hire is misleading. They just buy plant from auction and then sell it on (no hiring). They buy it, stock it and then sell it. Each piece of equipment has a unique serial number so I am told!!). Many Thanks, Phil.