Search results

query your crosstab query with a select query and put the parameters in the select query..... perhaps L

If you are worried about them deleting then you can take away the Delete, that's okay You do also need to consider that Edit facility can effectively screw records as well. Like delete you will perhaps never know a record has gone until you specifically look for it. An incorrect edit, How...

Got a couple of documents (too big to post) on security that may give some help on how to correctly set up security which may offer some help. PM me with an demail address and I will send. Len

Also do not give then Edit or Delete within the database. View only. BUT not at network permission level. Needs to be controlled inside the database L

Just when you think you have tried everything and post on the forum you see the error of your ways This Forum helps in many different ways Len

Have an opening form prompting for user ID and password Have a query qry_Password uses then inputs as parameters Trying to use DLOOKUP to determine if credentials supplied match query results. i.e. Does query return a record Basic first part of Event procedure as below If Not...

Col..... Essex .....subtle. Only three words but the implications could be beyond the comprehension of mere mortals. L

Another vote of thanks from here L

That swings the discussion for me Len

Doc Man Excellent explanation as usual Only comment would be that setting up as you describe is fine for such gurus as yourself but if you are handing over to somebody else to support who is not on such a plane then getting their head around that method could be a touch difficult. Having...

Many to Many relationships are always decomposed into two 1 to Many relationships Take the primary key from the participating tables and put these into the linking table. There them become the primary key in the new table (Composite key). They are also the Foreign keys to which the...

Now I am not an expert on MTBF but was asked to do this myself and was told that the method of calculation was: (Tried to put it into your situation) (Latest Open Date minus Earliest Open Date)/Number of Open dates Took a number of queries to get there Query 1 Select Min Open Date and S/N...

I generally just dreate a report in Access. That way if it is a standard letter I can create them on demand with no exporting, merging or other bits that can go wrong L

Keep doing whatever you are doing cos its working.... good news.... keeps you going L

In truth what happens with every Access database is that you open it as a secured database with full admin rights by default. So every Access Database is actually secured.... but everyone by default is an Admin User This is controlled via the System.mdw file. You never use the System.mdw file...

Send me a PM with an email address and I will send a couple of documents that explain security If you just ran the security wizard that was the first mistake. Okay it is not totally bombproof but you can control matters to quite a high level Cannot post the documents here as they are too big L

Forgot to say Yes you can use Access 2004 to directly access a Sharepoint Site and do all the things you can normally do But that is Access to Sharepoint not Sharepoint to Access L

Think you could be up the creak without a paddle here My belief and I could well be wrong is that Sharepoint is a bit of a dumb FE. Yes you can look at data but I do not believe that you can say run a parameter query from the Sharepoint end and get a result in the same way as you would in...

I suspect that you need to specify the link as a full path something like \\webserver\sub folder\database name I have databases using tables linked from a web server and this method works fine You do of course need full network permission to get to the web server L

At time I believe that people think this is a free Application Development Site rather than a bunch of people giving their time free in order to help others who are trying to learn. L