Search results for query: *

All is right (the usual operator error). Thanks Remou!

Yes, Remou, the current event of the main form, the one that has the tabs. Also here is an addendum to the the last post of mine-the initial form pronouncing my error reads, " A problem occurred while myDB was communicating with the OLE Server or ActiveX Control.

Thanks Remou Using the OnCurrent Event I tried something like that (found in another thread) but I get the following problem when I open the form: "Visual Basic for Applications (VBA) encountered a problem while attempting to access a property or method. The problem may be one of the...

My mainForm is a single form that shows each employee. On the detail of mainForm are 5 tabs and each tab contains a unique subform. Each of these subforms has a control called "Core_Description." Core_Description will vary from employee to employee. How can I set tab1 caption to equal the...

That was simple and easy - but it would have taken me a long time to see it. Thanks Daniel!.

My form has a subform1. Subform1 has 5 tabs each with 2 fields: Field 1 is an employee’s score of themselves (self appraisal). Field 2 will represent their manager's appraisal of the employee. Both are option groups with values 1 thru 5. I have placed on each record a command button for a...

barny2006: I think it might have been removed, I searched by the phrase "Create new user" in the Access Modules (VBA coding) and even search by the person's handle (scriverb) and find nothing for what was originally titled "Adding/Deleting users through VBA" When I get time I will post the code...

Thanks all for you suggestions. Unfortunately, importing of the databases doesn't work. When doing so I get the same warning about the file being corrupted. JoeAtWork, I created a shortcut with this code in the path. It yields no favorable result. A couple of observations: When I was...

705-875253 it is. Thanks.

Two weeks from making my last backup I was this morning making a new module from thread 705-87253 in the Access VB forum. During the process of modifying the code that adds a new user to a workgroup my database started acting funny. The next thing I know all my form have dissappeared! The...

OH Great! I did want access' user name. You mean Environ User isn't the same? I have to recheck my work. Thanks for the heads up PHV.

PHV, currentuser was helpful eventually leading me to Environ("USERNAME"). Thanks! -Q

Thanks both of you. CautionMP, the threads you provided were very helpful. PHV, your currentuser method was somewhat problematic (owing no doubt to my own coding ineptness) but I latched onto the Environ("USERNAME") which works perfectly and also is used for my underlying query so that only...

I can find several instances of how to retrieve the a user's network id but I am interested in retrieving both the workgroupid and user id within access. I want to use a query that uses this capture workgroup id as a parameter so that users will see only records that belong to them. For a...

Guys, I hate to be a pest but I need a little more clarification in trying to streamline the application. I have succesfully implemented Golom's suggestion, making a user table (employees) with username and password so that a when user signs-on they first, are authenticated, 2nd have an...

Jsteph, thank you for well defining the complexity of what this thread is after. I think I'll opt for the simplicity of PHV's recommendation. PHV, on that topic, I also selected hide toolbars. It seems to work too well, how do I get it, the tool bar, to again show? Again thank you both.

I don't see much mention of it in any of my key word searches - I am trying to prevent users from being able to see other people’s employee reviews within the same table of a database of mine. I have successfully established user groups but the security is kind of weak for my purposes. Users...

Golom, your post preceded my second one by minutes. I will try your suggestion. One question, I have the users logging on to the database with accounts I established. So does it matter weather user_id = System User ID or user_id= workgroup user_id? Thank you

Leslie, I agree is isn't ideal but then again how can I create vertical security within a table in Access? All my data is otherwised normalized. My Thinking: One table for each employee making them the owner of it and permitting no one else to view it. This Usertable has only one field and...

In attempting to secure my database I have established the necessary users and groups. Can anyone recommend how I might be able to allow users when selecting a form to view only the rows that belong to them? I gleaned and idea from a forum here to build a unique table for each user. The...