Search results

Good luck with it. I still suggest you look into normalisation - it will save you headaches in the long run; and the sooner you do it the easier it will be. Add an index to the FK field, and I'm sure you'll find performance is acceptable.

Are the fields you listed the only fields in each of your tables, or are there others? If they are the only fields, then you should consider reading up on database normalisation. Even if they aren't, you should perhaps still read up on it. A better structure may be:- tblResearchMaterialType...

The type of query you are looking for is termed a Union Query. MS Access help is reasonably good on this, once you know what to search for ("union query"). HTH Regards John.

Of course I had the realisation this morning that if 'Person' was a member of 'Group' which has permissions, and 'Person' has a copy of this security file; then 'Administrator' removes 'Person' from 'Group'; 'Group' permissions have not changed, and 'Person' uses private copy of Security File...

It might be more efficient to have the user type in the postcode (easier to type correctly than a suburb name), then use a cascading combo box to select the suburb from the list of matching results. You could also do it the other way around, but this might result in frustration with difficult...

This is not something you need to solve (if you have PROPERLY secured your DB). As I understand it, that is incorrect. The security file houses the users, passwords, groups, & user's group memberships; not the rights of those users or groups. The rights (permissions) are stored in a system...

Windows NT Wikipedia proffers an interesting theory on the meaning on NT, refer to the section in the link titled "'NT' designation".

I think that in Access 2K3, it is no longer a seperate exe. Rather from Access itself look under the Tools menu... Tools\Security\Workgroup Administrator.

Your design does not conform to the rules of database normalisation. Do a search on "normalisation" and read up on it - understanding and adhering to these "rules" will save you hours of pain later that a poor design would otherwise inflict.

1) It is unusual to dimension Integer variables using a name prefix of "str". Many would expect this prefix to indicate a string type variable. This possibly prompted the first reply. 2) What type of query is "B9DC_QTR1-2"? e.g. select, update, append, make table... ? HTH Regards John

Hi All, I'm having a strange problem happening here - I am using DSN / ODBC linked tables in AC97 to an oracle back end DB. Some tables open up fine, however for some other tables (on the same Oracle DB) when they open, AC97 displays all records as "#Deleted". They quite simply can't actually...

So you didn't like option 1. What about option 2 or 3 ? Not if you set it up right. Create a workgroup file on the network - you can put it alongside the database. Create a shortcut for your users, and use the command line options to specify use of the workgroup file you created. Search...

This is a duplicate post of This Thread. Please don't duplicate post.

Why do you say it is "not good”? If you construct this correctly, using Group Accounts, and granting the required privileges to the appropriate group, and making individual accounts members of the appropriate groups, maintenance will be much easier than the headache you will be creating if you...

You need to define a join between the two tables, to tell Access how the information in one table relates to the information in the other table. Adding two tables to a query without a join results in a multiplying effect - aka a "cartesian product" or "cross product" (every combination of...

Why doesn't Oldsoftboss's reputation read... "Oldsoftboss is on a distinguished bumpy road" ?

CodeContextObject Could you use CodeContextObject.Name See example (AC97) attached.. three forms, one common module HTH Regards

Not certain about shortcuts, 'cause I typically use a shortcut to a DOS type batch or cmd file. However... somewhere your shortcut specifies something like... /wrkgrp "G:\YourDBFloder\YourSecurityFile.MDW" you can add the /user after this e.g. /wrkgrp "G:\YourDBFloder\YourSecurityFile.MDW"...

I trust you are launching with a shortcut that specifies your security file ? You can use the /user switch without specifying a username, which will present an empty Name field in the logon box. However this has the side-effect of placing the cursor in the password input box, so users have to...

??? I suspect allan57 Probably intended If Format(Now(), "yyyymmdd") > "20060601" And Format(Now(), "yyyymmdd") < "20061001" Which I expect would work... ...However - I think what you are saying about it "messing around with the date formats" is the key - the final code you posted...