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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 6 simple tips to get more out of…