creating Form like as user Receipt

[sankar519]

Hai All,

i have one table example xx. and its having columns item name,quantity,price.

i want to create a user form and when i enter the item name and press search downside it will come 3 columns data automatically.
Actually its a retail company and i want to create a receipt when customer purchase the items.


I just want to create a form and if i select 3 items then it will add downside automatically.


pls help me to do this in Access 2007.its very urjent for me.
pls help me to do this.

thanks & Regards
Ravi.

[ItsMe]

Before you can build a form, you need a table. Before you can build a form that creates a sales transaction, you need more than one table and at least one query.

Suggest building a Named Saved Query Object that allows you to append at least one of your tables (an event table). Combo Box controls on your form can populate Foreign Key fields in your event table (table to store new sales) that the Query Object did not populate.

[sankar519]

Thank you so much your reply.

i created the table and i created the query based on that table. but i am not able to create a form like above mentioned images.i want to display the items only what user is searching and if user want that items we can add it in the below details andwe can generate the receipt and print it.

Pls help me to do this...

thanks

[ItsMe]

The only way I know to do what you are describing is through VBA. You will need to add criteria to the form's Filter or RecordSource property.

The simplest may be something like



dim strFilter as string
strFilter = ""

if isnull(Me.txtOne) = False Then
if strfilter = "" then
strFilter = "[Item] = " & Me.txtOne
else
strFilter = strFilter & " AND [Item] = " & Me.txtOne
End if

End if

me.filteron = false
Me.Filter = ""
Me.Filter = strFilter
me.filteron = true

[sankar519]

thanks for your reply.
Actually i don't no anything about Access. i done this in EXCEL but i am not able to do this in Access.i am trying for this from last 4 days but i cant.
.



when i select the items it will effect in another sheet and then we will print it.
if customer dont want any items just click on clear button then it will clear all the fields.

just help me to do only first form atleast.

[sankar519]

thanks for your reply.
Actually i don't no anything about Access. i done this in EXCEL but i am not able to do this in Access.
i am trying for this from last 4 days but i cant.

[ItsMe]

...
Actually i don't no anything about Access. i done this in EXCEL but i am not able to do this in Access.
...

Before you can build a form, you need a table. Before you can build a form that creates a sales transaction, you need more than one table and at least one query.