Recent content by Cloyce

Thanks Bob.

Access 2010, Subform, Datasheet view....how might one disable Column resizing? Thanks.

Hello Pat, Thanks for hanging with me. My immediate problem is resolve. However, for future reference, I would like to know the best way to initiate a do-loop from a form. If an update query is the what you recommend, I would like to see an example. Thanks.

Thanks for the effort to assist. Let me run at this another way: Does anyone have sample code to illustrate a good way to do a form initiated "do loop" routine (in Access 2010)? Thanks.

Thanks for sticking with me on this Bob.... Yes, if you would please check and let me know at your convenience. Thanks again.

Thanks again for replying, Bob.... Perhaps I am not being clear. I understood the issue about "Show All Actions". My question is, once all actions are displayed, how do you use them to perform "Do until" functionality? Thanks for your time.

Thanks Bob, Regarding your item 2, please point me to the macro actions one might use to perform do while functionality....

In Access 2010, want to run perform a "do while" loop in a macro. I understand VBA is the way to do this. So, I think I want to run a VBA script in a macro. This Macro runs against a Form that has a SubFrom (MainForm named "Expense ID" & SubForm, "Expense"). Macro is initiated by pressing...

Hello Beetle, Looks like I had "AllowNetworkLocations" in the wrong place. When moved to "Trusted Locations" folder and when "AllowSubfolders" added to nested Location folder, the Security Message no longer appears. Thanks for suggesting the use of these DWORDS.

Thanks Beetle for your continued effort to assist.... Actually, the app is published via Citrix....we have done this for years with another app (and lived with the security message).... I suspect there is something about the way I am entering the path that is incorrect? Might you provide...

Hello Beetle and thanks for trying to help me..... I entered a string, with the unc path ...did not work (I am not using subfolders)... I added DWORD for "AllowNetworkLocations" ....did not work... Any more ideas? Thanks.

Hello, Launching app from a shared drive in a 2010 run-time / Server 2008 environment yields a "Microsoft Access Security Notice". Apparantly need to make the shared drive a "Trusted Location". Runtime user interface apparantly does not provide access to this functionality. I suppose editing...

Hello, This is my first post. I want to automatically send an email from Access 2010 (runtime on Server 2008) when certain data is changed on a form without utilizing an installed email client. Would someone kindly assist with code for an Event Procedure to do this? I am not proficient with...