Access Database Help?????

[badtnc]

Access database ekak gana loku help ekak ona mmachan

mekai seen eka

Product 3k thiyanwa.
1.RAM
2.Memory Cards
3.Flash Drives.

Ram kiyana eka yatathe thiyanawa
256mb
512mb
1gb
2gb
kiyala

Memory Cards kiyana eke thiyanawa
Mini SD
micro Sd

kiyala

Flash Drive kiyana eke thiynawa
1gb
2gb
4gb
8gb
16gb
kiyala..

Table eka thiyenne | Product Name | Capacity |

kiyalai

dan mata ona Product name eka kiyana eke drop down menu ekakin ram select karama Capacity kiyana column eke
256mb
512mb
1gb
2gb
meawa tika ennai. meawa tika witharai pennana ona ram select karama.



Flash Drive kiyana eke select karama
1gb
2gb
4gb
8gb
16gb
kiyala capacity column eke penna ona..

how to do this in access 2003 ?????
2007 unath aulak na...

 

[badtnc]

kauruth nadda???

 

[badtnc]

kauruth access danna kenek nadda??

 

[black_cops]

kauruth nadda???

not clear what ur saying
can u upload ur access file I'll give a try

 

[ni_shi2005]

mata mewa amataka wela..machan..aya poddak behala balala kiyanam

 

[R_L]

hmm meka try karanna..

http://www.mediafire.com/?d4gwrf4nmao

i did a sample for u.. hard to explain it as such.. if u want send ur access file an ill add it up for u..

 

[badtnc]

hmm meka try karanna..

http://www.mediafire.com/?d4gwrf4nmao

i did a sample for u.. hard to explain it as such.. if u want send ur access file an ill add it up for u..

ela machan meaka wada... machan forms use nokara table eken drop down menu ekak hadanna bada ban???

 

[R_L]

ela machan meaka wada... machan forms use nokara table eken drop down menu ekak hadanna bada ban???

hmm table eken mama danna tharamata nam behe macho.. hebei mehema wedak puluwan.. u can create a form an display as a datasheet.. so it is a table then.. see the file i uploaded here.. the form called products final1.. open it an see if it suits ur need

http://www.mediafire.com/?tmzzjh3jlr4

hope it helps macho... hebei api koti kiyanna epa passe.. lolz... (sirasa threads wala ehema)
api meh okkoma methana inne fun eke help karanna.. so lets enjoy...

 

[badtnc]

hmm table eken mama danna tharamata nam behe macho.. hebei mehema wedak puluwan.. u can create a form an display as a datasheet.. so it is a table then.. see the file i uploaded here.. the form called products final1.. open it an see if it suits ur need

http://www.mediafire.com/?tmzzjh3jlr4

hope it helps macho... hebei api koti kiyanna epa passe.. lolz... (sirasa threads wala ehema)
api meh okkoma methana inne fun eke help karanna.. so lets enjoy...

hehe.. waraddak dakkoth eka kiyanwa.. ekata tharaha wena epa machan...
tx 4da help machan...

 

[badtnc]

machan karanne kohomada kiyala podi hint ekak denwada...??
methods dekama krana widiya...

loku help ekak machan

 

[R_L]

hehe.. waraddak dakkoth eka kiyanwa.. ekata tharaha wena epa machan...
tx 4da help machan...

pissuda ban.. all for the fun.. hope u take it the same way.. nothin personal ah.. pls dnt take anythin i may say wrng. hahaha.. u tc man.. glad i cud help. gud nit..

 

[R_L]

machan karanne kohomada kiyala podi hint ekak denwada...??
methods dekama krana widiya...

loku help ekak machan

hmm machan.. meka diga wediwei da manda..

oke wenne oya products danawa eka table ehekata.. ita passe ekata adala capacities assign karanawa.. then in the place where u want to have wat u wanted to work u use a small code..

first u make the table where u want this to work.. one field (products) shud be lookd up from the products table.. othr one normal text box callled capacity.. then u create a form based on that... u then change ur capacity textbox to a combo box.. eka karanna u have to select the capacity text box an riightclick an go to Change to> Combo Box.

then go to the Products field on the form. this is the value on which ur capacities will change.. different values in capacity depend on this products value..
go to the Properties of the Products field.... go to the After Update option and select the dotted box... select Code Builder.. u will get two lines of code like this seen:
Private Sub products_AfterUpdate()

End Sub

u then have to enter a code like this inbetween the two lines above:

Me.capacity.RowSource = "SELECT productcapa.[spec detail] FROM productcapa WHERE (((productcapa.[product])=[products]));"

to explain this code means that the row source or the values displayed on your capcities dropdown menu will change according to the value selected in your products field

productcapa is where u assigned the capacities.. that means assigned all the values that aany product can have.. ex: flash ekak can have 1, 2, 4, 8GB, etc...

so it selects those values WHERE the product name is equal to the name selectd in the current form.

 

[R_L]

meka table ekak hetiyatama pennanna puluwan as u wud have seen in the file i sent.... all u have to do is once u get the form displayin correctly.. go to properties an then select form properties.. u have to click on the small balck box next to the rulers on the top left hand side...

there go to Format tab.. then in Default View select Datasheet.... then make sure that Allow Form View, Allow Datasheet View, etc the 4 allow options are set to YES...

thats it u wil se it as a table..