i need help!!! please urgent

[erza]

hi everybody...i need help,this is my second post and ask for help on my problem, im a student, then doing florist Inventory control and bouquet ordering system, so i need to know:

1)how to make all the bouquet item picture arrange into one catalouge form?
2)In the catalouge form each bouquet pic got the 'ORDER' button,then when the customer click the button suddenly the order form appeared and in the order form also got the bouquet picture that they choose.

3)when the customer select the bouquet then i want to make the bouquet flower picture that they choose appeared in the order form and at the report. and what picture box should i use. please help me..thanks

Please help me with that problem...i hope there got solution for that.i must solve this problem before next week...

any suggestion please..
Any help you can give, I'd appreciate it. if it's a real strange fix as long as it works, it's fine by me. Thanks.
from erza

 

[erza]

please help me...im new in this access....so help me....please...anynone..my senior..

 

[daveUK]

Hi erza,

I think i can help you with your second/third question. In order to show the bouquet on the form you need to use an image box. Once you place an image box on the form Access will want you to place an image in it. Choose any image from your C, D or A drive, it doesn't really matter. After you've placed the image into the image box, go into the properties of the image box and under 'picture' it will have the file path of the image you chose - delete the path and type (none). Access will ask if you want to delete the image - answer 'Yes'. You will be left with a blank image box.
It's best to link the picture to the database rather than store it in the database due to the fact that Access 'bloats' images. In order to link an image you need to have the file path stored on the form and use code similar to :

Me!(the name of your image box).Picture = Me!(the name of the text box displaying the file path of the image)
i.e. Me!Image1.picture = Me!Location

If you place this code under the onclick properties of the listbox with the names of the bouquet types, everytime you click a different filepath, the image will change (I assume there are different bouquets available?)

In order to copy the text to the order form you need to use the OpenArgs method.
Under the properties on the Order Command button you need to use the OpenArgs method.

DoCmd.OpenForm "Your order form name", acNormal, , , acFormAdd, acWindowNormal, Me!(the name of the textbox/list displaying the file paths of the flowers)

i.e. DoCmd.OpenForm "frmOrder", acNormal, , , acFormAdd, acWindowNormal, Me!lstFiles

Then under the Form_Load properties of your Order form you need to type the following code:

Me!(the textbox name you want the filepath to appear in) = Me.OpenArgs

i.e. Me!Location = Me.OpenArgs

This will transfer the filepath from one form to another. If you want to display the image on the order form aswell, then use the code below.

Me!(Image box title on order form).Picture = Me!(textbox name displaying filepath on order form)

i.e. Me!Image8.Picture = Me!Location

Hope this helps

Dave

 

[erza]

hi dave
im going to try that right now. Thank You dave.

 

[erza]

hi..
Thank You Dave for ur help, actually i have tried the tips that you teach me, Yeah..as what I mention that access is new for me, and im now still learn and try to improve my access skills. And the question is..when i read ur help, then i think i can do it, but when i try to do what u teach me..im still stuck , there was an error.For eg:
You told me that it's best to link the picture the database rather than store it ( I hope I understand this), so i type

Me!image1.picture=Me!Location(<----- what is this location mean? Is this for Name of the bouquet picture file that located in Drive or what?)

I do it like this:

1 list Boxes (bouquetlist)
1 image Box(bouqimg)

the code is like this:
Me!bouqimg.picture = Me!bouqList(the list name. it that correct?)

Yes in my system, there were many different bouquet types in my catalogue that available in one image box in one form. Everytime the customer click a different filepath, the image will change.
But the problem is..my bouquet picture still not appear and still blank.

Then in my catalogue form, under properties on the Order command button im writing, to link and open the order form. Transfer all the filepath that the customer choose (bouquet name,ID,Price and its description) into the orderform.

DoCmd.OpenForm "FrmOrderDetail", acNormal, , , acFormAdd, acWindowNormal, Me!Bouquetlist

Under the form_load properties of order form i also type- using OpenArgsmethods.
Me!bouquetlist= Me.OpenArgs (<----- to transfer the filepath from catalogue to order form.)
Me!bouqimg.picture = Me!bouquetList (<----- to copy the picture the from bouquet image box of catalouge to order form image box (bouquet), but still not appear the pic.)

But there was also an error message ("Microsoft Access cant find the field 'bouquetlist'referred into your expression") HOW?

What am I doing wrong? Help me..


1) Actually im carious that..Can we arrange 30 image boxes in on form? In addition, each image boxes got its order button which this order button link with one order form? Can i it do like this?
2) Or else If i use one list box for the bouquet list (bouquet ID, name) and one image box, one order button in the one form. Assume that i already have all the bouquet its pictures in my c drive. And every time customer click a different file path, the image will change's. In addition, how to transfer all the items in the list box and the bouquet picture that the customer choose to the order form and automatically the item that they choose in the list box display in the text box in the order form. How im going to do this?
I know u already told what i should do, and glad with ur suggestion got idea from that, but any different idea that u have and help me..or maybe what im doing is wrong..?

Again..any help ..reply soon thank You.

Erza