Search results
-
A
Auto pop textbox on 2nd form with same value as 1st form
OUCH ! ! ! ...thank you for tip ..I just backed it up and ran the compact and repair utility -
A
Auto pop textbox on 2nd form with same value as 1st form
:) ...Done and done -
A
Auto pop textbox on 2nd form with same value as 1st form
Done ! :) Here it is ..please advise if this is what you meant ... -
A
Auto pop textbox on 2nd form with same value as 1st form
As requested .... here it is Also, in regards to the "referential integrity" i did enforce it ... and as for the other 2 options are concerned ...i don't think I require them. -
A
Auto pop textbox on 2nd form with same value as 1st form
thats what i started to think after i wrote that .... I will go ahead and ceate the relationships ... and will leave the "manager reporting" out of it for now... sound a upload the revised db once I'm done? -
A
Auto pop textbox on 2nd form with same value as 1st form
I forgot to mention ..that the managers will report that they have completed their weekly reviews with thier employees.... -
A
Auto pop textbox on 2nd form with same value as 1st form
Managers = yes, why ...to update/add new employee tasks Directors = No, the directors will use this to view reports and activies .... -
A
Auto pop textbox on 2nd form with same value as 1st form
Right ...also .... I meant that the Hours tbl will populate the drop down boxes for Plannedhrs and Actualhrs fields ..... -
A
Auto pop textbox on 2nd form with same value as 1st form
Hello, sorry for the delay ... No, the Hours table will not contain any records per employee.... the hours table is only used to populate the Plannedhrs and Actualhrs fields .... Arv -
A
Auto pop textbox on 2nd form with same value as 1st form
Aighty ..... Here it is :) -
A
Auto pop textbox on 2nd form with same value as 1st form
Wow ... okay ... I have removed the "Users" Table I have created the "Users" Table field in the "Employees" Table I have changed all fks to "number" I do to but that is the only way I could think of setting it up .... I think it looks good ...and I noticed the change in the... -
A
Auto pop textbox on 2nd form with same value as 1st form
Ahhh shit! ...sorry ... I guess the DLookup funtion would do that ..... -
A
Auto pop textbox on 2nd form with same value as 1st form
Ahhhhh ...i see ..... So... if I understand this ..then the Roles table would replace the use of having password to access the application? but ... I would I prevent User1 (employee level) from accessing User2s (employee level) information .... -
A
Auto pop textbox on 2nd form with same value as 1st form
Well .... that was my understanding of what vbaInet had mentioned .... I'm sorry :confused:... I can change it though ... no biggie for me :) Pls advise and thank you -
A
Auto pop textbox on 2nd form with same value as 1st form
Okay .... This is what I have done so far .... does this table layout/design seem better?... Side note .... doing this exercise has already helped me more in understanding "normalization" Thank you in advance Arv -
A
Auto pop textbox on 2nd form with same value as 1st form
Good morning ...... I've starting to work on this already this morning :) ..... and I will add that...also .... I'm guessing that I would add the "Password" field to the "Users" table? ..... -
A
Auto pop textbox on 2nd form with same value as 1st form
LMAO!!!! :) You guys are funny! :) K ...first ...I am a male...and no hard feelings at all .... overall, my knowledge of access is limited ... I've been using access for 2 yrs and I have created simple apps ....and I will admit ..I go off track and start add pic's and changing fonts before I... -
A
Auto pop textbox on 2nd form with same value as 1st form
sounds like a plan ... I will start on that now ... -
A
Auto pop textbox on 2nd form with same value as 1st form
hmmm......I would like to keep them as is please .... I guess i will have to create a Password field in the Director table and Mgr table also in order to give them access to the app ...