-
WSAlexya1
AskWoody LoungerThanks John! It’s all fixed but I will keep that in mind for the future.
The problem turned out to be registry related. This article explains…
How to Control Whether Access Loads the Borland Data Engine (BDE)
-
WSAlexya1
AskWoody LoungerThanks Hans… Yes, that’s the article I found and gave to the desktop support guy to use. I’ll check the other link you mention. As for the file and path names, the department has about 15 users and all of them are fine with importing the dbf’s as required. The user with the problem is trying to get the same files from the same locations so I don’t think that is the issue.
As always… thanks for all of your advice!
-
WSAlexya1
AskWoody LoungerYou’re right Hans. I am using Automation.
Why does it always seem so simple when you see the solution. I had found the VotingOptions property for the MailItem object but there were no examples anywhere of the statements setting the values. I thought it might have been a True/False thing instead of what I was really looking for. MSDN had “expression.votingoptions” and that was it. I suppose I should have played around more before asking the question.
Thank you Hans! As always, you are the best!
-
WSAlexya1
AskWoody LoungerMarch 10, 2006 at 5:59 pm in reply to: Copying sheet without changing references/formulas (2000 SP3) #1004124Worked perfectly! Thanks! I appreciate the help… I love it when I learn something new…
-
WSAlexya1
AskWoody LoungerTo find out the version of Access that the user is working with, can’t they just open Access itself from the Program Files list and check the Help menu for the “About” information that way?… I mean, that particular database may disable menus but Access itself is free to look at right?
It would be a start… At least you’d know if they needed service packs and that might have something to do with the real problem…
-
WSAlexya1
AskWoody LoungerSet the Column Widths property of the list box…
-
WSAlexya1
AskWoody LoungerThat’s good to know!
I need to learn all the new bugs now!
BUT… I found the problem… Believe it or not, all I had to do was turn off the Popup property of the main form…. Bizarre yes?…I just happened to have read something last night in the help files about form events and that certain events (activate and deactivate I think) didn’t happen when the Popup property is set to Yes… It just came to mind and I had a thought… Maybe the problem has something to do with events?… Maybe something else is being triggered in between the OutputTo statements (something to do with what’s on the screen and not the code itself)??… If it works when I step through it and not when the user runs it from the form, maybeeeee???… It couldn’t hurt to check it out right?
I checked the form properties, see that Popup is Yes, change it to No, save the form, close the whole thing down, re-open the database as a normal user (with limited access) and click the button… It works?!?!?
Have you ever heard of this before? I’ll never understand why it wouldn’t have been a problem in Access 97 and now it is… I seem to find the strangest things sometimes… What’s even more bizarre to me is that I even thought of checking that!
Thanks for all of your help Hans! It’s much appreciated!
-
WSAlexya1
AskWoody LoungerHi Hans!
Sounded like a great idea, but it didn’t fix the problem…
Any other ideas?
-
WSAlexya1
AskWoody LoungerIf I’m understanding you correctly, try using DLookup in the control source for the text box to display the phone number…
For example:
=”Employee Phone Number: ” & DLookUp(“[ YourEmployeeNameField ]”,” YourEmployeeTableName “,”[YourEmployeeNameField ]='” & [Forms]![ YourFormName ]![ YourListboxControlName ] & “‘”)This would display on your report as something like this:
“Employee Phone Number: 555-123-4567”Hope this helps…
_______________________________________________________I have a situation just like this… The report creates posting journals and although the record source for the report itself is a query… However, there is one text box control on the report that changes every time (displaying who the journals are for this time… name and phone number)… The user opens a form first, picks a name from a combo box (tied to another table listing operators) and on the AfterUpdate event of the combobox, I open the report and the text box is populated using something very similar to my example… My text box needs to display something like this: “Operator Name: Jane Doe 2-3456”
-
WSAlexya1
AskWoody LoungerYes, I am using a fixed width output spec that I created and saved… There is no option for selecting the text data type with right alignment though… I figured I should therefore try format it before it got to the output spec (at least worth a try) but I checked help and although there is the format option of using “!” to force left alignment, there doesn’t seem to be any option to force right alignment…
Oh well, no biggie… We can only provide what the tools allow right?
Thanks for trying Charlotte!
-
WSAlexya1
AskWoody LoungerNope… The point is that I don’t want decimals… I want it to be right aligned without leading zeros… Thanks for trying…
-
WSAlexya1
AskWoody LoungerAugust 22, 2005 at 5:22 pm in reply to: Waiting for another OLE action to complete? (Excel 2000, Access 97) #968017Thanks Hans!
Yes, it’s been a while… Surprisingly, I’ve been doing well all by myself…
BUT I always know where to find the experts when I need them…
I’ll give your ideas a try… Thanks again…
-
WSAlexya1
AskWoody LoungerAugust 6, 2004 at 2:01 pm in reply to: Opening workbooks in code with partial name… (2000 SP-3) #860914Works perfectly Hans…
My code was almost identical…
I won’t tell you what I was missing or you’ll lose all respect for me (If you ever had any!)…Thanks for helping me overcome another brain freeze!
-
WSAlexya1
AskWoody LoungerAugust 6, 2004 at 2:01 pm in reply to: Opening workbooks in code with partial name… (2000 SP-3) #860915Works perfectly Hans…
My code was almost identical…
I won’t tell you what I was missing or you’ll lose all respect for me (If you ever had any!)…Thanks for helping me overcome another brain freeze!
-
WSAlexya1
AskWoody LoungerHans…. As usual I have to bow to your supreme knowledge!
Thanks a bunch! I thought it had something to do with the labels being attached but I never would have thought of just cutting and pasting them to break that attachment…. It would have taken me ages to figure out… 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
-
Practice what you preach! A cautionary tale.
by
RetiredGeek
3 hours, 31 minutes ago -
Looking for Microsoft Defender Manuals/Tutorial
by
blueboy714
16 hours, 28 minutes ago -
Win 11 24H2 Home or Pro?
by
CWBillow
2 hours, 48 minutes ago -
Bipartisan Effort to Sunset the ‘26 Words That Created the Internet’..
by
Alex5723
1 day ago -
Outlook new and edge do not load
by
cHJARLES a pECKHAM
1 day, 12 hours ago -
Problem using exfat drives for backup
by
Danmc
1 day, 13 hours ago -
I hate that AI is on every computer we have!
by
1bumthumb
15 hours, 8 minutes ago -
Change Info in the Settings window
by
CWBillow
1 day, 19 hours ago -
Attestation readiness verifier for TPM reliability
by
Alex5723
2 days, 2 hours ago -
Windows Update says that “some settings are managed b your organization”
by
Ed Willers
1 day, 11 hours ago -
Use of Gmail rejected.
by
CBFPD-Chief115
1 day, 12 hours ago -
WuMgr operational questions
by
Tex265
14 hours, 27 minutes ago -
Beijing’s unprecedented half-marathon: Humans vs. humanoids!
by
Alex5723
2 days, 17 hours ago -
New Phishing Campaign Targeted at Mac Users
by
Alex5723
1 day, 18 hours ago -
Backing up Google Calendar
by
CWBillow
3 days ago -
Windows 11 Insider Preview build 27818 released to Canary
by
joep517
3 days, 12 hours ago -
File Naming Conventions (including Folders)
by
Magic66
2 days, 11 hours ago -
Windows 11 Insider Preview Build 26100.3613 (24H2) released to Release Preview
by
joep517
3 days, 20 hours ago -
Microsoft sends emails to Windows 10 users about EOS
by
Alex5723
3 days, 6 hours ago -
Outlook 2024 importing Calendar and Contacts – FAILURE
by
Kathy Stevens
2 days, 12 hours ago -
Adding Microsoft Account.
by
DaveBRenn
3 days, 21 hours ago -
Windows 11 Insider Preview build 26120.3576 released to DEV and BETA
by
joep517
4 days, 20 hours ago -
Windows 11 Insider Preview Build 22635.5090 (23H2) released to BETA
by
joep517
4 days, 21 hours ago -
Windows 11 won’t boot
by
goducks25
2 days, 13 hours ago -
Choosing virtual machine product for Windows on Mac
by
peterb
4 days, 11 hours ago -
Rest in Peace
by
Roy Lasris
5 days, 15 hours ago -
CISA : Install Windows March 2025 Updates until April 1 or shut down PC.
by
Alex5723
2 days, 13 hours ago -
Google proposes users with incompatible Win 11 PCs to migrate to ChromeOS Flex
by
Alex5723
5 days, 16 hours ago -
Drivers for Epson Perfection V600 Photo – scanner
by
Bookman
2 days, 7 hours ago -
Long Time Member
by
jackpet
5 days, 18 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.