Recent content by mk0920

I added a macro on the open event of main switchboard to hide database window based on CurrentUser(). The macro works fine but now nothing happens when you click on the button on the swithboard. The only button that still works is exit access. I assume that my Macro is incomplete, but I am new...

Re: macro using CurrentUser() to hide database window ANY INFO ON THIS POST FROM YESTERDAY? I AM ON DEADLINE TO FINISH THIS PROJECT BY THE END OF THE WEEK. THANKS! PLEASE READ BELOW: The closed thread that you refer to is very helpful. However, since I am a complete newbie, I need a little...

Imagine that. Something that simple! Thank you so much. :DOne more related question. I now want to display certain toolbars based on user which I assume would follow the same format. How about hiding the database window for certain users? I have only found info to hide for all and then...

Making progress on my first database. Using 2003 with security. I want to display form based on current user. My thought is to do a macro with the following conditions: Condition CurrentUser()=[BOB] Or CurrentUser()=[CONNIE] Or CurrentUser()=[ENIS] Action Openform (with the specific form for...

I have spent literally hours googling and reading the 2 books I bought and reading/training on Microsoft's site. None of them address this issue. I was able to create my forms, reports, import my data from Gold Mine and set up the user security. All is well except I (the administator) need to...

I have no idea what that means. I am a new user, not a programmer.

I need to hide the database window and the design view button on the toolbar for all users other than myself who is the administrator.

thanks for your help. I hope I find it soon!

I am using 2003. Set up user groups using security wizard. To show you how little I understand...where would I put this code? In the macros area? I use a bit of Fox Pro here at my job, so the syntax of the code does make some sense. The login screen was automatically created by the wizard...

thanks for that info. it really helps. Now I have a new problem! Looking for an easy way to launch a particular form based on user group login. Would also like to know how to link a custom menu/toolbar based on user group login in and how to hide buttons that are not applicable. For...

Looking for an easy way to launch a particular form based on user group login. Would also like to know how to link a custom menu/toolbar based on user group login in and how to hide buttons that are not applicable. For instance the delete record button. Right now it shows up for all users...

Thanks for the quick reply. Right now bound column is 1. If I add the abbr column to the row source (making it the 3rd column) and change bound to 3, nothing displays in the pick list. If I change bound column to 2, the pick list displays, but when I go back to the table, the concatenated...

I am just learning Access and creating a database for my company. I added a combo box to a form for state selection. I copied code from an example in a tutorial. The row source code reads like this SELECT DISTINCT STATELOOKUP.CONCSTATE, [CONCSTATE] AS STATE FROM STATELOOKUP ORDER BY...