Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Quotidius

    How to change Tap Captions based on a control

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

    How to change Tap Captions based on a control

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

    How to change Tap Captions based on a 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...
  4. Quotidius

    How to change Tap Captions based on a control

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

    Setvalue on a multiple tabs with the same procedure

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

    Setvalue on a multiple tabs with the same procedure

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

    Any chance of saving this corrupt db

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

    Any chance of saving this corrupt db

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

    Any chance of saving this corrupt db

    705-875253 it is. Thanks.
  10. Quotidius

    Any chance of saving this corrupt db

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

    retreiveing Workgroup user id

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

    query dynamically based on a user id

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

    retreiveing Workgroup user id

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

    retreiveing Workgroup user id

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

    query dynamically based on a user id

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

    Security within a table of records

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

    Security within a table of records

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

    query dynamically based on a user id

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

    query dynamically based on a user id

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

    query dynamically based on a user id

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

Part and Inventory Search

Back
Top