Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Thank you very much.. I'll try that to see if it works.

I'm working on an application for employee performance reviews. I have a form that records employee sanctions and even prints out the document based on sanction category chosen. However, besides the sanction table, I have a Tardie/Abscense table which I would like to add a record to at the...

Remou, thank you very much! worked like a charm... have a nice day...

I've searched all forums and can't find anything similar, so sorry if this has been discussed before. I have an employee table that has a Children yes/no field. On the employee form I have added a children subform as a datasheet. I'd like to make the subform conditional, that is, if I check...