UtterAccess.com
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    
 
   
ssocr
post Nov 8 2017, 10:46 AM
Post#1



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
 
River59
post Nov 8 2017, 12:21 PM
Post#2



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