-
WSJerryC
AskWoody Loungerwhy not make date three invisible until the other two are filled in
if isnull date1 then
date3.visible = falsesomething like that
HTH
JerryC -
WSJerryC
AskWoody Loungersorry the box is to the right of the rowsource not to the left
JerryC
-
WSJerryC
AskWoody Loungergo to the rowsource of the ScaleValues combo box
click on the three dotted box to the left
this will bring up a query builder you can set whatever criteria you want here
HTH
JerryC -
WSJerryC
AskWoody Loungermaybe its just me but i’m not sure what the question is
JerryC -
WSJerryC
AskWoody Loungersorry for not getting back any sooner
the problem wound up being with our IT department they were resetting the macro security on boot up that is why it worked when we wrote the macro but not the next time we tried it
thanks
for all your help
JerryC -
WSJerryC
AskWoody Lounger -
WSJerryC
AskWoody Loungeryou could add a button with code behind it to requery or if any fieds are being updated you colud put code on the after update event for that control
for the code you could try me.requery
that should work
hth
jerryc -
WSJerryC
AskWoody Lounger -
WSJerryC
AskWoody Loungerif you have a field in your form that is unique like an autonumber field set the query criteria of the report to this control of the form.
them you can use a macro or code to open, print and close the report if you want -
WSJerryC
AskWoody Loungerdon,t know if matters but you list the fields as badge id on both tables
in you query you are showing badge id and id(autonumber ?) linked
could this be the problem
JerryC -
WSJerryC
AskWoody Loungerwhere do you go to change the subdatasheet property in the tables
thanks
JerryC -
WSJerryC
AskWoody LoungerThanks Gary
I’ll give it a try as soon as I can
thanks again
JerryC -
WSJerryC
AskWoody LoungerIT LOOKS LIKE THE SAVE PART IS WORKING
BUT DOES NOT CLOSE THE APPLICATION
I TRIED USING THE CODE IN ANOTHER PRESENTATION
AND THE CODE WORKED A FEW TIMES AND STOPPED WORKING IN THAT ONE TOO
PLEASE ANY IDEAS WOULD BE GREATLY APPRECIATED
THANKS
JERRYC -
WSJerryC
AskWoody Loungerwhy not simply import the dbase table into your access database
JerryC -
WSJerryC
AskWoody Loungerif you want 97 and 2000 on the same machine try this from the knowledge base
Q241141 – ACC2000: How to Install Access 97 and Access 2000 on the Same Computer
JerryC
![]() |
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
20 minutes ago -
Where’s the cache today?
by
Up2you2
15 hours, 40 minutes ago -
Ascension says recent data breach affects over 430,000 patients
by
Nibbled To Death By Ducks
8 hours, 26 minutes ago -
Nintendo Switch 2 has a remote killing switch
by
Alex5723
10 hours, 11 minutes ago -
Blocking Search (on task bar) from going to web
by
HenryW
16 hours, 21 minutes ago -
Windows 10: Microsoft 365 Apps will be supported up to Oct. 10 2028
by
Alex5723
1 day, 8 hours ago -
Add or Remove “Ask Copilot” Context Menu in Windows 11 and 10
by
Alex5723
1 day, 9 hours ago -
regarding april update and may update
by
heybengbeng
1 day, 10 hours ago -
MS Passkey
by
pmruzicka
12 hours, 26 minutes ago -
Can’t make Opera my default browser
by
bmeacham
1 day, 18 hours ago -
*Some settings are managed by your organization
by
rlowe44
1 day, 4 hours ago -
Formatting of “Forward”ed e-mails
by
Scott Mills
1 day, 17 hours ago -
SmartSwitch PC Updates will only be supported through the MS Store Going Forward
by
PL1
2 days, 12 hours ago -
CISA warns of hackers targeting critical oil infrastructure
by
Nibbled To Death By Ducks
2 days, 21 hours ago -
AI slop
by
Susan Bradley
15 hours, 42 minutes ago -
Chrome : Using AI with Enhanced Protection mode
by
Alex5723
2 days, 23 hours ago -
Two blank icons
by
CR2
7 hours, 14 minutes ago -
Documents, Pictures, Desktop on OneDrive in Windows 11
by
ThePhoenix
9 hours, 12 minutes ago -
End of 10
by
Alex5723
3 days, 10 hours ago -
Single account cannot access printer’s automatic duplex functionality
by
Bruce
2 days, 8 hours ago -
test post
by
gtd12345
3 days, 16 hours ago -
Privacy and the Real ID
by
Susan Bradley
3 days, 6 hours ago -
MS-DEFCON 2: Deferring that upgrade
by
Susan Bradley
1 day, 9 hours ago -
Cant log on to oldergeeks.Com
by
WSJonharnew
3 days, 21 hours ago -
Upgrading from Win 10
by
WSjcgc50
2 days, 8 hours ago -
USB webcam / microphone missing after KB5050009 update
by
WSlloydkuhnle
2 days, 12 hours ago -
TeleMessage, a modified Signal clone used by US government has been hacked
by
Alex5723
4 days, 12 hours ago -
The story of Windows Longhorn
by
Cybertooth
4 days ago -
Red x next to folder on OneDrive iPadOS
by
dmt_3904
4 days, 14 hours ago -
Are manuals extinct?
by
Susan Bradley
1 day, 14 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.