Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 24th, 2003, 12:59 PM
Friend of Wrox
  
Join Date: Jun 2003
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Default Table Creation
When I create a table using the SQL "CREATE TABLE ..." statement, the new TableDef seems invisible until I close and re-open the .mdb. Is there an easier way to refresh the TableDefs collection, using VBA?

Rand
__________________
Rand
 
Old June 24th, 2003, 08:01 PM
Friend of Wrox
  
Join Date: Jun 2003
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default
I've found that just switching from the table pane to another (queries for example) then back - refreshes it.

There are 10 kinds of people in the world - those who understand binary - and those with friends





Similar Threads
Thread Thread Starter Forum Replies Last Post
Table creation sunny227 XSLT 3 November 14th, 2007 02:50 PM
Creation date of a table firefighter2045 Access VBA 4 November 2nd, 2007 10:52 AM
Regarding Table of Contents Creation forrestfsu XSLT 7 June 21st, 2007 03:04 PM
creation of table from xml file s2_saha XML 0 April 27th, 2007 01:14 AM
Dynamic Table Creation in DTS Package clm100 SQL Server DTS 3 September 3rd, 2004 04:08 PM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.