Search results

Join the club :D:D:D But never give up Think of how much you will learn and become the guru that saved the day L

statsman Absolutely excellent advice. Exactly on the button How about putting it up as a "sticky" cos everybody even thinking about Access security should read understand and digest your 10 points L

Send me a pm and I will send acouple of documents on security that may help. Documents are too big to post here Len

Send me a pm and I will send a couple of documents too large to post here. The explain security hand how to set it up Len

There is going to be a great deal of press saying the pension funds have been hit but remember that it is really only those funds which fail completely where you will loose your pension. The value and therefore the %funding of pension funds goes up and down all the time depending upon where it...

Just offering a pen'th Moving data from one table to another is a disaster waiting to happen. I am currently dealing with exactly that situation, It is a nightmare. Customers and Incidents says to me Customer can have many incidents One of the attributes of Incident is Status...

Gary No idea about folders question but just a little thought. If you use a naming convention for the various files that includes the Record Reference then you may be able to get away with a lot less folders. I did similar sort of thing with 60,000 drawings. I used the Drg prefix as the...

I think the problem is that there is so much hype about getting the best/latest thing now. This is easy to resist if you do not have the money but organisations are so anxious to lend you money and they make it so easy. This is where institutions who are supposed to be so clever with money...

Being an old'un let me tell you about the good old days To get a mortgage. 1) You had to be an investor already otherwise they would not even talk to you. 2) Maximum was 3 times gross basis salary 3) You had to supply a payslip to prove your salary 4) You had to declare all other loans, hire...

You can tweak the shortcut to call the correct MSACCESS.exe L

Okay I understand what you want to do but at the moment neither you nor others have been able to offer a solution. My thought was that a work around would be to configure say 4 separate charts that were basically the same, with the same source but the major axis setting would be different...

Basically you want an unsecured database to extract data from a secured database. That totally destroys the principle of a secured database. If it can be done then either the security was not set correctly or access security has a hole in it about as big as the universe. len

Just a thought After grabbing start and end dates calculate teh number of days (date2-date1) and then use an if statement to fire of 1 of say 4 identical (except for X axis) charts. Maybe not the slickest/smartest/cleverest but it might work Len

Search on Audacity. Only about £15 lead from headphone to mic or soundcard Software easy to use with edit cabalities. Used it myself, Very simple. Will look for a link Len

I do not generally invoke Access Security. However to keep out the curious I 1) Disable By Pass Key 2) Restrict Start Up Properties 3) Custom Menu Bar giving only what is required. All these you have done. I do not use password because anybody who learns password can open although you have...

Okay so I am like Rich 60 ish and from the UK but the years have been kind. I look younger than Rich actually. Ken that number of posts wherever is a great achievement. I have enjoyed (sort of sometimes) from afar your post in all areas of the Forum and indeed learnt a great deal. We all...

Remember when Imoved into the management area. I had so many people wanting me to attend meetings I started blocking out my calendar with private meetings with myself. That way I could get some work done because the rules where 1) Nobody overwrites a meeting entry, 2) If its not on my calendar...

Can you not place all the tables in one Repository database Then all data is potentially shared and DB1 can see and use DB2 data without DB2 being open at all L

Mailman That hit the spot dead centre Much appreciated assistance Thank You Len PS Added to reputation but will not let me do it twice cos that's what it deserves

mailMan getting there Dim Var As String Infast _part is field on main form that represents the record I want to immediately return to after the requery Var = Me.Infast_Part Requery DoCmd.FindRecord Var, , True, , True This does not work because I think the Variable holding the Infast_Part...