Re:RE: [MS_AccessPros] Get a list of all form names

 

Graham-

Thanks a lot.

Best Regards,

Kevin

KEVIN Z.

Overprepare, then go with the flow.

在 "'Graham Mandeno' graham@mandeno.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2017年3月21日 09:25写道：

 

Hi Kevin

 

The best method depends on what you want to do with the list.

 

You can enumerate the AllForms collection:

  Dim o As AccessObject

  For Each o In CurrentProject.AllForms

    Debug.Print o.Name ' do something more interesting here if you like!

  Next

 

You can also write a query on the MSysObjects table:

SELECT MSysObjects.Name FROM MSysObjects WHERE MSysObjects.Type=-32768;

 

Best wishes,

Graham

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, 6 March 2017 23:09
To: MS_Access_Professionals <MS_Access_Professionals@yahoogroups.com>
Subject: [MS_AccessPros] Get a list of all form names

 

 

Dear All-

Is it possible to get a list of all form names by running a command button? Thanks in advance.

Best Regards,

Kevin

 

__._,_.___

---

Posted by: "KEVIN Z." <qingqinga@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___