-
WSpbrodsky
AskWoody LoungerHave you considered using Excel as the interface with VBA programming to retrieve the data from Access tables and more code to update the tables. It seems too complex for your needs, but would let you keep your current interface.
-
WSpbrodsky
AskWoody LoungerHave you considered using Excel as the interface with VBA programming to retrieve the data from Access tables and more code to update the tables. It seems too complex for your needs, but would let you keep your current interface.
-
WSpbrodsky
AskWoody LoungerNot just data integrity, but if you are writing an application for other people to use, Access gives much more control to ensure that the users don’t do things they shouldn’t. Excel is a much more flexible, but much more open environment – it is difficult to constrain users so that they only do what you expect them to, and much easier for users to mess up an application. On the other hand, knowledgeable users can more easily modify an Excel database for their own purposes..
-
WSpbrodsky
AskWoody LoungerNot just data integrity, but if you are writing an application for other people to use, Access gives much more control to ensure that the users don’t do things they shouldn’t. Excel is a much more flexible, but much more open environment – it is difficult to constrain users so that they only do what you expect them to, and much easier for users to mess up an application. On the other hand, knowledgeable users can more easily modify an Excel database for their own purposes..
-
WSpbrodsky
AskWoody LoungerAlt-Enter puts a ‘hard carriage return’ in a cell (its in the Help file under ‘entering text’
-
WSpbrodsky
AskWoody LoungerYou can open the Excel file in Word and get a Word table of the contents
-
WSpbrodsky
AskWoody LoungerAn easier way to do this would be to use FormulaR1C1
eg. ActiveCell.FormulaR1C1 = Range(“d10”).FormulaR1C1 -
WSpbrodsky
AskWoody LoungerJust a thought.
From the samples you included earlier, it looks as though Excel may not be the ideal application for this. If the document is just formatted text, you might look at Word, or, if you are using lookups in Excel, you might find Access reports a better solution. In either case, it should not be too much work to move things from Excel.
-
WSpbrodsky
AskWoody LoungerI like Adobe Photoshop Elements and Ulead PhotoImpact. Either is under $100 (US).
-
WSpbrodsky
AskWoody LoungerI had this situation once when it turned out to be a bad printer cable.
-
WSpbrodsky
AskWoody LoungerI ran into this error message recently. I fixed it without really tracking it down, but it looked as though Access changed the syntax for referring to a control on a subform between 97 and 2000.
-
WSpbrodsky
AskWoody LoungerI found (I don’t remember where) the following code to delete unused pivot items. It appears to work.
Sub deloldpivotitems()
Set oPiv = ActiveSheet.PivotTables(1)For Each oField In oPiv.PivotFields
If oField.Name “Data” Then
For Each oItem In oField.PivotItems
If oItem.RecordCount = 0 And Not oItem.IsCalculated Then oItem.Delete
Next
End If
NextEnd Sub
![]() |
Patch reliability is unclear, but widespread attacks make patching prudent. Go ahead and patch, but watch out for potential problems. |
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
-
How to use Skype after May? (Awaiting moderation)
by
Joann
32 minutes ago -
Win 7 MS Essentials suddenly not showing number of items scanned.
by
Oldtimer
2 hours, 1 minute ago -
France : A law requiring messaging apps to implement a backdoor ..
by
Alex5723
6 hours, 52 minutes ago -
Dev runs Windows 11 ARM on an iPad Air M2
by
Alex5723
7 hours, 41 minutes ago -
MS-DEFCON 3: Cleanup time
by
Susan Bradley
2 hours, 41 minutes ago -
KB5056686 (.NET v8.0.15) Delivered Twice in April 2025
by
lmacri
3 hours, 6 minutes ago -
How to enable Extended Security Maintenance on Ubuntu 20.04 LTS before it dies
by
Alex5723
18 hours, 54 minutes ago -
Windows 11 Insider Preview build 26200.5562 released to DEV
by
joep517
22 hours, 53 minutes ago -
Windows 11 Insider Preview build 26120.3872 (24H2) released to BETA
by
joep517
22 hours, 54 minutes ago -
Unable to eject external hard drives
by
Robertos42
2 hours, 21 minutes ago -
Saying goodbye to not-so-great technology
by
Susan Bradley
6 hours, 46 minutes ago -
Tech I don’t miss, and some I do
by
Will Fastie
3 hours, 58 minutes ago -
Synology limits hard drives
by
Susan Bradley
2 days, 3 hours ago -
Links from Microsoft 365 and from WhatsApp not working
by
rog7
1 day, 5 hours ago -
WhatsApp Security Advisories CVE-2025-30401
by
Alex5723
2 days, 9 hours ago -
Upgrade Sequence
by
doneager
2 days, 2 hours ago -
Chrome extensions with 6 million installs have hidden tracking code
by
Nibbled To Death By Ducks
8 hours, 6 minutes ago -
Uninstall “New Outlook” before installing 2024 Home & Business?
by
Tex265
1 day, 1 hour ago -
The incredible shrinking desktop icons
by
Thumper
3 days, 6 hours ago -
Windows 11 Insider Preview Build 22635.520 (23H2) released to BETA
by
joep517
3 days, 7 hours ago -
Connecting hard drive on USB 3.2 freezes File Explorer & Disk Management
by
WSJMGatehouse
6 hours, 51 minutes ago -
Shellbag Analyser & Cleaner Update
by
Microfix
21 minutes ago -
CISA warns of increased breach risks following Oracle Cloud leak
by
Nibbled To Death By Ducks
3 days, 17 hours ago -
Outlook 2024 two sent from email addresses
by
Kathy Stevens
2 days, 21 hours ago -
Speeding up 11’s search
by
Susan Bradley
1 day, 5 hours ago -
HP Pavilion Will Not Wake Up After Being Idle for Longer Period
by
WSwalterwood44
1 day, 17 hours ago -
Make a Windows 11 Local Account Passwordless
by
Drcard:))
4 days, 7 hours ago -
Ubuntu 25.04 (Plucky Puffin)
by
Alex5723
4 days, 14 hours ago -
24H2 fixed??
by
CWBillow
3 days, 7 hours ago -
Uninstalr Updates
by
jv16
4 days, 19 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.