Recent content by hudson426

Hi all I am been searching for a while for a solution to my issue but cant find it anywhere. Any help would be greatly appreciated. Here goes.... OK, I have disabled the F11 key as well as the Shift Bypass, hidden the menus and restricted the access to the design of the forms. So its secure...

Hi I've used this a few times in my own databases Example Table1 - This contains all your email addresses (inc duplicates). Lets say that field "email" conatains all your email addresses Create a query, 1 field, email Press the Sigma (Totals) button from the tool bar This will group all...

mdlueck - Yeah, I had an inkling that was the reason. Oh hum! gemma-the-husky - Thank you ever so much for the example. Does exactly what I need. I am very grateful for everyones help on this, couldn't of managed it without you. Anyone know of a way to ensure users read, understand and...

mdleuk - I've been reading up on trusted directories and this is a big factor. If I cannot get any other solution to work, then I'll just have to educate the users. Again! I've tested a self executing zip file, but it saves it as an .exe file and Outlook wont let me sent .exe files. Bugger...

Mdleuk & Jamesmore - Thanks for this, I'll do some more digging. gemma-the-husky - My db opens a form and then writes some values at start up. This is what happens when I open my db directly from a zip file:- Security Warning - OPEN (to continue) Message - The database 'xxx' is...

Dear all I'm totally lost and confused and need some help. I send a db out once a month to over 200 users (it has to be a local copy). Because of the size of the file (and that outlook will not send .mdb files as attachments), I have to zip it up. If the user doesn't unzip the file and...

Tezread Example attached. In essence, you need to create a query that updates the relevant records. In the example, go to qryEpisodeCommentUpdate and run it, accept the warning and then look at the tblEpisode. You will see the comments have been updated. The query effectively finds...

Dear all, I need some help and advice using VBA to create a URL. I want to plot several points on Google Maps. The URL I am trying to create is this:-...

Hi I have a problem with a particular bug in access 2003 that I cannot for the life of me understand. Help/suggestions and opions are greatly appreciated:- Problem If I have a table with two columns in. Columns are as follows:- name - notes Name is formatted as text (John Smith...

Duh! (Me) Works a treat. It now does exactly what I want. I'm a bit of a newbie so please accept my many thanks for your help on this. I know it was a little painful but I am very grateful for yoru help. Jonathan

Don't apologise. In my original post, I detailed a control that counts the number of records that have been selected. I have found that unless you move to a previous or next record, the count function doesn't refresh. By adding a record refresh macro, the count is updated without the need to...

Thats what I asked. Using the code above, how do I refesh all the records? Is there a line of code I can insert to do the same function as the macro (Runcommand --> Refresh) into the enable/disble code? What code do I need to perform a record refresh?

I can't. I need to have the macro (Refresh) to run before the code can run but that macro is assigned to the afterupdate event of the select (checkbox) property. Is there a way to add a line of code to the one I am using (above) to refresh all the records before the code runs? If so, what...

Yes, I am using a check box on the Select field

Can you possibly give me an example?