Search results

where should i insert the *? sorry i am just a newbie...

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 tried to create a form and subform with this query for the tracking of contracts: SELECT tblPosition.PositionName, tblContract.StartDateContract, tblContract.EndDateContract, tblCompany.CompanyName, tblDealer.DealerName, tblOutlet.OutletName FROM (tblOutlet INNER JOIN (tblDealer INNER JOIN...

hi guys.. thanks for the replies... i do appreciate them... it really did help.. sorry for the inconvenience.. have a great day.. God bless... =)

hi. i also have the same problem.. but in my case, when the combo box in a form is clicked, a separate form with different filled-up fields should come out. it's kind of a search function. does the same procedure apply?

hi.. sorry for the late reply.. i was quite busy.. yup! it did work perfectly.. thanks a lot.. i owe you one.. =) but there is a problem with the combo boxes in the same form.. i can't select from the items in the combo boxes.. why is that so?

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

thanks for the reply.. where will i remove the link? in Tools>relationships or in a specific query only? sorry i am really new to this. thanks so much...

i need the edit button so that the records will be more secure. what if someone accidentally deleted a data? it will be automatically saved right? but if the form has an edit button, you will need to click the edit button first before you can make some changes then save it. got it?

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

i already used button wizard. currently, i have add, save, delete, but there is no edit in button wizard.. and i also want to remove the auto save feature of access.. it should only edit and save records when edit and save buttons are clicked... thanks...

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 teebird. thanks for this sample database. it really did help me a lot. i also want to thank the designer for sharing his work. good day! =)

hi teebird. thanks for this sample database. it really did help me a lot. i also want to thank the designer for sharing his work. good day! =)

what is a shift key feature? how will i disable it?

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. sorry, i am just a newbie here. where should the code be placed? because i am currently experiencing the same problem. thanks.

thanks a lot uncle gizmo. i'll try to search for that. :)

hi uncle gizmo. thanks for the reply, but my boss requires me to generate reports on excel format. i need any advice since i will be presenting a demo system on friday. i will definitely appreciate all the help anyone can give and i do apologize for the inconvenience.