Recent content by vancey

Hi John, With reference from the sketch, i think my EmploymentHistory Table acts as a junction table between Employees Table and CostCenter Table already, is it? Employee EmployeeID Surname FullName ....... EmploymentHistory EmployeeID CostCenterID....... CostCenter CostCenterID...

Hi John, im back with my normalization of my database. I encountered 2 problems. 1st, It seems that i have overused the indexes on a table, and the error msg "Operation failed. There are too many indexes on table 'tblEmploymentHistory'. Delete some of the indexes and try the operation again...

Thanks John. Gonna try to work more on it....

Hi John, after some reading on normalization, i tried to sort up my tables and sketched my plan, relationship im still not so sure (like 1-1, 1-many etc) yet, hope you will help me take a look and see if im going the right track. Its my first time designing, pardon me if it looks absurd. Hope...

Qry To Exclude Record If All Fields On Page Is Blank Except Field "xx", "yy" And "zzz Dear all, Basically, i need a query to exclude all records ONLY if ALL selected fields are blank. (means if one of a field has a value, it still shows up, only all blanks will not show up). I had a command...

Thanks john for the great explanation and examples, i will continue to look into it and hope to get more understandings.. :)

Hi John, i went to read up about normalization but having some difficulty to understand for my side and apply to my database. Im trying now to normalize my data, but it seems to me that everything is related to Employee, Maybe for example, i just need users to key in their department, and i...

Thank you John and linq for the helps, advises and the tutorial links! i will continue to study more on normalization.

Hi John and Linq, Sorry im so newbie in access >< My copy of db is attached in my first post. Its 2003 version. Thanks!

Hi linq, i changed the delimiter to a 'comma' (,) , and applied the code to the cmdbtn to open the form, but im still getting the 'no current record' error msg. :( is it because i have not created anything yet? May i know are the delimiter essential in passing multiple arguments? When i...

Im still getting the "No current record" error msg and when i tried to save after keying in the other fields, it says "Index or Primary Key cannot contain a NULL value." :( When i scroll through the records then click on the button(open 2nd form) the record doesnt relates to the main form...

Hi John, I solved the above error, i forgot to bound the form to the tblEmployeesHIPO table. But after i clicked on the button to open the new form, it says "No current record". What does this error msg means? and when i tried to save after keying in the other fields, it says "Index or...

Hi John, Thanks for the response, i have tried to pass the 3 info to the OpenArg: cmdbutton to open the 2nd form: Private Sub cmdNominate_Click() On Error GoTo Err_cmdNominate_Click stLinkCriteria = "[EmployeeID]=" & "'" & Me![EmployeeID] & "'" DoCmd.OpenForm "frmEmployeesHIPO", ...

Hi all, Basically i have a set of records from Employees table. I have another table tblEmployeesHIPO which contains additional info about the previous table , i have created a button in the first form( frmEmployees) to open up a 2nd form (frmEmployeesHIPO). I want the 2nd form to show details...

That helps a lot. Thanks John! :)