473,698 Members | 2,300 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to cycle thru ALL forms?

MLH
Am having trouble with the following
snippet. It stops after only cycling thru
open forms. There are many more than
that. How to modify this to cycle thru
all forms?

Sub AllOpenForms()
Dim frm As Form
' Enumerate Forms collection.
For Each frm In Forms
' Print name of form.
Debug.Print frm.Name, frm.MenuBar
Next frm
End Sub

Oct 9 '06
21 10628
Bri

David W. Fenton wrote:
Bri <no*@here.comwr ote in news:3pQWg.1192 91$1T2.13017@pd 7urf2no:

>>I use AC97 for development 99% of the time and then convert up to
the clients version on installation.


I used to do that, but there were too many things that work just
fine in A97 that break in A2K, so I now do all of my development for
A2K clients in A2K itself.
What kind of things do you find breaking? I haven't had any real
problems. I recall there were a few things that didn't work in AC2K that
an alternate method worked fine in both. I don't recall specifics as
I'm now in the habit of using the method that works in both versions. I
do have one app with conditional formatting that I have to add back in
to the form after I convert it, but I only need to worry about that one
rarely. If there are some gotcha's waiting down the road it might help
to know about them ahead of time.

--
Bri

Oct 10 '06 #21
Bri <no*@here.comwr ote in news:SFWWg.1249 68$R63.11256@pd 7urf1no:
>
David W. Fenton wrote:
>Bri <no*@here.comwr ote in
news:3pQWg.119 291$1T2.13017@p d7urf2no:

>>>I use AC97 for development 99% of the time and then convert up to
the clients version on installation.


I used to do that, but there were too many things that work just
fine in A97 that break in A2K, so I now do all of my development
for A2K clients in A2K itself.

What kind of things do you find breaking?
The "subform referring to a field in parent form's recordsource"
problem was the last straw for me. I wasted days troubleshooting it.
That was after encountering a handful of other peculiarities which I
don't recall.
I haven't had any real
problems. I recall there were a few things that didn't work in
AC2K that
an alternate method worked fine in both.
There are almost always alternate approaches, but if you're the
first one to encounter and document the problem, it may be hard to
figure out what the alternative is.

I just wasted too much time on that kind of thing, and simply
stopped doing the development in A97 except if it was going to be
deployed in A97.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Oct 11 '06 #22

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
1981
by: John Ortt | last post by:
Hi there, I have written the following code to colour cycle the background in one of my forms. The problem is it only cycles from Black to Red and then reverts back to Black. Does anyone have any idea what's causing this?
4
1781
by: sparks | last post by:
OK we have it so we can use tables to define skip patterns on our forms. BUT we can only do one form. Public Function skipPattern(currentFrm As Form, Optional currentCtl As Control = Null) As Integer the current form. ouch. this works fine as long as the controls are all on one form.
11
3560
by: DFS | last post by:
Architecture: Access 2003 client, Oracle 9i repository, no Access security in place, ODBC linked tables. 100 or so users, in 3 or 4 groups (Oracle roles actually): Admins, Updaters and ReadOnly. Each group sees a different set of menu options when they open the client and login to Oracle. For the sake of speed I use pass-through queries here and there for updates and deletes. I update their SQL property in code and execute them.
1
988
by: Paul W | last post by:
If I hit F5 from VS without making any previous changes to the project, it appears on screen in 4 seconds. If I make any minor change to the project before hitting F5 it takes 20+ seconds. This is currently a small project (2 forms). This gets very old very quickly during a debugging session. Is there anything that can be done to reduce this time? Thanks, Paul.
2
1394
by: Dean Slindee | last post by:
Is there any way to refer to the .text property of a status bar panel thru object syntax, like below (the inner "for" does not work): Public Function FormStatusBarPaint(ByVal frm As Form) As Integer Dim obj As New Control
1
2243
by: sranney | last post by:
Hey all, I'm trying to get access (through VBA) to cycle through all the records in a form and perform a task for each one that has something in a text box. I think I know how to get it to do what I want, I just don't know how to reference a record in my For each... statement. Here is the code I have: Dim Record As Recordset For Each Record In Forms!frmRFIattach If Not Forms!frmRFIattach!Attachment = "" Then ...
2
5064
by: ckerns | last post by:
I have a page with a bunch of drop down boxes. They are named: MonEquipAMWk1 MonEquipPMWk1 thru FriEquipAMWk1 FriEquipPMWk1
2
1444
by: User | last post by:
Hi, How to go about iterating thru all the text box in a form? Any pointers or reference i can read up on? Thanks
10
2088
by: fdu.xiaojf | last post by:
Hi all, I have the following code: for i in generator_a: # the first "for" cycle for j in generator_b: if something_happen: # do something here ..., I want the outer cycle to break break
0
8676
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8608
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9161
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9029
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
6522
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5860
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4370
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4619
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3050
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.