Edit a particular element in a data base table

[karpaga]

Mike i didnt specify the sizes

[MikeS81]

Hi kavi,

do you mean an array of names and marks? Or do you want to write a 2d Array into one cell?

Mike

[MikeS81]

---

karpaga wrote:
Mike i didnt specify the sizes

---

Hi kavi,

you see it, if you change to the design view.

Mike

[karpaga]

i automatically set to 4 and 2 for names and marks.

[karpaga]

it automatically sets to 4 and 2

[karpaga]

U can see in the picture that i insert the 2 D array Data using for loop.My question is it possible with out for loop ie. directly wire it in to the the insert DB tool?

[MikeS81]

Hi kavi,

i don't know if the insert command can also insert more than one dataset at ones. Where is the problem with the loop?

Mike

[karpaga]

No problem its working good.just i want to know without loop is possible.

[karpaga]

Hi

Is there is any option to find if an database file eg.sample.mdb  exist or not as like check if file exist or not function? 

[karpaga]

anybody has answer for my question?