Search results

Thanks for the post man...................................................................................

Hi. if anyone has the MS Access database which includes the Employee, Project, Department, Works_on, Dependent tables, plz post here... Thanks.

Thanks very much...

Hi everybody, I created a Tracking Database in Ms Access, and then My supervisor asked me to make the report too, means as the following format of attachment, how it is possible to be done in Ms Access? See the attachment...

No, Just I want to know, if Use like I mentioned before, then what is the difference...I want to know more...

Thanks for the code... If I dont provide selfjoin, and just add a field Named "Supervisor" which keep the staff code, and then use the following query SELECT * FROM tblPersonnel WHERE Supervisor = 'Criteria'; then what is the difference???

Look I did as you mentioned, and link u posted, but: 1. is it possible to enter the last supervisor which does not have supervisor here 2. Then in this format, we should enter first all the sub-staff, then sub-staff supervisor, ...and at last the big-supervisor, because I want the supervisor...

Thanks for replying, Then How can I provide relationship, I mean many staff may have one supervisor, and that supervisor and maybe another supervisor again has one supervisor... May I request you be in detail plz?

Hi again everybody, I could not arrange and make the tables, so I attached everything...any help ang guide would be appreciated. Thanks

Thnx again

thnx for quick replying, may I request you just attach a sample?

Hi, I want to create a database for the staff of a company, the attributes of the staff are (Code, FirstName, LastName, ContactNo, DateOfBirth, Position, Department and so on), now many staff has one SuperVisor, and that SuperVisor, maybe other SuperVisors has a SuperVisor, and again that...

Thanks a bunch UMH, It works perfect...

Sorry for posting again, Anyone here guide and help me through this...Specailly Mr. UMH

Mr. UMH, May I request you kindly post the solution plz...Because I am really in need of that...

Thanks Mr. Brianwarnock, Here they want their database in excel, so I want to make it in excel sheet now...Thanks for ur advise

Respected UMH, May I request you kindly post the solutions, because I am really in need of that...

Hi. Suppose I have the following UDF, which returns the width of the column, but when the column width change (increase or decrease), the UDF is not able to recalculate the column width...what should I do? '**************** Returns the column width of the active cell. Public Function...

Ok...As you see reasonalbe do it, just please put comment on every line of VBA code if possible, that would be your kind... Now I am doing this in Excel to have a prototype for testing, then I will do it in MS Access...It is used on a single computer... Thanks for ur nice idea...

So in summary you want the largest ending digits for any given type and location ? yeah, I need just the ending numbers, not in middle and start if there is any... What if there are none for that location or type ? Then there wont be any inventory in the database, just we record the inventory...