Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
harjinder
Starting Member
3 Posts |
 Posted - 2005-08-01 : 08:32:15
|
| Hi, i have table with more than 60 fields.The unique Id is autonumber field. In order to show all the fields and other error messages labels on single form is not possible, so we use multiple forms in a tab control. while switching from one form to other the unique id of table is increased as data inserted inthe table.And if i bifergate the table into multiple tables as the number of forms then it also create a problem as single id is needed at the time of generation of report . As report consider all the fields in one cycle. Pls tell me how to create the connection and use recordset in the code editor of MS Access. It is needed when i switch from one page to other. On the click event of the button the next page loaded and the id of previous page is taken to next page and used for insert query in the new page.So that the autogeneration of the unique id will be stopped and the field values saved against the same id.waiting for the suitable suggestion and help.Thanks. |
|
|
SMerrill
Posting Yak Master
206 Posts |
Posted - 2005-08-10 : 20:15:30
|
| Can't you just put one tab control on one form, and store about 10 controls on each of 6 tabs without using a subform at all?This keeps one 60-column record on the same form and doesn't increase your autonumber field until you save the whole (new) record.~ Shaun MerrillSeattle, WA |
 |
|
|
|
|
|
suggestion regarding the use of recordset.