Append form results to new table

jak26

Board Regular
Joined
Dec 4, 2007
Messages
53
Hi

Hopefully someone can help

I have a form that shows the results of a query. The users can then edit some of the query data however I would then like the data to be written to a new table.

I thought I would be able to do it easily but it seems I have over estimated my ability

Cheers
Jeff
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,343
oops sorry - it's Access (and i haven't used it for a while)

But as far as i remember it's not necessary to take the data from the form but directly use the query
 
Last edited:

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,343
OK i remebered a bit more.
The Queries may be of different types.
Select Query, Make Table Query, Add Record Q., ......
u just need a second "Twin" query, just must be of type "Make table" and with the push of a button u run it .
Sorry, i can't be more specific but it's been quite a while and old my code is not handy right now.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,980
Messages
5,526,030
Members
409,680
Latest member
DonVito

This Week's Hot Topics

Top