Prev: Hyperlink problem
Next: VBA needed to delete corrupt records from MsysObjects
From: Douglas J. Steele on 12 May 2010 07:48
Add the Employee table to your query and get the name from it.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Nad" <Nad(a)discussions.microsoft.com> wrote in message
news:6AA69A9F-48F9-4BA0-B56D-E3D093625ECA(a)microsoft.com...
> 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,
>> >> >
>> >>
>> >>
>> >> .
>> >>
>>
>>
>> .
>>


First  |  Prev  | 
Pages: 1 2
Prev: Hyperlink problem
Next: VBA needed to delete corrupt records from MsysObjects