Search results

thank you NauticalGent! how about this?

im trying to understand "Normalisation" up to 4NF. i have attached here my test diagram of what i have understood. any comments or corrections in it? thank you.

And also a Store could have many Types such as: Wholesaler Retailer Distributor etc..

May you give me advice for improvements before i start developing the tables.. Thank you.

Hi guys! I have attached a diagram of my normalised table for Store. Store Store Address Store Contacts Type of Address Type of Contacts Basically what's in my mind when i designed this were: A store can have many Address An Address of a store could have many Types (Office, Bill To...

eh tagalog ka nman pala eh. pinahirapan mo pa ako mag english! :) Sige thank you kabayan!

I want to display the Highest and Lowest Prices in the left subreports How to do that? Please refer to attached file Thanks!

@bob fitz: Exactly! Dlookup("[Contribution]", "SSS_Contributions", "[BasicPay]=" & DMax("[BasicPay]","SSS_Contributions","[Basic] <= 2356") )

Suppose i have a value of 2,356 and i want to look to a table SSS_Contributions to get the appropriate contribution, how would i do that if: tblSSS_Contribution: [Basic] [Contribution] 1000 50 2000 100 3000 150 thanks

how does dcount work?

@arnelgp: yeah right.. Thanks!

@arnelgp: I am not required to do it in a daily basis. we were given a 15day-DTR already consolidated. i just have to input how many hours did the employee worked for 15 days, how many OT and holidays. i guess to automatically detect the holiday would not be applicable for this. right? i have...

@moke123: this one.. Private Sub cmdSelectPhoto_Click() Dim ofD As FileDialog Dim file Set ofD = Application.FileDialog(msoFileDialogOpen) ofD.AllowMultiSelect = False ofD.Filters.Clear ofD.Filters.Add "Images", "*.gif; *.jpg; *.jpeg", 1 If ofD.Show =...

@moke123: Thanks! I already figure it out. the solution i found was to open dialog box and store image location to the field. the new problem now is how to restrict selection to images/pictures only

I want to add a picture for every employee. How to do it? Please see attached

@plog: now i understand this. :D

@Uncle Gizmo: Just now. i'll have a peek. Thank you!

@Mark_: Thanks mark! that would be very helpful!

@arnelgp: with this technique, i should be inputting the time sheet in a daily basis. to determine the date. not just the mon, tue, wed .. technique. right?

I have this problem that i can never ever figure it out how to start. table_Holidays: 1. ID 2. Date 3. Holiday Type 4. Holiday Discription table_Timesheets: 1. ID 2. Employee.ID (linked to table_Employees) 3. Work Date (to hold -when) 4. Hours Worked (to hold -how many hours worked on work...