If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Has Hierarchy the Parameter between years?
Hello
Access 2003. I have a query with the following parameters. Like [Forms]![Search].[txtAAID] & "*" ‘Data are in TAA Like [Forms]![Search].[txtBBName] & "*" ‘Data are in TBB Like [Forms]![Search].[txtCityName] & "*" ‘ Data are in TCity Between [Forms]![Search].[txtFirstYear] And [Forms]![Search].[txtSecdnYear] ‘Data are in TYears Like [Forms]![Searc].[txtSpWrds] & "*" ‘Data are in TWrds All fields in tables are string and the db is relational. I have 5 txtboxes to enter data. To enter data in Yyear parameter I have two textboxes. Here is the problem I need to fix If I enter data in txtAAID nothing happens If I enter data in txtBBName nothing happens But If I enter data (years) in the between parameter the query displays data but If I enter data in the other boxes it works. How can I solve these problems? Also I would like to enter data in the boxes without the years. With txtCityName and txtSpWrds parameters I need to enter one or more data.(string.) I don’t know to do it without including two or more data. Your help is really welcome |
Thread Tools | |
Display Modes | |
|
|