PC Review


Reply
Thread Tools Rate Thread

Display relevant information from excel sheet into form

 
 
dave
Guest
Posts: n/a
 
      18th Dec 2011
Hello guys,

I need a help here. I have created little database in excel for stock
control which included few forms. Now what im trying to do is when
enter part number in text box and click the search button, I want all
the parts and all the related information for the part to be display
in the text box or label in the form. Some part I have more that one,
I need need all to be display below the search box where I have places
a large text box so it can display more than one item. Please help
with the VBA code

Thank you

dave
 
Reply With Quote
 
 
 
 
Don Guillett
Guest
Posts: n/a
 
      18th Dec 2011
On Dec 18, 11:47*am, dave <dev.subraman...@gmail.com> wrote:
> Hello guys,
>
> I need a help here. I have created little database in excel for stock
> control which included few forms. Now what im trying to do is when
> enter part number in text box and click the search button, I want all
> the parts and all the related information for the part to be display
> in the text box or label in the form. Some part I have more that one,
> I need need all to be display below the search box where I have places
> a large text box so it can display more than one item. Please help
> with the VBA code
>
> Thank you
>
> dave

Sounds like a drop down with avail part numbers tied to a worksheet
change event macro to simply goto the database and filter for the part
#. Send me your file if you can't figure it out. dguillett1 @gmail.com


 
Reply With Quote
 
dave
Guest
Posts: n/a
 
      18th Dec 2011
On Dec 18, 8:56*pm, Don Guillett <dguille...@gmail.com> wrote:
> On Dec 18, 11:47*am, dave <dev.subraman...@gmail.com> wrote:> Hello guys,
>
> > I need a help here. I have created little database in excel for stock
> > control which included few forms. Now what im trying to do is when
> > enter part number in text box and click the search button, I want all
> > the parts and all the related information for the part to be display
> > in the text box or label in the form. Some part I have more that one,
> > I need need all to be display below the search box where I have places
> > a large text box so it can display more than one item. Please help
> > with the VBA code

>
> > Thank you

>
> > dave

>
> Sounds like a drop down with avail part numbers tied to a worksheet
> change event macro to simply goto the database and filter for the part
> #. Send me your file if you can't figure it out. dguillett1 @gmail.com


Hi,

I have sent the file to your gmail as advised. Thanks again
 
Reply With Quote
 
dave
Guest
Posts: n/a
 
      21st Dec 2011
On Dec 18, 8:56*pm, Don Guillett <dguille...@gmail.com> wrote:
> On Dec 18, 11:47*am, dave <dev.subraman...@gmail.com> wrote:> Hello guys,
>
> > I need a help here. I have created little database in excel for stock
> > control which included few forms. Now what im trying to do is when
> > enter part number in text box and click the search button, I want all
> > the parts and all the related information for the part to be display
> > in the text box or label in the form. Some part I have more that one,
> > I need need all to be display below the search box where I have places
> > a large text box so it can display more than one item. Please help
> > with the VBA code

>
> > Thank you

>
> > dave

>
> Sounds like a drop down with avail part numbers tied to a worksheet
> change event macro to simply goto the database and filter for the part
> #. Send me your file if you can't figure it out. dguillett1 @gmail.com


Hi Don,

Have you got my email. I have sent the file and awaiting for updates.
Please advise.

dave
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:13 PM.