Search results

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

hi.. i am currently creating an employee database.. and there is a form on the database that needs to search on records.. i am planning to create a form with a single textbox (for the keyword entry) and a search command button that when clicked, the search results will be shown in a seaparate...

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

hi.. i am currently having a problem with the add button on my "frmEmployee2". once the button is clicked, a message "you can't go to a specified record" appears. what seems to be the problem? any advice is welcome and would definitely be appreciated. thanks in advance. attached is the copy of...

hello.. i want my form to look like this: where there is add, edit, save and delete buttons.. and that the record cannot be edited unless the "Edit button" is clicked and the entry will only be saved when the "Save" button is clicked. i tried to search for sample databases, but it doesn't...

hi.. i am working on a system and it needs a username and password for security. i am using ms access 2003. and my form looks like this: the user will enter a username and password in order to get into the system. the system will have 2 or more users. i just wanna ask if anyone has a VBA...

hi guys. i am currently working on an human resources information system. i am currently using ms access 2003 and the report form looks like this: the function of this form, is once a button is clicked, the appropriate report for that button will be generated and will automatically be viewed...

hi guys. i am just a newbie here. i just wanna know if do i have to make a query for each report that i need to create? thank you.

hi guys. i just wanna know if the reports that will be generated by ms access can be in ms excel format? btw, i am using ms access 2003. thanks in advance :)

i've been working on a database that can track the contract dates of contractual employees in our company. do you have any idea on how am i going to structure a table that will include the following: - The start date of the previous contract - The end date of the previous contract - The start...

i am currently working with a human resource outsourcing company. we deploy contractual employees to different companies. we usually use ms excel in keeping records of our employees, now my boss wants me to create a database using ms access. this is my first time in creating database using ms...