If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
create a table code
I would like to programically create a table just before
opening a form and populate the table with an existing, non updatable recordset. When the form is open, it will contain information from the created table which will then be updatable. Any suggestions on code to use for this? Thanks Jeff G |
#2
|
|||
|
|||
create a table code
"Jeff G" wrote in
: I would like to programically create a table just before opening a form and populate the table with an existing, non updatable recordset. Get the SQL for the existing nonupdateable recordset and turn it into a INSERT INTO YourNewTable SELECT etc etc command, then execute it. This is an append query into the new temp table. When the form is open, it will contain information from the created table which will then be updatable. I do not understand how this will help you though. In most cases, a recordset is nonupdateable because it is not possible to know which record belongs to a particular row in the recordset, so you may not be able to store any changes that the user makes anyway. Hope that helps Tim F |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Select records | Ricoy_Chicago | General Discussion | 6 | July 16th, 2004 07:12 PM |
Name not showing ID is | René | Setting Up & Running Reports | 11 | June 29th, 2004 01:40 AM |
Adding selected data (using code atached to cmd button from a form) to a table | Chris | Using Forms | 0 | May 26th, 2004 12:12 PM |