Microsoft Access Help Required

  reece1705 10:27 31 Aug 2006

I am building a database to store customer details and act as a bookings system.

I have built a criteria capture form, a query which interprets the criteria set in the capture form (using the Like command) and a data output form which displays the results of the query.

Does anybody know how i could then take the data in the output form and save it in a new table using a command button?

  picklefactory 17:17 31 Aug 2006

Hope it's OK to mention other forums, but you might have some luck on There is an Access section there I have found very helpful in the past.

  picklefactory 17:18 31 Aug 2006
  reece1705 10:22 01 Sep 2006

Cheers for the link. I'll be sure to take a look at it

  silverous 12:04 01 Sep 2006

reece, yes you can create a macro on the button and get it to run a query. The query can be a 'make table' query or perhaps just an append query, maybe delete from the output table first if you want it empty.

  reece1705 13:31 01 Sep 2006

Thanks silverous. That was exactly what i was looking for. The append query was the one I needed.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

HP’s new Surface Pro rival is designed specifically for Adobe-using designers and artists

Best kids apps for iPhone & iPad

Que faire si son iPhone ou iPad est tombé dans de l'eau ?