Search results

But there is only one database file and it's located on the server. That's the database that should be accessing. They just should be using their desktop shortcut that points to that file in that location. When they use their shortcut the workgroup knows who the current user is but if they go...

Is there a way I can programmatically scroll through a text box horizontaly? I have a text box that is disabled and locked for editing. However, in order for the user to see all of the contents in the text box, they'd have to put the cursor in the text box and arrow to the right until the end...

thanks guys. FYI, gdogfball, you can prevent users from accessing the database from the directory or MyDocuments. I have a database now that has that capablity. If you try to open from the directory or MyDocuments it gives you an error that reads: "You don not have the neccessary permissions...

I'm requesting in advance to please be patient with me. I have searched through and read up on user level security but I'm still having a major problem. How do I keep users from accessing the database through the directory or through their "MyDocuments"? One database that I created using the...

ok .. thank you

I'm a bit confused as to where to call these functions. I copied your Public Function "SetProperties" into a new module. But I don't understand where it would be called from and where do I put the bDisableBypassKey button? on a new form or an existing form. I'm sorry if I seem slow but I'm...

Can I Kick them out now My problem is .. currently, at this very moment someone is in the database and I can't get in touch with them to have them close out of the database. Is there a way for me to kick them out right now. The code from the LogUsersOff sample works fine. But for me to...

ghudson, I downloaded the sample "LogUsersOff.mdb" you referenced in your post earlier and tried to use it with my database but I can't get into the switchboard form because someone is in the database. Do I have to set this program up when no one is in the system? Because that's the problem...

Dennisk, I did exactly what you suggested. I removed the user "admin" from the "Admins" group and I created a password for "admin". However, I am able to access the database from the directory and it doesn't prompt me for a logon. But now what I can't figure out is, I also created another...

No. I created the workgroup file and added my users to the group. I have set them up with shortcuts so I can capture who's making changes to the database by using the currentUser function. All of that works fine. What I haven't figured out is how to keep them from accessing the file from the...

Can someone help me with this issue please. I've tried everything, including removing the admin user from the Admins group. I have a database file that I want to restrict users from being able to access from the directory. They have shortcuts on they're desktops with the wrkgrp parameter...

I apologize for the additional thread. I was replying to someone else's thread so I didn't know that I could do that so I started my own. Thanks for the info.

Is there a way I can display my parameter in my report? I have a report that's generated from a parameter query. In a control I want to show what the parameter values are: Between [start date] and [end date]

Where would you put this statement? In the control source of a control? I'm trying to do the same thing.

Please Help Me!... I'm in big trouble. I removed the Admin user from the Admins account. Now when I try to open my database it gives me a disk network error. And it's giving me that error for all of my backups too. What do I do? I am going crazy.

It doesn't let me delete the admin account.

How can I keep a user from accessing a database file from the directory? I've seen it before where if a user tries to open the database from the directory without being attached to the workgroup file it gives them a permissions error. I've set the users up with shortcuts to the database with...

Maybe my last thread was a bit confusing. I used the Mid function instead of the Len function to display my string the correct way. Before my message box was returning: Or Apples Or Oranges Or Grapes where the "Or" was preceding the string. When you gave me the suggestion to use the Len...

thank you Banana for your suggestion. I did something similar. I used the Mid function to extract the Or and the space. thanks again. Now I'm having another problem that is bugging me that I can't figure it out. I've created form filters using vba before but I can't get this simple filter...

Thanks you all. But I don't need to concactenate the "or" until after the first value. That's the problem I'm having. My code puts the "or" in front of the string. I want it to display the first selection then every other item would have the "or" concactenated. My code does this: or Apples...