Can I add "more" data to existing recordset in MS Access ?

Question

User-121405395 posted

Can I add more data in maybe 4 steps into the same recordset?

It would be like:

1. addPageLayout = submit

2. addHeadline = submit

3. addPhoto = submit

and addText = submit

... but everything in the same row in the table but at different time?

Answer 1

User1867929564 posted

in the same row in the table but at different time? 

I think,yes.using datatable or dataset,session.
But you hv to re-explain ur requirement again to get exact answer.

Answer 2

User-121405395 posted

Hi and thanx for the answer....

In details I have a content management system I´ve developed last year and I´m just improving it further....

I want the user to add new page in a different way.... so he choose layout from 4 various types and hit update and
a info is sent to the field "layout" in lets say the table "tblPages"

now the user can view the layout and next step is to add headline, image and short intro-text, user hits submit and
info go into the SAME row under fields "headline", "file1" (the image) and "introtxt"

Then he choose type of modules to add the main-text, "plain text", 3 text boxes with icons or text boxes in single line with max 5 lines
User choose "3 text boxes and info is sent to the field "moduleType" in the SAME row in tblPages

Hope this is understandable :)

Answer 3

User1867929564 posted

i) all these thing happen in one page or different pages ?Say I choose layout in PageA then to select  other thing I will be in same page or navigate to other page ?
ii)User can select any layout and at the same user can add headline, image and short intro-text.
and hit "update".then all the info get submitted.
iii)also user can select layout now and later on user can add headline, image and short intro-text.
and hit "update" then all info of that user get updated.
iv) what is the table structure ?
v)Are you able to identify user?How ?

Yes,you can do this.Just get started and if any problem then ask.

Answer 4

User3866881 posted

Hey OP... KumarHarsh is friendly to tell you that everything can be done.

Have you got any issues? Maybe you should feeback to us, whether your problem is solved or not.

Thx very much

:) 

Answer 5

User-821857111 posted

In the first step, you will create a new record. In the subsequent steps, you will be updating the new record. Therefore you need the identity of the record you created in the first step. Make sure that you have AutoNumber set as the datatype for the id of the record, then you can get its Id using @@IDENTITY: http://www.mikesdotnetting.com/Article/54/Getting-the-identity-of-the-most-recently-added-record. You can pass this to subsequent steps using a query string, or hidden fileds depending on what works best for you.