Search results

This thing has been bugging me so I took another look. If you open the workbook on your machine then you can link or import the worksheets So dependant on how often the workbook is updated you may be able to get away with that and open the workbook first. The workbook will need to be open on...

Drink 3 botles of Jack Danniel's through a straw and go home early. You won't see them :D

Don't get me wrong Access has some good routines built in that are good enough for most peoples uses. It is just that it is limited and can be broken very easily. It all depends on how sensitive this data is. Also a lot of people seem to be under the impression that a badly implemented security...

There are loads of possibilities. But, unless you intend to use CLID to pop customer records then it makes no difference to the end user. They are going to interup their work to answer the phone anyway. A lot depends on what it is you actually want to do. Are you recording the audio onto disk...

Yes but why? Why not create the necessay routines for taking telephone messages in your main app? seems like an unecessary waste of sys resources too me.

No ones answered yet so I'll try. Have you investigated the 'SetFocusMethod' in VBA?

I don't think you can. Because of the way linking works, even using a routine that unprotects and the re locks wont work (at least I couln't get it to) Why do you need to protect the workbook and link it with access? Is there maybee another way you could achieve this? Explain more about what...

If your songs are stored in .pdf format why don't you just make an adobe index with hyperlinks to the songs? If you are storing documents in .pdf form how are you getting them? do you get them in that format or are you converting them yourself? If I've got youre drift right I think this is one...

That is why you create a custom security scheme. And as for a custom shceme not being secure as the native access security? what a laugh, Access security is not secure---- even mde files can be cracked with a couple of hours work. Sorry but if you really want to be that secure then a good custom...

Yes read up on emailing from access and fire the code on the 'on close' event for the form or create a command button on the form in design view and use the on click event to fire your code.

Search the forum. There are a number of solutions to this request and it has been asked and answered loads There are various examples as well as solutions including an example of how to password control items via a button. The search routine is accessed via a button on the top title block

Deleteing itself may prove problamatic without a third party script. Locking it up after a period of time or number of opens would be easier. I know there are third party programs that make this easy but I feel sure that it can be done in VBA. Try looking at the NewPassword Method in VB and...

Your school should be able to get it under their academic licence. My local college has it. If you have problems I'll go ask them for you and find out how they obtained it next time I'm there. But even if they won't cut the price of that for academic use, (which I doubt), you still pay less...

It has that effect. Try deleting both MS Access and your daughter it makes for a more peacfull nights sleep.

Another point. If this is a school project as you claim that means you are a student and get all your MS software cheaper than the rest of us anyway. So you are already being subsidised by the rest of us. Report to your head master immediately.

Also, we all know that MS software is expensive but there are other alternatives. If you wish do distribute software that you are charging for what difference does it make. The cost of producing your app is part of the cost of sale. If people want it then they will pay for it. Don't be a...

I just picked this up on another forum and thought it may generate some interest. I've signed even though I'm not an American.----if they get this one through then we're all stuffed 'cause if its passed over there then it will go round the wourld eventually. :eek: Take a look Here

There are hundreds of posts about various aspects of security in Access. Trouble is it is such a huge subject. I agree may be there should be a separate forum. Two words of warning: make loads off backups before you embark on this quest There is nothing that is more of a windup than locking...

Yes Lotus did do this and I agree with Neileg. Excel is a number cruncher and should, therefore be designed to crunch numbers by default. Problem is that Access has always been considered by MS as an additional product and so Excel has to double up. Lotus SmartSuite always included a powerful...

First; Don't feel bad about Knocking MS in a dedicated forum. I do it and so do many others if you read the posts. One way to clear up short falls is to complain and/or discuss them other wise haw would anyone learn from issues such as this. One reason for MS strst. on this may be for the ease...