Hi, a colleague asked me to see if it's possible to create a warehouse database for him, so things will go faster and more efficient on his end. (yes, in the midst of my annual database project...) I tried a few things, got stuck, tried to look for information on the web but to no avail.
Anyway, here is the scenario.
3 main fields from tblMain:
Index - P.Key
Part - name of the product
Location - location...
jjkeeper
Last Activity: Sep 2 '08, 07:48 AM
Joined: Aug 18 '08
Location:
-
Thank you both!
@missinglinq, sorry but where's the link? I can't find. -
Calculating No. of Days excluding Public Holiday
G'day, I'm currently working on an annual leave database for the company, so far so good, till they want the database to be able to identify public holidays and prevent reducing the employee's balance if the application overlaps with the holiday. I'm using access 2000. Here's what I have so far.
tblMainProfile - contains employee's profile
EmployeeID <== Pkey
Name
Date of Birth ..
tblLeaveApply... -
Yes, that works wonderfully. Many thanks once again.Leave a comment:
-
Yes, the idea is there, but for mine, i put the DaysEntitled into tblLeaveEntitle ment instead of tblLeaveApply. I managed to get it to display now though. There were some problems with the way my LeaveType field in tblLeaveApply was defined. Mostly due to the wizard, and then my own editing. Now my LeaveType fields in both tblLeaveApply and tblLeaveEntitle ment can properly sync and show me matching results.
So now i have this query....Leave a comment:
-
Many thanks. I'll take a look later, currently rushing a job to get it done before due. Thanks for the time and effort !!...Leave a comment:
-
okay, here's my query SQL codes. Here's what I need to get from the query. I need to show the LeaveType, DaysEntitled, EarnedLeave, TotalLeaveTaken and DaysLeft. I don't have DaysLeft in the query yet because I can't get TotalLeaveTaken to work.
In layman term, I need to show all Leave Entitled to EmployeeA in Year1, including the DaysEntitled, EarnedLeave,Day sLeft for each particular leave type. Whenever I include fields from tblLeaveApply,...Leave a comment:
-
Oh wow, thanks very much for putting in the effort and time! I'm in the office now, I'll go and try it out and post back later.
Edit: Just one question, currently my tblMainProfile' s Pkey is EmployeeID, and I link the different tables together using EmployeeID too, with tblMainProfile' s being Pkey and the other tables' EmployeeID being Fkey with respective index field being Pkey (LeaveID, etc). Is there something wrong with the way...Leave a comment:
-
Really appreciate your reply. So you mean I should have a Year field in tblLeaveApply which the user have to manually input in the current Year upon application of the leave? Is there a better way to do enter the value for the Year field here? I'm thinking of putting this under the Open Form event so it auto fills it with current year. Will it work?
Because right now I only have Year field...Code:Me.Year.Setfocus Me.Year.Value=Year(Date())
Leave a comment:
-
Some problems with annual leave database
Hi, I need to create an annual leave Database for the company. I admit I was a complete novice at this. But I got thrown the job and I have to do it. So here's what I get so far, but I got pretty much stuck for some days figuring out what to do. Sorry I can't think of a better title.
I have a tblMainProfile table, which stores everything about employee's particulars. ID, name, NIRC, etc etc.
Next, I have tblLeaveEntitle ment...
No activity results to display
Leave a comment: