Hello Astro

It can be done.You have to create a table for that with exact
informations to be stored and save the data in the table.
Again when we load that created form, we need to check
is any data availabel with respect to this form. If yes
we load it from the table, if no, just load the form.

And, by the way, those two images are not opening here
for me, which ever link i click it goes to angel fire's
logo.

If those images are related to your doubt then kindly
upload them again. so i can see those images.

With Regards,
Raghavendra Mudugal

Hey there Raghavendra Mudugal.

In this case, the text-fields i have created will work with sql statements?
e.g. INSERT into table.... and so on?

The form is intended to be sent to individual recipients. Information that has been previously filled by the recepient will appear on the form (which has been stored in a table)

Thanks

Astro

Hey there Raghavendra Mudugal,

so the form i have created with text-fields will have to work with sql statements e.g, INSERT into table... and so on?

Thank You

Astro

Hello Astro,

Yes, If you need those filled information back at
any time then, storing in the table is the idea.
There are so many other ways of storing the data
and getting it back. But It is already a access
database, all we have to do is to create a good
table with allowes us to store all the information
we need. So we can get it back any time.



With Regards,
Raghavendra Mudugal

Hey Raghavendra Mudugal,

Yea i got it, access has this memo datatype which handles up to 65k+ characters. that'll work for the question database. I'll start working on it today. Thank you so much all these while. I'll keep you updated! Thanks!

Astro

Hello Raghavendra Mudugal,

In order to pull data (questions) out of the table and display them on the form, do i work on VBA codes or there are wizards in MS access to perform such operations?

Thanks

Hello Astro

Yes, but as a part of it. we need to use VBA only
for showing the data from the table to the textbox
controls And for fetching the data from the table,
Here we need to use ADO (ActiveX Data Object)
which handles the connection with the database
and get the data from the table which we specify.
After getting the data we need to put them in the
form controls as you want to show.

There is no wizard or as such, It is good if you
write the code for getting the data. You will
explore a lot of the things here that really helps
you a lot.


With Regards,
Raghavendra Mudugal

Hey Raghavendra Mudugal

I got it! Thanks, i'll explore with ADO now and update if there are any doubts! Thanks!!!

Astro

Hello Raghavendra Mudugal

I have been trying to connect up my database named 'db2' but unsuccessfully.

Dim cnn As ADODB.Connection
Set cnn = CurrentProject.Connetion
cnn.Open.

Do i replace 'CurrentProject' with 'db2' or 'db2.mdb', neither can be complied.

I have just tried 'question' (one of my table) and it has just complied and nothing happened! haha.


Thakn You.

Astro

Hello Astro

Check this link
http://in.geocities.com/raghavendra_...l/db_ado01.zip

It contains a database. It got a table called "cust"
just a sample table. And in the form section, open
the form ADO_Getdata and click that button that
collects the data and puts in to the listbox from the
table "cust"

I am using the ADO2.5 to establish the connection
and getting the data. check this and let me know

Hope this helps

With Regards,
Raghavendra Mudugal