Microsoft Access Help Required

  reece1705 10:27 31 Aug 06
Locked

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 06

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

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

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

  silverous 12:04 01 Sep 06

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 06

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.

Surface Pro 5 News - release date, UK price, features, specs

Gear VR vs. Daydream: Which delivers the best VR experience?

Best Mac antivirus 2017