X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Make Table Not Working In Macro, Access 2010    
post Nov 8 2017, 10:46 AM

Posts: 117
Joined: 10-December 11

When I run the make table via the query it works great ...but when I add it to a macro (via OpenQuery, View = Datasheet, Data Mode = Edit) it doesn't work at all. Any suggestions please?
Go to the top of the page
post Nov 8 2017, 12:21 PM

Posts: 1,344
Joined: 7-April 10
From: Detroit, MI

You can't view a Make Table query in datasheet mode. Are you trying to open the table made so that you can edit it? If so, that is a separate step.

1. Make table
2. Open the table just made in datasheet/edit mode

Remember ... Armstrong, Aldrin and Collins flew to the moon and back with a computer system less complex than a modern, programmable toaster ...
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    11th December 2017 - 05:52 PM