-
WSsteve_skelton13
AskWoody Loungerthanks – will give it a try.
-
WSsteve_skelton13
AskWoody Loungerwe went with this one-liner:
ActiveSheet.ChartObjects.Delete
as there’s no need to know how many charts are to be deleted, just delete.
-
WSsteve_skelton13
AskWoody Loungerthanks – that should probably do it.
-
WSsteve_skelton13
AskWoody LoungerSorry – I didn’t mean to embarass you – we’ve all done things like that. (I was trying to find something in a database a couple of hours ago and discovered I was in the database for another state.
) And the choice of data type is useful to folks. Thanks for filling in the gaps.
no problem. and, yes, a little embarrassing… I am happy with the fact that Nvarchar(3500) is sufficient rather than Varchar(MAX) or something like that.
-
WSsteve_skelton13
AskWoody LoungerSince developers need to do this fairly regularly with SQL Server tables, what was the solution? (I’ve done it previously with no issues in Access 2000/2002/2003 and SQL Server 2000, but haven’t had a need to recently.)
The solution was, ‘remember to do your testing with the correct db.’ i was erroneously changing the column type in development and testing with a linked table on production… sheesh! anyhow, if you change the type to Varchar(MAX) or NVarchar(3500) in SQL Server, the linked table does display the type as ‘Memo’.
-
WSsteve_skelton13
AskWoody Loungerbasically the issue i am working is, to load a datable with default data or with edited data. once that’s done, the UI needs to display whichever set was loaded. since i use prefixes to define default data and edited data, when i try to assign controls to the data, if the prefix is for edit data, the system bombs. i thought to dynamically rename the column names but a better suggestion came up, which is to use the column number instead. so, no issue!
Thanks anyway
-
WSsteve_skelton13
AskWoody LoungerProblem solved – issue no longer relevant. Thanks!
I want to link to tables in another Access database – thanks!
-
WSsteve_skelton13
AskWoody Loungerlooks about right… thanks!
-
WSsteve_skelton13
AskWoody Loungerlooks about right… thanks!
-
WSsteve_skelton13
AskWoody Loungerlooks about right… thanks!
-
WSsteve_skelton13
AskWoody Loungerlooks about right… thanks!
-
WSsteve_skelton13
AskWoody Loungerlooks about right… thanks!
-
WSsteve_skelton13
AskWoody Loungerlooks about right… thanks!
-
WSsteve_skelton13
AskWoody Loungerlooks about right… thanks!
-
WSsteve_skelton13
AskWoody Loungerlooks about right… thanks!
![]() |
There are isolated problems with current patches, but they are well-known and documented on this site. |
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
-
OneDrive File Sharing Changes
by
David Clark
54 minutes ago -
Win 10 Pro 22H2 to Win 11 Pro 23H2 Conversion Guide
by
doneager
7 minutes ago -
Today is world backup day
by
Alex5723
3 hours, 46 minutes ago -
Windows .exe on Mint
by
Slowpoke47
2 hours, 5 minutes ago -
Reviewing your licensing options
by
Susan Bradley
11 minutes ago -
Apple has been analyzing your photos since September 2024
by
B. Livingston
3 minutes ago -
What Windows 11 24H2 offers beyond bugs
by
Lance Whitney
1 hour, 18 minutes ago -
Making sense of Settings in Windows 11
by
Simon Bisson
5 hours, 57 minutes ago -
Windows 11 pro fails to log in after upgrading Win 10 pro to Win 11 pro 24h2
by
ben_sitaud
3 hours, 20 minutes ago -
23H2 / 24H2 / Local v. Microsoft Account.
by
CWBillow
16 hours, 50 minutes ago -
YouTube Ad Blocker Blocker
by
bbearren
6 hours, 14 minutes ago -
Obscure historical facts about Windows
by
Cybertooth
3 hours, 23 minutes ago -
Microsoft Backup
by
Linda2019
13 hours, 35 minutes ago -
What is the best notepad++ version for W7?
by
Picky
23 hours, 45 minutes ago -
What are right steps to move MS 365 Office+OneDrive files from PC to iMac?
by
glnz
1 day, 6 hours ago -
How to move existing MS 365 Office with OneDrive files from PC to new iMac
by
glnz
1 day, 6 hours ago -
How to move MS 365 files (some on OneDrive) from PC to iMac
by
glnz
2 days, 1 hour ago -
Microsoft adding Quick Machine Recovery to Windows 11
by
Alex5723
2 days, 2 hours ago -
Microsoft vs Passwords
by
Alex5723
1 day, 10 hours ago -
Windows 11 Insider Preview build 26200.5516 released to DEV
by
joep517
2 days, 5 hours ago -
Windows 11 Insider Preview build 26120.3653 (24H2) released to BETA
by
joep517
2 days, 5 hours ago -
Two March KB5053606 updates?
by
Adam
1 day, 23 hours ago -
MS Edge Not Updating to v134.0.3124.95 (rel. 27-Mar-2025)
by
lmacri
1 day, 23 hours ago -
Intel® Graphics/Sound Driver updates for 7th-10th Gen Intel® Core™ Processor
by
Alex5723
2 days, 2 hours ago -
Is there a comprehensve way to tranfer ALL current Edge Settings into a new Edge
by
Tex265
2 days ago -
Transferring ALL info/settings from current Firefox to new computer Firefox
by
Tex265
2 days ago -
DOGE Wants to Replace SSA 60 Million Line COBOL Codebase in Months
by
EyesOnWindows
1 hour, 2 minutes ago -
KB5051989 Usb printer Post Ipp
by
licencesti
2 days, 17 hours ago -
Removing bypassnro
by
Susan Bradley
19 minutes ago -
Up to 30 seconds to show “Recent Topics”
by
PL1
1 day, 22 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.