Need Help...
in [General]
|
From: Nad on 11 May 2010 06:41 I have project update form based on parameter query. In the query ProjectEngineer Criteria field, I put ( Like [forms]![formfind]![combo1] ) . The record source of query is TblProject and fields are ProjectEng,….etc. The row source of combo1 of Formfind is a query as SELECT [Employees Extended].ID, [Employees Extended].[Employee Name] FROM [Employees Extended] ORDER BY [Employees Extended].[Employee Name]; The Employee Extended is a query from Employee table. Also I set the column width 0;2 so that it display only the Engineers name not the ID. The problem is that, When I open the ProjectUpdate form , the Formfind is asking for the Engineers name but when I select the engineer name in the Combo box, I am getting no data found message but when I write the ID then its Ok. I understand the problem is in the Formfind as the combobox is fetching two data EmpID and EmpName. But I want to display EngName in the FrmFind not the ID. Hopefully I able explain you. Please help to resolve. Regards,
From: Douglas J. Steele on 11 May 2010 06:49 You can control which value is passed when you refer to [forms]![formfind]![combo1] by setting the Bound Column to which ever column it is you want passed. -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Nad" <Nad(a)discussions.microsoft.com> wrote in message news:8BC501FA-A947-459D-8A2A-3C5645A89B02(a)microsoft.com... >I have project update form based on parameter query. In the query > ProjectEngineer Criteria field, I put ( Like > [forms]![formfind]![combo1] ) . > The record source of query is TblProject and fields are ProjectEng,..etc. > The row source of combo1 of Formfind is a query as > SELECT [Employees Extended].ID, [Employees Extended].[Employee Name] FROM > [Employees Extended] ORDER BY [Employees Extended].[Employee Name]; > The Employee Extended is a query from Employee table. > Also I set the column width 0;2 so that it display only the Engineers name > not the ID. > The problem is that, When I open the ProjectUpdate form , the Formfind is > asking for the Engineers name but when I select the engineer name in the > Combo box, I am getting no data found message but when I write the ID then > its Ok. > I understand the problem is in the Formfind as the combobox is fetching > two > data EmpID and EmpName. But I want to display EngName in the FrmFind not > the > ID. > Hopefully I able explain you. > Please help to resolve. > Regards, >
From: Nad on 11 May 2010 09:39 I put 0 in the bound column as i have to pass empID but still getting the same result. "Douglas J. Steele" wrote: > You can control which value is passed when you refer to > [forms]![formfind]![combo1] by setting the Bound Column to which ever column > it is you want passed. > > -- > Doug Steele, Microsoft Access MVP > http://www.AccessMVP.com/DJSteele > (no e-mails, please!) > > "Nad" <Nad(a)discussions.microsoft.com> wrote in message > news:8BC501FA-A947-459D-8A2A-3C5645A89B02(a)microsoft.com... > >I have project update form based on parameter query. In the query > > ProjectEngineer Criteria field, I put ( Like > > [forms]![formfind]![combo1] ) . > > The record source of query is TblProject and fields are ProjectEng,..etc. > > The row source of combo1 of Formfind is a query as > > SELECT [Employees Extended].ID, [Employees Extended].[Employee Name] FROM > > [Employees Extended] ORDER BY [Employees Extended].[Employee Name]; > > The Employee Extended is a query from Employee table. > > Also I set the column width 0;2 so that it display only the Engineers name > > not the ID. > > The problem is that, When I open the ProjectUpdate form , the Formfind is > > asking for the Engineers name but when I select the engineer name in the > > Combo box, I am getting no data found message but when I write the ID then > > its Ok. > > I understand the problem is in the Formfind as the combobox is fetching > > two > > data EmpID and EmpName. But I want to display EngName in the FrmFind not > > the > > ID. > > Hopefully I able explain you. > > Please help to resolve. > > Regards, > > > > > . >
From: Douglas J. Steele on 11 May 2010 10:25 Unlike the Column collection, the Bound Column starts counting at 1, not 0 (setting BoundColumn to 0 means you'll get the ListIndex value, or an indication of which row was selected) Yeah, I agree it's inconsistent! <g> -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Nad" <Nad(a)discussions.microsoft.com> wrote in message news:F04DF06F-6B3C-443B-9D1E-13DDCBBFD542(a)microsoft.com... >I put 0 in the bound column as i have to pass empID but still getting the > same result. > > "Douglas J. Steele" wrote: > >> You can control which value is passed when you refer to >> [forms]![formfind]![combo1] by setting the Bound Column to which ever >> column >> it is you want passed. >> >> -- >> Doug Steele, Microsoft Access MVP >> http://www.AccessMVP.com/DJSteele >> (no e-mails, please!) >> >> "Nad" <Nad(a)discussions.microsoft.com> wrote in message >> news:8BC501FA-A947-459D-8A2A-3C5645A89B02(a)microsoft.com... >> >I have project update form based on parameter query. In the query >> > ProjectEngineer Criteria field, I put ( Like >> > [forms]![formfind]![combo1] ) . >> > The record source of query is TblProject and fields are >> > ProjectEng,..etc. >> > The row source of combo1 of Formfind is a query as >> > SELECT [Employees Extended].ID, [Employees Extended].[Employee Name] >> > FROM >> > [Employees Extended] ORDER BY [Employees Extended].[Employee Name]; >> > The Employee Extended is a query from Employee table. >> > Also I set the column width 0;2 so that it display only the Engineers >> > name >> > not the ID. >> > The problem is that, When I open the ProjectUpdate form , the Formfind >> > is >> > asking for the Engineers name but when I select the engineer name in >> > the >> > Combo box, I am getting no data found message but when I write the ID >> > then >> > its Ok. >> > I understand the problem is in the Formfind as the combobox is fetching >> > two >> > data EmpID and EmpName. But I want to display EngName in the FrmFind >> > not >> > the >> > ID. >> > Hopefully I able explain you. >> > Please help to resolve. >> > Regards, >> > >> >> >> . >>
From: Nad on 12 May 2010 03:13 Thanks Douglas. Its working now. You guys are very kind. I have another problem. My query is based on TblProjectUpdate and in this table i store EmpID which is linked to Employee table. My form is based on this query. Now, i want to display Employee name insted of Employee ID in the form. Plz help. Regards "Douglas J. Steele" wrote: > Unlike the Column collection, the Bound Column starts counting at 1, not 0 > (setting BoundColumn to 0 means you'll get the ListIndex value, or an > indication of which row was selected) > > Yeah, I agree it's inconsistent! <g> > > -- > Doug Steele, Microsoft Access MVP > http://www.AccessMVP.com/DJSteele > (no e-mails, please!) > > "Nad" <Nad(a)discussions.microsoft.com> wrote in message > news:F04DF06F-6B3C-443B-9D1E-13DDCBBFD542(a)microsoft.com... > >I put 0 in the bound column as i have to pass empID but still getting the > > same result. > > > > "Douglas J. Steele" wrote: > > > >> You can control which value is passed when you refer to > >> [forms]![formfind]![combo1] by setting the Bound Column to which ever > >> column > >> it is you want passed. > >> > >> -- > >> Doug Steele, Microsoft Access MVP > >> http://www.AccessMVP.com/DJSteele > >> (no e-mails, please!) > >> > >> "Nad" <Nad(a)discussions.microsoft.com> wrote in message > >> news:8BC501FA-A947-459D-8A2A-3C5645A89B02(a)microsoft.com... > >> >I have project update form based on parameter query. In the query > >> > ProjectEngineer Criteria field, I put ( Like > >> > [forms]![formfind]![combo1] ) . > >> > The record source of query is TblProject and fields are > >> > ProjectEng,..etc. > >> > The row source of combo1 of Formfind is a query as > >> > SELECT [Employees Extended].ID, [Employees Extended].[Employee Name] > >> > FROM > >> > [Employees Extended] ORDER BY [Employees Extended].[Employee Name]; > >> > The Employee Extended is a query from Employee table. > >> > Also I set the column width 0;2 so that it display only the Engineers > >> > name > >> > not the ID. > >> > The problem is that, When I open the ProjectUpdate form , the Formfind > >> > is > >> > asking for the Engineers name but when I select the engineer name in > >> > the > >> > Combo box, I am getting no data found message but when I write the ID > >> > then > >> > its Ok. > >> > I understand the problem is in the Formfind as the combobox is fetching > >> > two > >> > data EmpID and EmpName. But I want to display EngName in the FrmFind > >> > not > >> > the > >> > ID. > >> > Hopefully I able explain you. > >> > Please help to resolve. > >> > Regards, > >> > > >> > >> > >> . > >> > > > . >
|
Next
|
Last
Pages: 1 2 Prev: Hyperlink problem Next: VBA needed to delete corrupt records from MsysObjects |