Search results

That makes very good sense. I'm sure there are examples so I'll do some digging and try my hand at that too. Something to point out, is most users utilizing this initial project aren't that savvy "programmatically" speaking. So if I can restrict them to most of the items that can be found by...

In the Validation Rule put this: Like "??????????" In the Validation text put something like this: This text must be exactly 10 characters long

Here's Mine that seems to work well. Stores in a separate table.

Can you elaborate a little as to why it might be unsafe? I assume it's because of the potential to have it migrate to the application? What other methods of not allowing "X" can you suggest that would force users to use the menu I've created? Thank you Also - Here is the app with that code...

Probably not. I know it's too easy to discover/figure out. Thank you

Hi Everyone, I've been working on this for a while now and I think I am at the point where I am ready to have it tested. So I am asking you guys/gals to shoot some holes in this so I can correct them. Attached is my security mod / login. I believe it's more for keeping most users at bay and...

'Set objRecurPattern = .GetRecurrencePattern 'With objRecurPattern '.RecurrenceType = olRecursWeekly '.Interval = 1 'Once per week '.PatternStartDate = #7/9/2003# 'You could get these values...

Well, here's a little update: The code works fine in these scenarios: WinXP - Access 2000 - Outlook 2000 WinXP - Access 2003 w/Runtime - Outlook 2000 WinXP - Access 2000 - Netscape Email WinXP - Access 2000 - Outlook 2003 WinXP - Access 2003 - Outlook 2003 WinXP - Access 2003 - Mozilla...

Hi all, I've searched the net and forum and found no real solution. I have a client who is getting this error when trying to send a report. Not that it matters but my exact code is: DoCmd.SendObject acReport, "rpt_JobReport", sFormatName, "", "", "", "", "", True, "" My client is in...

The FE will be MDE. Using separate FE files doesn't seem to be a good fit for this application. I may be wrong though. I'll have to think about that a little more. Thanks guys.

Good point and I see where you are going with it. Yes it is. and yes it is. Another hole to plug. LOL. In theory, the users with the exception of the admins, should not be able to tell the app is split. So what I am doing is really over kill. As long as I can keep them from getting to the db...

Well, I am not sure, I generally don't use the On timer event. Personally, I would tie it to a command button that the users would be using (such as add new record). Odds of them clicking the button at the exact same time would be slim to none. Not to mention, the time on most pcs where I work...

When I want to do something like that, and only have something occur once I use what I call "tblEvents" where I have 3 fields (RecordID, EventName, EventOccurence) Then when I call the event, in your case exporting a report I would have a table entry like so: RecordID = AutoNumber EventName =...

Hmmm.... now there's an idea! :p Got any ideas on how I can code that in?? Haha.

Sounds like it's not really worth it to do what I am thinking of. I'll just let the admins enable the bypass key and disable it on every start up. That will take care of what I want to do anyhow. Like I mentioned previously, I was just trying to circumvent the need to re-open the db. I usually...

Yes I can do that. I just need to disable the access to them.

I have a pretty good setup (I think anyway) that I can specify access to forms based on the user level. Seems to be pretty solid though I am not done with it. One of the open items is the subject of this thread, allowing admins the correct menus/toolbars. I'll most likely end up toggling this...

That's what I thought too. Was just wondering if there was a way to refresh the current DB while it's open to skip all that. The shift key is also disabled at startup. I only allow the admins 1 time of opening with the shift key (unless they manually set it each time they close the DB). I'll...

Well I am turning them on as the admin logs in. or are you talking about something else? I presume I could hide/unhide the menubars/toolbars depending on which user level is logged in, but I also want to limit which user level can/cannot change toolbars etc.

Hi all, I am sure there is a much simpler way to do this, so any advice is appreciated. In my security module, I set the following at startup: ChangeProperty "AllowToolBarChanges", DB_BOOLEAN, False ChangeProperty "AllowShortCutMenus", DB_BOOLEAN, False ChangeProperty...