-
WSladygnome
AskWoody LoungerHello Drew, fellow Dallasite
I haven’t seen your name for a while. Okay – change the left positions. And you would do that by —— ? Remember who your dealing with here. This is my first actual VBA course that I’m taking. -
WSladygnome
AskWoody LoungerIt’s off! It’s off. The Me.FormFooter.BackColor = was exactly what I was missing. I would blow you a kiss, but I can’t find that smiley.
Thank you so much! ( I had found the RGB function, but it didn’t work without the other.) -
WSladygnome
AskWoody LoungerIt’s off! It’s off. The Me.FormFooter.BackColor = was exactly what I was missing. I would blow you a kiss, but I can’t find that smiley.
Thank you so much! ( I had found the RGB function, but it didn’t work without the other.) -
WSladygnome
AskWoody LoungerThank you Hans, that little piece of info just saved me time and frustration.
You are appreciated.Okay – one big question. Is it even POSSIBLE to change the color of the Form Footer based on the position of the mouse when the Mouse Down event occurs?
If so – would you feel comfortable giving me a hint where to start looking? -
WSladygnome
AskWoody LoungerThank you Hans, that little piece of info just saved me time and frustration.
You are appreciated.Okay – one big question. Is it even POSSIBLE to change the color of the Form Footer based on the position of the mouse when the Mouse Down event occurs?
If so – would you feel comfortable giving me a hint where to start looking? -
WSladygnome
AskWoody LoungerI couldn’t agree with you more. My biggest problem is I usually can’t find what I need in Help, or on a Search Engine. I usually do find out later that it was there all along.
-
WSladygnome
AskWoody LoungerI couldn’t agree with you more. My biggest problem is I usually can’t find what I need in Help, or on a Search Engine. I usually do find out later that it was there all along.
-
WSladygnome
AskWoody LoungerThank you Charlotte,
This will at least get me started. -
WSladygnome
AskWoody LoungerThank you Charlotte,
This will at least get me started. -
WSladygnome
AskWoody LoungerNow that I’ve calmed down – just a bit, the problem isn’t the search engine. It’s me. I really don’t know what to ask for.
One thing you generous folks might be able to help with, without damaging anyones ethics, is a list of the integers that correspond to colors.
I’m really not joking. In the five chapters I’ve read in the last two days, there is not one word that relates to the assigned exercise. -
WSladygnome
AskWoody LoungerNow that I’ve calmed down – just a bit, the problem isn’t the search engine. It’s me. I really don’t know what to ask for.
One thing you generous folks might be able to help with, without damaging anyones ethics, is a list of the integers that correspond to colors.
I’m really not joking. In the five chapters I’ve read in the last two days, there is not one word that relates to the assigned exercise. -
WSladygnome
AskWoody LoungerSELECT SubBalances.[Account Number], master.[account-expiration], master.[reporting-grant-dept], master.[reporting-grant-type], master.[reporting-grant], Sum(SubBalances.[free-balance-amt]) AS [SumOffree-balance-amt], [PSA Assignment].[DEPT LTR], [PSA Assignment].PSA_I, master.activity
FROM [PSA Assignment] INNER JOIN (SubBalances INNER JOIN master ON SubBalances.[Account Number] = master.[account-nbr]) ON [PSA Assignment].[DEPT LTR] = master.[dept-div]
GROUP BY SubBalances.[Account Number], master.[account-expiration], master.[reporting-grant-dept], master.[reporting-grant-type], master.[reporting-grant], [PSA Assignment].[DEPT LTR], [PSA Assignment].PSA_I, master.activity
HAVING (((SubBalances.[Account Number]) Between “49000” And “49999”) AND ((Sum(SubBalances.[free-balance-amt]))>0) AND ((master.activity)=”1″)) OR (((SubBalances.[Account Number]) Between “59000” And “59999”) AND ((master.activity)=”9″))
ORDER BY SubBalances.[Account Number];This is it. Thanks in advance for your help. Already I think I see a problem, but I will let you confirm or tell me something else.
-
WSladygnome
AskWoody LoungerSELECT SubBalances.[Account Number], master.[account-expiration], master.[reporting-grant-dept], master.[reporting-grant-type], master.[reporting-grant], Sum(SubBalances.[free-balance-amt]) AS [SumOffree-balance-amt], [PSA Assignment].[DEPT LTR], [PSA Assignment].PSA_I, master.activity
FROM [PSA Assignment] INNER JOIN (SubBalances INNER JOIN master ON SubBalances.[Account Number] = master.[account-nbr]) ON [PSA Assignment].[DEPT LTR] = master.[dept-div]
GROUP BY SubBalances.[Account Number], master.[account-expiration], master.[reporting-grant-dept], master.[reporting-grant-type], master.[reporting-grant], [PSA Assignment].[DEPT LTR], [PSA Assignment].PSA_I, master.activity
HAVING (((SubBalances.[Account Number]) Between “49000” And “49999”) AND ((Sum(SubBalances.[free-balance-amt]))>0) AND ((master.activity)=”1″)) OR (((SubBalances.[Account Number]) Between “59000” And “59999”) AND ((master.activity)=”9″))
ORDER BY SubBalances.[Account Number];This is it. Thanks in advance for your help. Already I think I see a problem, but I will let you confirm or tell me something else.
-
WSladygnome
AskWoody LoungerThanks Hans – See what trouble you cause yourself when you only THINK you know what you are doing. For the time being, Lookup fields remain a mystery. But I’m mailing out my report today. Thanks again.
-
WSladygnome
AskWoody LoungerThanks Hans – See what trouble you cause yourself when you only THINK you know what you are doing. For the time being, Lookup fields remain a mystery. But I’m mailing out my report today. Thanks again.
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Microsoft : Resolving Blue Screen errors in Windows
by
Alex5723
1 hour, 55 minutes ago -
Where’s the cache today?
by
Up2you2
17 hours, 15 minutes ago -
Ascension says recent data breach affects over 430,000 patients
by
Nibbled To Death By Ducks
10 hours, 1 minute ago -
Nintendo Switch 2 has a remote killing switch
by
Alex5723
59 minutes ago -
Blocking Search (on task bar) from going to web
by
HenryW
17 hours, 56 minutes ago -
Windows 10: Microsoft 365 Apps will be supported up to Oct. 10 2028
by
Alex5723
1 day, 10 hours ago -
Add or Remove “Ask Copilot” Context Menu in Windows 11 and 10
by
Alex5723
1 day, 10 hours ago -
regarding april update and may update
by
heybengbeng
1 day, 12 hours ago -
MS Passkey
by
pmruzicka
14 hours, 1 minute ago -
Can’t make Opera my default browser
by
bmeacham
1 day, 19 hours ago -
*Some settings are managed by your organization
by
rlowe44
1 day, 6 hours ago -
Formatting of “Forward”ed e-mails
by
Scott Mills
1 day, 18 hours ago -
SmartSwitch PC Updates will only be supported through the MS Store Going Forward
by
PL1
2 days, 14 hours ago -
CISA warns of hackers targeting critical oil infrastructure
by
Nibbled To Death By Ducks
2 days, 23 hours ago -
AI slop
by
Susan Bradley
17 hours, 17 minutes ago -
Chrome : Using AI with Enhanced Protection mode
by
Alex5723
3 days ago -
Two blank icons
by
CR2
8 hours, 49 minutes ago -
Documents, Pictures, Desktop on OneDrive in Windows 11
by
ThePhoenix
10 hours, 47 minutes ago -
End of 10
by
Alex5723
3 days, 12 hours ago -
Single account cannot access printer’s automatic duplex functionality
by
Bruce
2 days, 10 hours ago -
test post
by
gtd12345
3 days, 18 hours ago -
Privacy and the Real ID
by
Susan Bradley
3 days, 8 hours ago -
MS-DEFCON 2: Deferring that upgrade
by
Susan Bradley
1 day, 10 hours ago -
Cant log on to oldergeeks.Com
by
WSJonharnew
3 days, 22 hours ago -
Upgrading from Win 10
by
WSjcgc50
2 days, 10 hours ago -
USB webcam / microphone missing after KB5050009 update
by
WSlloydkuhnle
2 days, 13 hours ago -
TeleMessage, a modified Signal clone used by US government has been hacked
by
Alex5723
4 days, 14 hours ago -
The story of Windows Longhorn
by
Cybertooth
4 days, 1 hour ago -
Red x next to folder on OneDrive iPadOS
by
dmt_3904
4 days, 16 hours ago -
Are manuals extinct?
by
Susan Bradley
1 day, 16 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.