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: 125
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,426
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
Go to the top of the page
 
ssocr
post Dec 29 2017, 11:11 AM
Post#3



Posts: 125
Joined: 10-December 11



Changing the Data Mode to "Add" fixed the issue. Thank you!
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    10th December 2018 - 02:18 AM