i need help

[maydelis]

i have been trying to do a dropdown list to be used in a form to calculate
wood leghts and surements to make kitchen cabinet doors i was doing it in
excel and was told that for a large amount of pictures it was better to do a
database, i have never worked with access and i have no clue how to do it.
i want my #1 drop downlist to include B1,B2,B3,B4,B5,B6,B7,B8, when i click
on each for the picture to appear and to be able to use it in excel, like #1
i have 2 other more with diffrent items.

thank you

 

[Philip Herlihy]

i have been trying to do a dropdown list to be used in a form to calculate
wood leghts and surements to make kitchen cabinet doors i was doing it in
excel and was told that for a large amount of pictures it was better to do a
database, i have never worked with access and i have no clue how to do it.
i want my #1 drop downlist to include B1,B2,B3,B4,B5,B6,B7,B8, when i click
on each for the picture to appear and to be able to use it in excel, like #1
i have 2 other more with diffrent items.

thank you

Access is better at storing and managing data (of all kinds) than Excel,
but it's a steep learning curve (although the view from the top is
terrific!).

If you're right at the start, get some training, or at least a good
book. There's good video training (you can subscribe for a month at a
time) at lynda.com. Google for [Access training online] and you'll find
some on the Microsoft site (free).

The first and most important thing to get right is your tables. Google
for "normalisation" - the art of dividing up information between tables
for ease of use. Once you have the hang of that, learn about Queries -
start with the Wizard in Access. Then learn about forms, starting again
with the Wizard. That'll get you onto dropdown lists - which are called
"combo boxes" in Access.

I found a couple of nice resources on these on YouTube: try:

Wonderful what's out there, isn't it? What did we all do before the web?

HTH

Phil, London

 

[John... Visio MVP]

I can help you. I provide help with Access, Excel and Word applications
for a reasonable fee. My fee would be very modest to work with you to
create your kitchen cabinet door database. If you would like my help,
contact me at (e-mail address removed).

Steve

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many professionals here who gladly help for FREE. Master Santos
AKA stevie is NOT a professional ( other than a professional troll), who is
far from qualified to help. He offers questionalbe servies at imodest prices
and has proven many times that he incompetent in Access, Word AND Excel.

The safetest thing to do is avoid contacting him. If he was any good, his
previous customers would be swamping him with work, but it appears that his
previous customers do not want to have anythingto do with him.

John... Visio MVP

 

[Gina Whipp]

maydelis,

Before you use Steve (or anybody else) PLEASE check references. For Steve
you can start here... http://home.tiscali.nl/arracom/whoissteve.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[John W. Vinson]

i have been trying to do a dropdown list to be used in a form to calculate
wood leghts and surements to make kitchen cabinet doors i was doing it in
excel and was told that for a large amount of pictures it was better to do a
database, i have never worked with access and i have no clue how to do it.
i want my #1 drop downlist to include B1,B2,B3,B4,B5,B6,B7,B8, when i click
on each for the picture to appear and to be able to use it in excel, like #1
i have 2 other more with diffrent items.

thank you

As others have said, Access is almost surely the right tool for the job... but
there is a learning curve. Here's some resources to get you started:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

 

[maydelis]

thank you,
i have tried learning a little about access but i think that acess is not
right for the job, see at this moment i want a drop down list that displays
the picture of the chosen object i tried doing it in access and i cant seem
to get it, i need that list to work in excel because i already have the form
there, if i can get help with this code:
Public Sub Worksheet_Calculate()
Dim oPic As Picture
Me.Pictures.Visible = False
With Range("A3")
For Each oPic In Me.Pictures
If oPic.Name = .Text Then
oPic.Visible = True
oPic.Top = .Top
oPic.Left = .Left
Exit For
End If
Next oPic
End With
End Sub
--------------------------------------------
this code i got from some one in a web site and it works perfectly but it
only makes one colum show the pictures (F1) i need a3:c3 but i have tried
entering it several ways and it doesnt work. please help me!!

and i do want to thank all of you for warning me with steve!

maydelis

 

[Larry Daugherty]

You'll have better luck posting Excel issues and requests in an Excel
group.

HTH