Search results

Currently I have a search form that has 2 fields First Name & Last Name both in a combo box. First would it be easier to just have the one Box and title it name? Since you can see multiple columns or leave it as is. The other problem is that when i add the code below to the Click event...

Ok I am using Access 2007 I have 2 forms that I use to add employees and also display all their info. I have also made a search form and a query to pull the results. What i am trying to do is to attach the query to the forms as well so that I can still enter the data but if i need to search it...

I have a form that I am trying to have a combobox that once an item is selected from it. It will only show items associated with it. I setup the second query but cant seem to get it pull the rest of the info or even get the combobox item to stick please help. It is attached please help

I was wondering if anyone can help me I have a search form that users list date range, whether an appointment showed or is pending (Show and pending are seperate checkboxes), and then agent. On top of that if a field is blank I want it to pull all records with whichever criteria has been...

I am trying to find out how to get a date range search to return all records here is the code Between [Forms]![Search]![startDate] And [Forms]![Search]![endDate]

Ok I am still learning some of the features of Access but where would I place this if I wanted to do Proper Case on a Form for controls called txtFName & txtLName? I understand that I need to change yoursting. StrConv([yourstring], vbProperCase)

I am looking for a way to lock specific fields after data has been entered so that they can't accidently be changed if they are searching through the records is there a way to do this for Access 2007? I have found another another thread but the ways listed did not work: If Not...