One column flashing on continous form - Microsoft Access / VBA

Randy Harris

Strange problem on A2K. A continuous form is getting some sort of strobe
effect on several systems that have been upgraded to Windows XP (never saw
the problem on Win2K). One of the text boxes is flashing the contents.
Users are calling it "Slot Machine Mode". Anyone ever run into something
like this?

Any suggestions appreciated.

Nov 12 '05 #1

Subscribe Reply

2301

Allen Browne

Could be a problem with conditional formatting:
http://allenbrowne.com/bug-05.html

A2003 also has this display problem on WinXP:
http://allenbrowne.com/ser-46.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Randy Harris" <ra***@SpamFree .com> wrote in message
news:fb******** ****@newssvr33. news.prodigy.co m...

Strange problem on A2K. A continuous form is getting some sort of strobe
effect on several systems that have been upgraded to Windows XP (never saw
the problem on Win2K). One of the text boxes is flashing the contents.
Users are calling it "Slot Machine Mode". Anyone ever run into something
like this?

Nov 12 '05 #2

CDB

I have experienced problems like this with multi-sub forms (migrated from
A97), where the auto-recalculate keeps cycling through...

Fixed by dropping calculated controls on the main form and using code to
update other subs.

Clive
"Randy Harris" <ra***@SpamFree .com> wrote in message
news:fb******** ****@newssvr33. news.prodigy.co m...

Strange problem on A2K. A continuous form is getting some sort of strobe
effect on several systems that have been upgraded to Windows XP (never saw
the problem on Win2K). One of the text boxes is flashing the contents.
Users are calling it "Slot Machine Mode". Anyone ever run into something
like this?

Any suggestions appreciated.

Nov 12 '05 #3

Randy Harris

Allen, I think you nailed it with the conditional formatting. But, I can't
figure out what to do to stop it. The formatting is pretty simple, if a
certain field (not the control source for the misbehaving control) contains
"(cont)" then change the background color of the control.

Is there some means of working around this, or must I simply shut off the
conditional formatting? I hate to remove a feature that the users have
gotten accustomed to.

The app is developed in A2K and there appears to be no problem until it is
run in A2K3.
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message
news:40******** *************** @freenews.iinet .net.au...

Could be a problem with conditional formatting:
http://allenbrowne.com/bug-05.html

A2003 also has this display problem on WinXP:
http://allenbrowne.com/ser-46.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Randy Harris" <ra***@SpamFree .com> wrote in message
news:fb******** ****@newssvr33. news.prodigy.co m...

Strange problem on A2K. A continuous form is getting some sort of strobe effect on several systems that have been upgraded to Windows XP (never saw the problem on Win2K). One of the text boxes is flashing the contents.
Users are calling it "Slot Machine Mode". Anyone ever run into something like this?

Nov 12 '05 #4

Allen Browne

From memory, it is the combination of calculated controls and conditional
formatting that is deadly, as they seem to trigger each other.

AFAIK, there is no real fix for the problem. You could try basing the form
on a query and putting the calculation into the query (as a calculated
field) instead of the ControlSource of the text box, to see if moving it
back a level takes you out of the loop.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Randy Harris" <ra***@SpamFree .com> wrote in message
news:xN******** **********@news svr31.news.prod igy.com...

Allen, I think you nailed it with the conditional formatting. But, I can't figure out what to do to stop it. The formatting is pretty simple, if a
certain field (not the control source for the misbehaving control) contains "(cont)" then change the background color of the control.

Is there some means of working around this, or must I simply shut off the
conditional formatting? I hate to remove a feature that the users have
gotten accustomed to.

The app is developed in A2K and there appears to be no problem until it is
run in A2K3.
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message
news:40******** *************** @freenews.iinet .net.au...
Could be a problem with conditional formatting:
http://allenbrowne.com/bug-05.html

A2003 also has this display problem on WinXP:
http://allenbrowne.com/ser-46.html

"Randy Harris" <ra***@SpamFree .com> wrote in message
news:fb******** ****@newssvr33. news.prodigy.co m...

