Recent content by Quotidius

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...