Search results

Thank you for your reply. By securing I had intended in creating a new workgroup file with users. I have only worked in Access 2000 so far and currently have a database ready to upgrade. I was going to upgrade to Access 2002 and new create a new workgroup file & secure. I presume the steps to...

I have been asked to build a database to be used in Access 2002. I only have Access 2000 but can 'borrow' a PC with 2002 briefly. I was planning to build in Access 2000, upgrade in Access 2002 and then secure in Access 2002. Reading some of the threads I presume it would not be advisable to...

Hello, I cannot get my mind around this problem. I have a Client form and linked to this by ClientID is a policy records form. When the policy record form is opened everything appears to link ok. There is a combo box on this policy records form where you can select the policy type. After...

Thank you for your reply. I can see the problem with IIf as I detailed. I could use Between, however I would still have the same problem with the expression being too long/complex. Any further guidance would be appreciated.

Hello, I am struggling to write an expression. I have a 12 month moving average amount which is already calculated. I now want to work out a bonus amount which will vary according to this moving avearge amount. The bonus is: Moving Increment Bonus % Average 50000 20 1% per 1000...

I am looking for some guidance on how I can approach a new requirement. We have nine standard letters which could be used for clients. From a form containing the customer name and address details, I am would like a kind of selection box which users can select the template they require, add a...

ghudson, Thanks for getting back. Yes, it does seen to be working fine. The way to disable the shift key I presume is to enter an incorrect password. I have tried both: Dim db As DAO.Database, prp As DAO.Property and Dim db As Database, prp As Property and both work ok with my Access...

ghudson, I like the your solution you posted & have tried it in an Access 2000 database. What I get is the dialogue asking for the password, which when entering disables the shift key when you next open the database. Great. This remains until you disable. To disable I presume you have to...

I have a sense this may be a basic question, but i would like to make sure. I have a secured database following Microsoft's recommended guidelines. If I saved this database as a different name or alternatively copied & pasted as a new name, is anything changed particularly regarding security...

Thanks both for coming back & sorry if I have not made things entirely clear. I have had another search through this forum and have got a few more ideas. Today I have been asked for an additional groups! If you could bear with me, I will restate the problem/requirements and my thoughts now on...

I have nearly completed the security of a database. My final task is to set the permissions for each of my two groups of users. I wanted users to see and edit/add data using forms only. Likewise reports are available from a report form dialog box. One group should have the ability to see all...

Thanks for the last replies. After a few traumas, I have now managed to get access to everything using one system mdw file which is configured with two groups (Admins, Users) and one user (Admin). I have backed up everything & kept copies of the deleted system mdw files - just in case. Now...

Problems with system.mdw files Not sure if this helps my previous note, a friend who had their PC built the same time/way as mine only has one system.mdw file in c/program files/microsoft office/office.

Problems with system.mdw files Further to my previous note, after re-installing Office I proceeded to do a MS Office Update from the Web. Upon completion, I was back to where I started! I presumed after re-installing Access I need not change the Workgroup Information File as mentioned...

Shep, Thanks for getting back. I appreciate it. I was getting very concerned. I borrowed a system mdw file from a friend but received some errors. I now believe that this may have been altered. Arrrgh! I then considered perhaps the best route woild be to reinstall Office 2000, which I have...

Hi, Apologies if this is not in the correct thread and the length of the message. I am a relatively new user and have a database I wanted to secure. I read some MS help info (Frequently Asked Questions About Microsoft Access Security for Microsoft Access versions 2.0 through 2000) and went...

I have over 40 reports which users will select. Currently they have separate command buttons on a form. There are too many reports now and it looks very untidy. I considered building a combo on a new from which had as selections all of the report names. I manually added these name into the list...

Thanks for getting back. I guessed I may require more than one query and I have calculated two which provide the information: - one which shows for each Introducer their total Liabilty, total Health & total General commissions - as above for the new product area. My problem has been getting...

Thanks for your reply. I have structured my database accordingly and it ‘feels’ more correct now. I have a Product Area table, a Product type table and a Product detail table. The relationships are One Product Area to Many Product Types. Apologies if this is not posted in the correct place –...

Can you give me some advice about table structure. Currently I have: INTRODUCER IntroducerID & name, address & contact details for introducer including their target. A separate form will be based on this table. CUSTOMER CustomerID, IntroducerID & name, address, contact details & personal...