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
|
|||
|
|||
lost fields in temp table
Hi
Is it possible to add new fields to a temp table or do they have to come from existing tables? for instance - i have a form based on 2 temp tables. i'd like to add new information on the form and want that info to be stored in the temp tables. i've created 5 new fields and assigned them to textboxes however when i close the form and go to a new record - the textboxes say #Name #Add1 etc and the fields in the temp table have disappeared. Im new to how temp tables work... can anyone help explain why this happens? thanks -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
lost fields in temp table
Why are you adding fields to your table on the fly? if they're
temporary tables anyway, why not just put them in beforehand and not use them? this sounds like WAAAAAY mroe trouble than it's worth. Not to say it's impossible - it definitely is possible. See CreateField in the DAO help. but why oh why do you want to do this? |
#3
|
|||
|
|||
lost fields in temp table
lol the reason im adding fields to a temp table rather than a 'normal' table
is becasue i dont actually want the data to be stored in the database - i jst want the temp table to kinda 'hold' it as it passes records and then get deleted. sounds pointless but it's really effective ...by using temp tables, it avoid having to 'store' info in your database when it's not needed so u have more space and the speed isnt effected. relating back to my question- i realised that temp_table was created via coding, not through the normal procedure to create a table. the reason for this is so the coding actually does what it's suppose to and kinda flows instead. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200609/1 |
Thread Tools | |
Display Modes | |
|
|