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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by twice300

  1. twice300

    Help with Access 2003 security--Can't read module

    I have an MS Access database that I have setup security on. However using the Security module, I can't grant access to modules I have created, as they don't show on the security options. How can I grant access rights to modules in Access 2003? Thanks, G. Adams
  2. twice300

    Modules and security

    Thanks TheAceMan1 for your reply. The form does not have a table underneath it. I have a form that captures data to use as filters for a report. The problem lies with a pop-up calendar I'm using. The form has a command button, that once it's clicked invokes a procedure that shows the pop-up...
  3. twice300

    Modules and security

    I have been using a pop-up calendar I got from this forum. It works great. I believe the post is from Jimmythegeek. I added security to my system some months ago and all is well. I created a new security group for some users, as I wanted them to not be able to delete data from the database...
  4. twice300

    Problems with this query

    Thanks to all for your help. I'll try to create the table with the different categories. Although I do have to present this by tomorrow, so I'll do the IIF function now and add the table for next month. Thanks again. George Adams
  5. twice300

    Problems with this query

    I have developed a small app that keeps track of employee information. One table is Sacntions. I keep track of disciplinary measures given out to employees. At the end of the month, I need to give out a grade per employee based on the amount of sanctions given, if any. I have wrote this...
  6. twice300

    How to auto fill subform fields?

    I finished making changes to the database structure and code. Everything is working perfect now. Thank you very much for all your help. gpadams
  7. twice300

    How to auto fill subform fields?

    Sorry my bad. Yes I was working on the FE as you mentioned. I wanted to thank you for all the time you took to help me. I've decided to correct all the bad designing in the database now before this system grows any bigger. So I have some chages to make and recoding to do. thanks a million...
  8. twice300

    How to auto fill subform fields?

    Pampers, I tried creating a new employee table where the primary key in on the employeeid and created a new children table and added a childEmployeeId field, I linked these and was able to do the relationship and do the enforce referential integrity and do the cascade. I created 2 new forms...
  9. twice300

    How to auto fill subform fields?

    Thank again Pampers, I set the enforce referential integrity, but the cascade option is greyed out, I can't select it. One thing I haven't mentioned and perhaps this is causing the problem, is that the mainform has tabs, and the subform for the tblChildren is on the second tab. I did try...
  10. twice300

    How to auto fill subform fields?

    I did not have Referential integrity selected. Which one do I select? "Enforce Referential Integrity" "Cascade Update Relateds Fields" "Cascade Delete Related Fields" Also under Join Type, which option should be selected? (1, 2 or 3). If I have to alter these settings, do I then need to take...
  11. twice300

    How to auto fill subform fields?

    Thanks. I've looked at the setting you mentioned, they are set like this: Link Child Fields = EmployeeName Link Master Fields = Name If I add a record manualy to the children table, they will be filtered correctly when showing in the form/subform. However if I try to add a new record, the...
  12. twice300

    How to auto fill subform fields?

    Thank you Pampers for you quick response. Table1 is Clerks (Main) Table 2 is Children (Sub) Table 1 has the following fields: EmployeeId as Number (Indexed) Name as Text (Indexed and Primary Key) etc. Table 2 has the following fields: ChildrenId as AutoNumber (Indexed and Primary Key)...
  13. twice300

    How to auto fill subform fields?

    To all, Remou helped me on another thread in which I needed to condition a subform. Now that I have the subform available depending on the value of a field on the main form, I'm working on something else and I'm stuck. I had the subform working, but I had the subform select the employee using...
  14. twice300

    Conditional subform

    Remou, Sorry to bother again. As I mentioned before, your suggestions worked perfectly. The children subform displays if I click on the Children field (yes/no) field on the main form. I had the subform working, but I had the subform select the employee using a lookup to the Clerks table...
  15. twice300

    Update 2 tables using 1 form

    Remou, thank you very much. I forgot to reply to this and let you know that I got it working with the popup form you mentioned. thanks, twice300
See more

Part and Inventory Search

Back
Top