PC Review


Reply
Thread Tools Rate Thread

Check table name

 
 
Pietro
Guest
Posts: n/a
 
      12th Nov 2008
Hi,

How can i do this in a form's timer event :
If there's a table called "Update" then DoCmd.deleteobject, acform "login"
If there's not DoCmd.....

 
Reply With Quote
 
 
 
 
navin
Guest
Posts: n/a
 
      12th Nov 2008
You can have form open in hidden mode and in its timer event you can
have your code to check if you have your table and delete the form:

for each t in currentdb.tabledefs
if t.name="Update" then
DoCmd.deleteobject, acform "login"
end if
next

navin

Pietro wrote:
> Hi,
>
> How can i do this in a form's timer event :
> If there's a table called "Update" then DoCmd.deleteobject, acform "login"
> If there's not DoCmd.....

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
What is the best way to check whether the value is in the table Boon Microsoft Access Form Coding 1 5th Mar 2009 08:37 PM
Check for table name Frederick Wilson Microsoft Access Form Coding 1 13th Mar 2006 08:17 AM
Q: Drop table and check if table exists Geoff Jones Microsoft VB .NET 10 1st Aug 2004 01:12 PM
Need to check another table first =?Utf-8?B?RGVzZXJ0IEJlYXI=?= Microsoft Access Form Coding 1 17th Feb 2004 10:46 PM
Check Table Name? Gary Microsoft Access Macros 1 18th Dec 2003 11:55 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:44 AM.