Subform screen problem - Microsoft Access / VBA

Trevor Drake-Brockman

Hoping some can help.

Have a subform that is working fine except if you swap to another
application and then back to the access form when you do that the area over
the subform is not updated correctly and display the previous application.

Hopfully some has the answer!

Nov 12 '05 #1

Subscribe Reply

1633

MGFoster

Trevor Drake-Brockman wrote:

Hoping some can help.

Have a subform that is working fine except if you swap to another
application and then back to the access form when you do that the area over
the subform is not updated correctly and display the previous application.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I've noticed that on Windows XP systems. My guess is it's some sort of
display bug (whether in the O/S or Access is the question). If you use
the Alt-Tab method of switching between applications it doesn't seem to
happen as much. If you click the application icons on the taskbar it
happens more often. When it does happen you can get the "real"
application to appear by clicking on the display. If that doesn't work
click back & forth on the taskbar application icons until it does
appear. A Wonky Work-around.

- --
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQG6LD4echKq OuFEgEQJ+8gCfbx P4M/96ogZ+FyJiZcB8R 3xHwpgAoMIq
rE03urKl8LiADPY LafRp8uag
=jAjG
-----END PGP SIGNATURE-----

Nov 12 '05 #2

Don Leverton

Hi,

Just an idea (that I haven't tried...)

Private Sub Form_Activate()
Me.Refresh
End Sub

--
HTH,
Don
=============== ==============
Use My*****@Telus.N et for e-mail
Disclaimer:
Professional PartsPerson
Amateur Database Programmer {:o)

I'm an Access97 user, so all posted code
samples are also Access97- based
unless otherwise noted.
=============== ==============
"MGFoster" <me@privacy.com > wrote in message
news:pW******** **********@news read1.news.pas. earthlink.net.. .

Trevor Drake-Brockman wrote:
Hoping some can help.

Have a subform that is working fine except if you swap to another
application and then back to the access form when you do that the area over the subform is not updated correctly and display the previous
application. -----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I've noticed that on Windows XP systems. My guess is it's some sort of
display bug (whether in the O/S or Access is the question). If you use
the Alt-Tab method of switching between applications it doesn't seem to
happen as much. If you click the application icons on the taskbar it
happens more often. When it does happen you can get the "real"
application to appear by clicking on the display. If that doesn't work
click back & forth on the taskbar application icons until it does
appear. A Wonky Work-around.

- --
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQG6LD4echKq OuFEgEQJ+8gCfbx P4M/96ogZ+FyJiZcB8R 3xHwpgAoMIq
rE03urKl8LiADPY LafRp8uag
=jAjG
-----END PGP SIGNATURE-----

Nov 12 '05 #3

Trevor Drake-Brockman

Thanks for the reply, but it is running on W2K with the same problem. I
have noticed that it must be a property of the main form as if I copy a
subform from another form that works then I get the same problem.

I have check through the properties but can't see anything that should cause
the problem.

"MGFoster" <me@privacy.com > wrote in message
news:pW******** **********@news read1.news.pas. earthlink.net.. .

Trevor Drake-Brockman wrote:
Hoping some can help.

Have a subform that is working fine except if you swap to another
application and then back to the access form when you do that the area over the subform is not updated correctly and display the previous
application. -----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I've noticed that on Windows XP systems. My guess is it's some sort of
display bug (whether in the O/S or Access is the question). If you use
the Alt-Tab method of switching between applications it doesn't seem to
happen as much. If you click the application icons on the taskbar it
happens more often. When it does happen you can get the "real"
application to appear by clicking on the display. If that doesn't work
click back & forth on the taskbar application icons until it does
appear. A Wonky Work-around.

- --
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQG6LD4echKq OuFEgEQJ+8gCfbx P4M/96ogZ+FyJiZcB8R 3xHwpgAoMIq
rE03urKl8LiADPY LafRp8uag
=jAjG
-----END PGP SIGNATURE-----

Nov 12 '05 #4

Trevor Drake-Brockman

Thanks for your help, tried that but still happening.

Have tried cuting and pasting a subform in the same application that is
working. When I do that I still get the same problem so I fairly sure it
must be something to do with a property on the main form.

"Don Leverton" <le************ ****@telusplane t.net> wrote in message
news:dzLbc.3064 $J56.2650@edtnp s89...

Hi,

Just an idea (that I haven't tried...)

Private Sub Form_Activate()
Me.Refresh
End Sub

--
HTH,
Don
=============== ==============
Use My*****@Telus.N et for e-mail
Disclaimer:
Professional PartsPerson
Amateur Database Programmer {:o)

I'm an Access97 user, so all posted code
samples are also Access97- based
unless otherwise noted.
=============== ==============
"MGFoster" <me@privacy.com > wrote in message
news:pW******** **********@news read1.news.pas. earthlink.net.. .
Trevor Drake-Brockman wrote:
Hoping some can help.

Have a subform that is working fine except if you swap to another
application and then back to the access form when you do that the area over the subform is not updated correctly and display the previous

application.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I've noticed that on Windows XP systems. My guess is it's some sort of
display bug (whether in the O/S or Access is the question). If you use
the Alt-Tab method of switching between applications it doesn't seem to
happen as much. If you click the application icons on the taskbar it
happens more often. When it does happen you can get the "real"
application to appear by clicking on the display. If that doesn't work
click back & forth on the taskbar application icons until it does
appear. A Wonky Work-around.

- --
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQG6LD4echKq OuFEgEQJ+8gCfbx P4M/96ogZ+FyJiZcB8R 3xHwpgAoMIq
rE03urKl8LiADPY LafRp8uag
=jAjG
-----END PGP SIGNATURE-----

Nov 12 '05 #5

Similar topics

2090

SubForm on Tab Control Issue

by: Ima Lostsoul | last post by:

Access XP Access 2002 format. I have a subform on a tab control. The subform has the following code (error trapping removed to make post shorter)... When I close the parent form it goes 100% as designed UNLESS I have used one of the sort buttons to sort the sub form on any given field. If I do sort, there is a delay fo about 5 seconds until after the parent form closes and the previous form re-opens. It appears that there may be...

Microsoft Access / VBA

2036

The old subform trick.....

by: Ray | last post by:

I have a main form with a subform. The main form has a combo box which lists all the clients which in turn are displayed in the subform. The subform is bound to the combo box and all work well. however, I would like to be able to add a new client in the subform but this is, of course bound to the combo box. Can anyone tell me if there is a way to enter a new client in the subform with out receiving an error message? TIA - Ray

Microsoft Access / VBA

2241

Subform will only show 6 records

by: John Baker | last post by:

Hi: I have a sub form which i would like to show all the records selected from a table. There may well be over 100 of them. For reasons I cant fathom, the form will only show six, and then requires that you move using the record selection box to see any records below that. I would like the whole record set to be available using the vertical slider, since this is much more convenient for the user. Cab someone suggest what is wrong. The...

Microsoft Access / VBA

1626

How to maintain appearence of selected text when subform loses focus?

by: (Pete Cresswell) | last post by:

I'm using a subform as a navigation list. On the left side of the screen is a subform containing people's names. The right side of the screen is loaded with information about the currently-selected person. As the user walks the list, the right side of the screen gets reloaded with info about each new name. When the user decides to change something, they click an "Edit" button that puts

Microsoft Access / VBA

2021

Possibility to divide a tall subform to two short subforms?

by: Paul T. RONG | last post by:

Is it possible to divide a tall subform with 80 records to two subforms each with 40 records? Dear All, What I have: Tables: tblProduct, tblOrder, tblOrderDetail

Microsoft Access / VBA

2064

Add subform to a form?

by: Rich | last post by:

Can a vb.net form contain a subform? If yes, how is this done? Maybe I am going about my issue the wrong way. I start an asynchronous procedure from my main form - invoke a routine on a mainframe computer. Then I am polling every 10 seconds (timer1) to see if the external program has generated a data result set for my form to retrieve. In the meantime, on the same main form I have a series a little labels that blink on/off in a series...

Visual Basic .NET

5978

Pass subform name to function or sub

by: DMUM via AccessMonster.com | last post by:

Hello I am trying to pass the name of my subform to a function/sub but I can't seem to get it to work. I am using an autokey function (ctrl E) to unlock text boxes on a subform. I have a few forms in the database that will use this function, so I need to be able to tell the code which form to unlock. What I have is as follows: Public Function akeyEdit()

Microsoft Access / VBA

10397

Screen.Active Identifying Form,SubForm,Control Names

by: ApexData | last post by:

I am using the Shortcut Menu Bar property of many combobox controls to execute a single shared custom function. When the function executes, I need it to immediately identify the following items: MainFormName, SubFormControlName (if this is a subform), and the ComboBox Control Name that launched the event. The following code seems to work, but I have my doubt. I am particulary concerned about the subForm control identity. If the

Microsoft Access / VBA

1243

form-subform question

by: mail12211 | last post by:

I can't figure out how to do create this screen. I think I need to use a form with subForm(but I'm not sure). Could you direct me to an article. Or give me some advice on how this is done. I have an apartment building. And I want to record the (tenant payment) checks I put onto my bank deposit ticket. I have 2 tables 1)

Microsoft Access / VBA

5602

Resize height of subform object in main form

by: Bob Alston | last post by:

I have a system where many subforms are used. Often the size of the subform had to be larger than could be displayed without scrolling. I set the height of the subform to the typical height appropriate for the typical screen resolution they were using. Now some users have decided to use higher screen resolutions, up to 1280/1024. When they maximize the form, that of course works but the size of the main form control containing the...

Microsoft Access / VBA

9589

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

10216

Problem With Comparison Operator <=> in G++

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

C / C++

10049

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

9997

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8873

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7413

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

5310

Trying to create a lan-to-lan vpn between two differents networks

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

Networking - Hardware / Configuration

3965

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

2815

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