Strange problem on A2K. A continuous form is getting some sort of strobe effect on several systems that have been upgraded to Windows XP (never saw the problem on Win2K). One of the text boxes is flashing the contents. Users are calling it "Slot Machine Mode". Anyone ever run into something like this?

Nov 12 '05 #5

Similar topics

5894

Putting flashing cursor in textbox automatically

by: Xam | last post by:

Hello Everybody Can you let me know of a javascript/dom routine that will automatically put the flashing cursor in the first text box in my form so that it is ready for entry rather than the user having to click into the first textbox with their mouse. Please note that my forms are created dynamically so I won't know the given name of the first textbox so some form of index would be better.

Javascript

5140

show different colors on a continous form

by: JK | last post by:

Hi All, I am working a form which is tabular layout (continuous form) which will display multiple records at a time. Each line of record needs to be reflected on the color code to show their current status. In Access 2000, you can only write the code on each control in a general way and the code will apply on to the current record. For instance, if you have 5 customers in display, each one of them has difference balance, if you like to...

Microsoft Access / VBA

2332

Wanting to add a checkbox to the detail area of a continous form

by: adolph | last post by:

I would like to add a check box to the detail area of a continous form. So that I can check on specific records, then after I've marked all the records I watn to delte, click a button to loop thru these check boxes, if checked get the field with the underlying table record ID and run a query to delete it. I've built a continous form to show all the records. I now want to add a check box beside each record, so that I can check specific...

Microsoft Access / VBA

1731

Calculation-Continous form

by: gavo | last post by:

Hi. using A2K; i have a form containing a continous subform. The question is, how can i call a calculation for one of the fields in the continous subform from the main form. At the moment i have a button on the main form that will call a public code containing the calculation i need, the problem i have is that it will only perform the calculation on the first record on the continous subform and i need it for all the records

Microsoft Access / VBA

5434

CSharp Resize flicker and flashing

by: Ian Stiles | last post by:

If you have "Show window contents while dragging" turned on (Right-click desktop, Appearance, Effects) then you get horrible flashing and flickering on a CSharp form when the form hosts a TreeView or WebBrowser control and then you resize the form. Here is what I've tried so far: 1. Turning off CS_VREDRAW and CS_HREDRAW in both the parent form and a subclass of the control via the "override CreateParams" property (these values were...

C# / C Sharp

1426

Continous form - datagrid

by: ReidarT | last post by:

I have started to develop in vb.net. Earlier development was in MS-Access. I need a lot of continous forms to present data. The customer add and edits data in the continous form. Is use of datagrid the way I should do it in vb.net? I need up to 1000 records in a continous form (mostly 3-400) regards reidarT

Visual Basic .NET

2839

Complicated continous form column Sum

by: Kev | last post by:

Hi, I am trying to total a column (Shift1) in a subform (continous forms) from the after update event of the (Shift1) column control within the subform. This column stores shift codes, I want to sum the hours associated with these shift codes from the RosterShifts Table. ie. Shift1 may = D The D shift is 8 hours long I am using Dictionary objects within the form as suggested by Gord,

Microsoft Access / VBA

1411

Continous Form

by: questionit | last post by:

Hi I know how to implement Continous form. In the method i have tried, the source for data on the continous form comes from table using SQL query Now, i want to try something different and i need your help. With the same continous form, i want the source for the data to be a simple piece of code that returns names of files in the folder. I have completed working code for getting file names in the folder:

Microsoft Access / VBA

2133

Refresh data in a continous form

by: AccessHunter | last post by:

Hi, I have a continous form that displays Name and Address of Suppliers. In the form there is a combo box for 'Active Address' and 10 other text boxes. All the fields coem from one table, "Primary Suppliers". The combobox is for 'Active Address' with values 'Yes' and 'No'.Control source of the form is, Select * from PrimarySuppliers where ="Yes". I want the form to display only the Suppliers who has 'Active address' = "Yes".If user selects...

Microsoft Access / VBA

9706

What is ONU?

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...

General

9579

Changing the language in Windows 10

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,...

Windows Server

10326

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

7615

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

6851

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

5651

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4295

transfer the data from one system to another through ip address

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

C# / C Sharp

3815

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2990

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General