Search results

Found it easiest to digitally sign. My users have PKI/CAC infrastructure so they can trust my app without any problems.

Solved! Figured this one out...had some code on startup that was only running for certain circumstances so it was running on one PC and not the other. It was creating tables during startup and I guess when you create tables at run-time the object browser displays. I've since changed my code...

I've added these keys/values and still get the warning? Might these keys/values be stored elsewhere? Are other keys/values involved in the process?

I too am looking for a solution to a similar problem. I have tried manually adding trusted locations, changing allownetworklocations to "1", changing allowuserlocations to "1", and nothing is working. If anyone knows the appropriate registry changes to make please post.

I too am curious. Our computers are set up so that users cannot tamper with security settings, trusted locations, etc. and I'd like to modify the registry during database startup to allow the macros/code in my db to function without warnings etc. There should be a way to do this but I've no...

Well...the object browser seems to want to stick. On one computer I checked 'Display navigation pane', restarted the database then unchecked 'Display navigation pane' then restarted the database again and it was gone. On another computer I did the same thing but the object browser stayed! Any...

This may seem silly, but say you are opening an ACC 2000/2003 db in 2007 and only have 2007 on your computer. Is there a way to modify your custom 2000/2003 menu bar via 2007? I see a lot of posts stating that you have to make the manu bar changes in a previous version of ACC but so far no...

Great! I've commented out my SetOption lines and now it's gone. Now in design view, is there another way to view the database objects besides how they are on the left?

See that's where I'm confused. The box is already unchecked but the navigation pane still displays? I currently have this code in the first form that opens then closes upon db startup that sets database options for ACC2000/2003. Not sure if they all apply to 2007 but they all seem to be...

This may seem silly and I've seen no mention of it in this forum yet but the "Database Window" from previous versions of Access is now called the "Object Browser"? I had code to hide the database window on startup but can't seem to find a way to hide the object browser on startup. Any ideas...

Is there any way to set macro/code/trust settings via code or registry settings? My admins have all this disabled (greyed out) so my dbs don't work correctly.

My admins have blocked users from changing their macro settings (greyed out). Any way to change to "Disable all macros except digitally signed macros" or "Enable all macros" via the registry or code? I have no problem signing my code.

ghudson, The workgroup method you posted; I can't get it to work. I am logged in to the workgroup as a user with admin privs but it returns that I'm not? How to grab a list of groups within the workgroup and then the group(s) that the currently logged in user is a member of? SOLUTION...

Environ("workgroup") returns Null and no Environ property will return the workgroup. The following code will loop you through all of the available Environ properties: Sub showenviron() Dim x As Integer For x = 1 To 33 MsgBox ("Environ " & x & " " & Environ(x)) Next x End Sub The following...

This is a great way to cycle through the Environ("") options available. Is there a way to get this type of result using API calls?

Funny...after restarting my computer the problem went away.

Hello all. I'm having a problem with editing form code at times and cannot figure out why. I have a backup copy of my DB so I keep trying it but always seem to run across the same error eventually and then losing all of my changes having to start over again with the backup. The error seems to...

Great. That's a little more work that I was hoping for but it works. It's funny that the existing image controls wouldn't let me remove the image path. Thanks for your help!

I'm using the IMAGE control from the TOOLBOX toolbar. It won't let me add the control without selecting an image to display. When adding the control and CANCEL is clicked as to not add an image, the control goes away with the file location dialogue. Should I be using another type of control?

Seems Easy Enough; But No Error Number? DCrake, The solution provided seems like a great way to alleviate my error problems. However, there is no error number displayed. Only an information message stating: "[DB NAME] can't open the file '[FILE PATH/NAME]'." Is there a way to find out what...