Search results for query: *

thank you for the replies... =) i'll try them.. =)

hi guys.. i want to include a search form in my database.. here is my current SQL statement: SELECT tblCompany.CompanyIDPK, tblCompany.CompanyName, tblCompany.CompanyAddress, tblCompany.ContactPerson, tblCompany.ContactPosition, tblCompany.OfficeNo, tblCompany.MobileNo, tblCompany.FaxNo...

yup, thanks a lot.. it's really nice of you.. i was just wondering if the reports in the database will still work since you revised the relationships? and regarding the employee id, we really have a standard employee id here, is it possible for the subform to work if the employee id is not an...

hi pampers.. i already sent you an email.. thanks a lot... =)

it still won't work.. is there something wrong with the child/master link? here is the link to the actual file... http://www.gigafiles.co.uk/files/636/human%20resource%20info%20system_2006-10-11.zip thanks a lot and sorry for the inconvenience...

it's not working an enter parameter value appears... and it asks for frmEmployee2.EmployeeIDPK... and i can't type in the fields related to the subform...

hi.. i already tried to do that but still it won't work... here is the query for the record source of the subform: SELECT tblPosition.PositionName, tblContract.StartDateContract, tblContract.EndDateContract, tblCompany.CompanyName, tblDealer.DealerName, tblOutlet.OutletName FROM (tblOutlet...

hi. i have already followed your advice. the form now looks like this: http://i114.photobucket.com/albums/n258/lushh_16/subform.jpg how can the data entry be done? where should i type the data that needs to be tracked like the contract dates? thanks a lot. hope to hear from you again.

ok. =) thanks for the replies... =)

oh ok... sorry i am only new to programming.. and i am not really familiar with your advice. how can i set the (master/child) link.. i am really sorry for the inconvenience...

hi.. thanks for the replies... yup. i already have an employee table and contract tables.. the relationships are also fine. all that i lack is the code..

i am currently working on an employee database using MS access 2003. i wanted to track all the contract dates of a certain employee. is that possible? whenever the user would enter a new contract date for a certain employee, it will not overwrite the previous contract dates, hence it would add...

because when you enter a record in an MS access form, the record will be automatically saved right? so how will i disable this feature? i only want the record to be saved when a "save button" is clicked.

hi guys.. how will disable the auto save feature on the forms of MS access? thanks in advance.. =)

thanks a lot.. i will try to look on that.

ok. got it.. it worked.. thanks guys... it's really a big help.. :)

hi guys.. it didn't work.. :( the current setting looks like this: http://i114.photobucket.com/albums/n258/lushh_16/login.jpg as you can see, the "Tools" menu is not there, so i can't configure the start up option and other toolbars that i need to finish my database...

hi guys.. i have already accessed the start up options on my database. i have unchecked the allow full menus, allow default shortcut menus, allow built-in toolbars, allow toolbar/menu changes and use access special keys options. the problem is that when i want to incorporate some modifications...

hi guys. i need help on doing a search on a database. i am using ms access 2003 and the form looks like this: http://i114.photobucket.com/albums/n258/lushh_16/searchbyclientform.jpg when the user will type in for example "EOT Corp." in the "Search for" field and will choose "Company Name" in...

hi guys. i am currently working on a human resources information system. i am currently using ms access 2003 and the report form looks like this: http://i114.photobucket.com/albums/n258/lushh_16/reports.jpg the function of this form, is once a button is clicked, the appropriate report for...