Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to test in macro condition if table exist?

Status
Not open for further replies.
Dan01

Dan01

Programmer
Jun 14, 2001
439
US
Hi, I wish to drop a table if it exists. How would I write the contitional statement? Thanks, Dan.
 
Sort by date Sort by votes
Never mind guys. I called a function from a macro this way:

Public Function Dropit()
On Error Resume Next
DoCmd.DeleteObject acTable, "TABLEA"
End Function

Thanks, Dan.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

V
  • Locked
  • Helpful tip
Capture Shift Key if Pressed on A form
Replies
3
Views
387
strongm
strongm
btamsgn
  • Locked
  • Question
How to add lines from textbox to table 1
Replies
8
Views
252
MattGreer
MattGreer
Moss100
  • Locked
  • Question
Transfer data from external table to identical local table - urgent please
2
Replies
27
Views
671
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Vba adding record to table when field is integer
Replies
8
Views
384
Moss100
Moss100
btamsgn
  • Locked
  • Question
How to edit column chitoi into TableA
Replies
0
Views
154
btamsgn
btamsgn

Part and Inventory Search

Sponsor

Back
Top