28-Jul-2006, 08:42 AM
|  | Guest | | | | | | | | | | combo data
i use dropdown (combo box) to enter data for example: -
in form
i click : item no (combo box)
auto update : item name
but
in table
item no is updated, but item name is not updated.
pls help me !
thanks
JOHN
*
 Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh! |
28-Jul-2006, 08:42 AM
| | Guest | | | | | | | | | | Re: combo data
John
Is ItemNo defined as a Unique value? (It sounds like it isn't).
In your combo box, are you binding the ItemNo or the ItemName? Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13998-combo-data.htmlReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13998
Regards
Jeff Boyce
Microsoft Office/Access MVP
"John" wrote in message
news:FD7403D8-73FC-4C96-BEF0-9CA34764E08E@microsoft.com...
>i use dropdown (combo box) to enter data for example: -
> in form
> i click : item no (combo box)
> auto update : item name
> but
> in table
> item no is updated, but item name is not updated.
>
> pls help me !
>
> thanks
>
> JOHN
|
28-Jul-2006, 08:42 AM
| | Guest | | | | | | | | | | Re: combo data
Hi Jeff
ItemNo defined as number
combo box binding ItemNo
Thanks
JOHN
"Jeff Boyce" wrote:
> John
>
> Is ItemNo defined as a Unique value? (It sounds like it isn't).
>
> In your combo box, are you binding the ItemNo or the ItemName?
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13998
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
>
> "John" wrote in message
> news:FD7403D8-73FC-4C96-BEF0-9CA34764E08E@microsoft.com...
> >i use dropdown (combo box) to enter data for example: -
> > in form
> > i click : item no (combo box)
> > auto update : item name
> > but
> > in table
> > item no is updated, but item name is not updated.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13998
> >
> > pls help me !
> >
> > thanks
> >
> > JOHN
>
>
> |
28-Jul-2006, 08:42 AM
| | Guest | | | | | | | | | | Re: combo data
I Think we might have a denormalized table issue
He wants to store Both values from the combo (bad practise) or to display
the name on the form (good practise)
either way:
Sub Cbo_AfterUpdate()
Me.ItemName.Value = Me.cbo.Column(1) ' zero based
End Sub Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13998
Pieter
"John" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13998
news:6E19129A-4AC0-424C-BD0D-22ECB77BB041@microsoft.com...
> Hi Jeff
>
> ItemNo defined as number
> combo box binding ItemNo
>
> Thanks
>
> JOHN
>
> "Jeff Boyce" wrote:
>
>> John
>>
>> Is ItemNo defined as a Unique value? (It sounds like it isn't).
>>
>> In your combo box, are you binding the ItemNo or the ItemName?
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>>
>>
>> "John" wrote in message
>> news:FD7403D8-73FC-4C96-BEF0-9CA34764E08E@microsoft.com...
>> >i use dropdown (combo box) to enter data for example: -
>> > in form
>> > i click : item no (combo box)
>> > auto update : item name
>> > but
>> > in table
>> > item no is updated, but item name is not updated.
>> >
>> > pls help me !
>> >
>> > thanks
>> >
>> > JOHN
>>
>>
>>
 |
28-Jul-2006, 08:42 AM
| | Guest | | | | | | | | | | Re: combo data
I Think we might have a denormalized table issue
He wants to store Both values from the combo (bad practise) or to display
the name on the form (good practise)
either way:
Sub Cbo_AfterUpdate()
Me.ItemName.Value = Me.cbo.Column(1) ' zero based
End Sub
Pieter
"John" wrote in message
news:6E19129A-4AC0-424C-BD0D-22ECB77BB041@microsoft.com...
> Hi Jeff
>
> ItemNo defined as number
> combo box binding ItemNo
>
> Thanks
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13998
> JOHN
>
> "Jeff Boyce" wrote:
>
>> John
>>
>> Is ItemNo defined as a Unique value? (It sounds like it isn't).
>>
>> In your combo box, are you binding the ItemNo or the ItemName?
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>>
>>
>> "John" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13998
>> news:FD7403D8-73FC-4C96-BEF0-9CA34764E08E@microsoft.com...
>> >i use dropdown (combo box) to enter data for example: -
>> > in form
>> > i click : item no (combo box)
>> > auto update : item name
>> > but
>> > in table
>> > item no is updated, but item name is not updated.
>> >
>> > pls help me !
>> >
>> > thanks
>> >
>> > JOHN
>>
>>
>>
--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4367 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len
|
28-Jul-2006, 08:42 AM
| | Guest | | | | | | | | | | Re: combo data
Hi Pieter
i am not good in visual basic. I do not understand your advise, pls explain
other way
JOHN
"Pieter Wijnen" wrote:
> I Think we might have a denormalized table issue
> He wants to store Both values from the combo (bad practise) or to display
> the name on the form (good practise)
> either way:
>
> Sub Cbo_AfterUpdate()
> Me.ItemName.Value = Me.cbo.Column(1) ' zero based
> End Sub
>
> Pieter
>
>
> "John" wrote in message
> news:6E19129A-4AC0-424C-BD0D-22ECB77BB041@microsoft.com...
> > Hi Jeff
> >
> > ItemNo defined as number
> > combo box binding ItemNo
> >
> > Thanks
> >
> > JOHN
> >
> > "Jeff Boyce" wrote:
> >
> >> John
> >>
> >> Is ItemNo defined as a Unique value? (It sounds like it isn't).
> >>
> >> In your combo box, are you binding the ItemNo or the ItemName?
> >>
> >> Regards
> >>
> >> Jeff Boyce
> >> Microsoft Office/Access MVP
> >>
> >>
> >> "John" wrote in message
> >> news:FD7403D8-73FC-4C96-BEF0-9CA34764E08E@microsoft.com...
> >> >i use dropdown (combo box) to enter data for example: -
> >> > in form
> >> > i click : item no (combo box)
> >> > auto update : item name
> >> > but
> >> > in table
> >> > item no is updated, but item name is not updated.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13998
> >> >
> >> > pls help me !
> >> >
> >> > thanks
> >> >
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13998
> >> > JOHN
> >>
> >>
> >>
>
>
> |
28-Jul-2006, 08:42 AM
| | Guest | | | | | | | | | | Re: combo data
Hi
my question is I key in data in form Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13998
itemno (combo box)
itemname (auto appear)
after key-in, data record in form but check in table, itemname is not
update. in report to print out itemname is "blank"
Pls help me
Thanks
JOHN
"Pieter Wijnen" wrote:
> I Think we might have a denormalized table issue
> He wants to store Both values from the combo (bad practise) or to display
> the name on the form (good practise)
> either way:
>
> Sub Cbo_AfterUpdate()
> Me.ItemName.Value = Me.cbo.Column(1) ' zero based
> End Sub
>
> Pieter
>
>
> "John" wrote in message
> news:6E19129A-4AC0-424C-BD0D-22ECB77BB041@microsoft.com...
> > Hi Jeff
> >
> > ItemNo defined as number
> > combo box binding ItemNo
> >
> > Thanks
> >
> > JOHN
> >
> > "Jeff Boyce" wrote:
> >
> >> John
> >>
> >> Is ItemNo defined as a Unique value? (It sounds like it isn't).
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13998
> >>
> >> In your combo box, are you binding the ItemNo or the ItemName?
> >>
> >> Regards
> >>
> >> Jeff Boyce
> >> Microsoft Office/Access MVP
> >>
> >>
> >> "John" wrote in message
> >> news:FD7403D8-73FC-4C96-BEF0-9CA34764E08E@microsoft.com...
> >> >i use dropdown (combo box) to enter data for example: -
> >> > in form
> >> > i click : item no (combo box)
> >> > auto update : item name
> >> > but
> >> > in table
> >> > item no is updated, but item name is not updated.
> >> >
> >> > pls help me !
> >> >
> >> > thanks
> >> >
> >> > JOHN
> >>
> >>
> >>
>
>
> |
28-Jul-2006, 08:42 AM
| | Guest | | | | | | | | | | Re: combo data
On the properties page for the cbo find AfterUpdate Event -> click the
builder (...) -> select: Event Procedure -> ok
& type the code (using your controlname for the combo, instead of cbo and/or
ItemName)
Pieter
"John" wrote in message
news:F8729820-DD75-4EF9-AC19-4B4B0251FFCA@microsoft.com...
> Hi Pieter
>
> i am not good in visual basic. I do not understand your advise, pls
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13998
> explain
> other way
>
> JOHN
>
> "Pieter Wijnen" wrote:
>
>> I Think we might have a denormalized table issue
>> He wants to store Both values from the combo (bad practise) or to display
>> the name on the form (good practise)
>> either way:
>>
>> Sub Cbo_AfterUpdate()
>> Me.ItemName.Value = Me.cbo.Column(1) ' zero based
>> End Sub
>>
>> Pieter
>>
>>
>> "John" wrote in message
>> news:6E19129A-4AC0-424C-BD0D-22ECB77BB041@microsoft.com...
>> > Hi Jeff
>> >
>> > ItemNo defined as number
>> > combo box binding ItemNo
>> >
>> > Thanks
>> >
>> > JOHN
>> >
>> > "Jeff Boyce" wrote:
>> >
>> >> John
>> >>
>> >> Is ItemNo defined as a Unique value? (It sounds like it isn't).
>> >>
>> >> In your combo box, are you binding the ItemNo or the ItemName?
>> >>
>> >> Regards
>> >>
>> >> Jeff Boyce
>> >> Microsoft Office/Access MVP
>> >>
>> >>
>> >> "John" wrote in message
>> >> news:FD7403D8-73FC-4C96-BEF0-9CA34764E08E@microsoft.com...
>> >> >i use dropdown (combo box) to enter data for example: -
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13998
>> >> > in form
>> >> > i click : item no (combo box)
>> >> > auto update : item name
>> >> > but
>> >> > in table
>> >> > item no is updated, but item name is not updated.
>> >> >
>> >> > pls help me !
>> >> >
>> >> > thanks
>> >> >
>> >> > JOHN
>> >>
>> >>
>> >>
>>
>>
>>
|
28-Jul-2006, 08:42 AM
| | Guest | | | | | | | | | | Re: combo data
On the properties page for the cbo find AfterUpdate Event -> click the Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13998
builder (...) -> select: Event Procedure -> ok
& type the code (using your controlname for the combo, instead of cbo and/or
ItemName)
Pieter
"John" wrote in message
news:F8729820-DD75-4EF9-AC19-4B4B0251FFCA@microsoft.com...
> Hi Pieter
>
> i am not good in visual basic. I do not understand your advise, pls
> explain
> other way
>
> JOHN
>
> "Pieter Wijnen" wrote:
>
>> I Think we might have a denormalized table issue
>> He wants to store Both values from the combo (bad practise) or to display
>> the name on the form (good practise)
>> either way:
>>
>> Sub Cbo_AfterUpdate()
>> Me.ItemName.Value = Me.cbo.Column(1) ' zero based
>> End Sub
>>
>> Pieter
>>
>>
>> "John" wrote in message
>> news:6E19129A-4AC0-424C-BD0D-22ECB77BB041@microsoft.com...
>> > Hi Jeff
>> >
>> > ItemNo defined as number
>> > combo box binding ItemNo
>> >
>> > Thanks
>> >
>> > JOHN
>> >
>> > "Jeff Boyce" wrote:
>> >
>> >> John
>> >>
>> >> Is ItemNo defined as a Unique value? (It sounds like it isn't).
>> >>
>> >> In your combo box, are you binding the ItemNo or the ItemName?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13998
>> >>
>> >> Regards
>> >>
>> >> Jeff Boyce
>> >> Microsoft Office/Access MVP
>> >>
>> >>
>> >> "John" wrote in message
>> >> news:FD7403D8-73FC-4C96-BEF0-9CA34764E08E@microsoft.com...
>> >> >i use dropdown (combo box) to enter data for example: -
>> >> > in form
>> >> > i click : item no (combo box)
>> >> > auto update : item name
>> >> > but
>> >> > in table
>> >> > item no is updated, but item name is not updated.
>> >> >
>> >> > pls help me !
>> >> >
>> >> > thanks
>> >> >
>> >> > JOHN
>> >>
>> >>
>> >>
>>
>>
>>
--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4367 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len
| 
Support Us! Become a Promoter! | | Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh! |
 (View-All)
Members who have read this thread : 0
| | There are no names to display. |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Tools | Search | | | | | Display Modes |  Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is On
| | | |  | » Gurbani Jukebox |  Listen to Gurbani while surfing SPN! | | » Active Discussions | | | | | | |  ਨਾਮਾ Today 06:37 AM 2 Replies, 53 Views | | | | | | | | | | | | | | | | | | | | | | | | » Books You Should Read... | | | |
