Search results

hi guys! normalisation again. is this normalised? thanks?

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.

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

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

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

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

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

Finally! with all your help, i am able to build a piece of it. Would you mind taking a peak of it? for improvements? for a better world? :D PS: Issues i still can't resolve: I want to set the focus to txtMon1 after i click on date picker of txtStart How to elegantly minimise the code in...

how do you squeeze this thru looping Private Sub cmdSubmit_Click() Dim t As TextBox Set rs = db.OpenRecordset("SELECT ID, EmpNo, StartDate, EndDate, " & _ "Mon1, Tue1, Wed1, Thu1, Fri1, Sat1, Sun1, " & _ "Mon2, Tue2, Wed2...

I want to move the cursor or set the focus to other control after i click or pick a date from the date picker. i get error 2110 with this code: Private Sub txtStart_AfterUpdate() DoCmd.GoToControl "txtEnd" txtEnd.SetFocus End Sub

i'm trying to extract a data based on 2 criteria. date is not cooperating! the supposed to be October 7, 2017 (10/7/2017) is interpreted as July 10, 2017 (7/10/2017) Set rs = db.OpenRecordset("SELECT ID, Mon1, Tue1, Wed1, Thu1, Fri1, Sat1, Sun1, " & _ "Mon2...

errHandler: If Err.Number = 3021 Then MsgBox "Invalid Employee Number!" & vbCrLf & _ "Please check the number again.", vbOKOnly + vbInformation, "Message" DoCmd.GoToControl "txtEmpNo" Else MsgBox "A problem occurred when trying to retrieve the...

Hi guys! I'm learning MS Access VBA. May this forum be of help.. :o