-
WSsdepriest
AskWoody LoungerOkay, that’s what I figured.
I’ll see if I can generate an SQL string. Thanks.
-
WSsdepriest
AskWoody LoungerHow about in a query?
I’m storing the name of a field in a hidden text box on a form. I want to pass the name of that field to a query. Then that field in the query has criteria. So I want the query to select the field name dynamically based on what is in the hidden text box on the form.
I’ve tried adding this to the field line in a query: [Forms]![Startup]![txtSectionFieldName] but the query returns no results. How do I do this?
-
WSsdepriest
AskWoody LoungerThe values for Field2 would NOT be stored in a table. I would like to generate them some how, like start Value + 1 up to end value.
Would I still use the For…Next loop for Field2?
-
WSsdepriest
AskWoody LoungerThanks for the links to Wendell’s comments.
I’m sure he knows what he’s talking about. I’m the Access support person in our company and so I’m wondering if we should stop our conversion efforts based on Wendell’s comments. I suppose I’ll have to check the other Access forums out and see if there are further complaints about the updated file format. I have noticed that after conversion to 2k3 that the file size is slightly larger than the same db in 2k format. So you and Wendell think that this increase in bloat causes a stability & corruption problem?
-
WSsdepriest
AskWoody LoungerMost of our DB’s are in the Access 2000 format, but by powers greater than me, it has been deemed to convert them all to the newest file format. (We upgraded from Office 2k to Office 2k3 this spring.)
I’m aware of the fact that Access 2000 users won’t be able to open the Access 2k3 files and so are my managers. But our company is all using Access 2003, and since we have the ability to “dumb” down the MDB files, they don’t see that as a reason not to convert.
Why do you say that the Access 2k format is smaller and more stable? I haven’t heard that claim before.
I’ll check out that KB article in the meantime.
-
WSsdepriest
AskWoody LoungerThat worked. Thanks.
-
WSsdepriest
AskWoody LoungerRory,
Thanks, that worked. The message box does appear before the SQL server error. Thanks. Yes, it did return an error number of 3146, which is the ODBC call failed error.Just have to realize that the same message box will appear for other causes of the error 3146. So have to word the message box appropriately.
Thanks again.
-
WSsdepriest
AskWoody LoungerCorrection!
I removed the “On Error GoTo ODBCErrorHandler” part and the exit sub part as well. And now the error number was written to the debug window.
But… It just returns the VBA Error of 0.
So I don’t think that helps me any…
-
WSsdepriest
AskWoody LoungerYes, I tried that too. No luck. Doesn’t seem to get to that event before the SQL server error appears. This is the code I’ve used, modified for my situation.
Private Sub Form_Error(DataErr As Integer, Response As Integer)
On Error GoTo ODBCErrorHandlerExit_Sub:
Exit SubODBCErrorHandler:
Dim errX As DAO.ErrorIf Errors.Count > 1 Then
For Each errX In DAO.Errors
Debug.Print “ODBC Error”
Debug.Print errX.Number
Debug.Print errX.Description
Next errX
Else
Debug.Print “VBA Error”
Debug.Print Err.Number
Debug.Print Err.Description
End IfResume Exit_Sub
End Sub -
WSsdepriest
AskWoody LoungerIt sounds like it will work.
But I added the example Error Handler routine to the OnDirty, OnDelete, BeforeDelConfirm events of the form and the SQL server error appears before any of these events happen (or so it seems). Nothing appears in the Immediate Window.
Any suggestions on where else I can put the error trap?
Sarah
-
WSsdepriest
AskWoody LoungerAugust 12, 2005 at 5:48 pm in reply to: Quick way to determine file format of mdb (2003 sp1) #966093Yeah, me either I guess. I thought there might be a hidden, right-click-on-the-mdb way or something, but must not be. Not a big deal.
Thanks.
-
WSsdepriest
AskWoody LoungerAugust 12, 2005 at 2:41 pm in reply to: Quick way to determine file format of mdb (2003 sp1) #966069I was aware of the Convert Database submenu as well, and thanks for the suggestion for the automatic way.
But that is not built into all databases at the moment.
My organization has chosen to convert all MDB’S to the newest file format, Access 2002-2003. So I have instructions for the users on how to do that, but I was looking for a way for them to tell what version the MDB is currently on. So unless there is another way, I’ll just instruct them to check the title bar, or maybe the Convert database sub menu, which ever turns out to be less steps for the users.
Thanks.
-
WSsdepriest
AskWoody LoungerAugust 8, 2005 at 7:14 pm in reply to: Way to force reminders on top of other apps? (2003 SP1) #965304You must have Windows XP.
My organization is still on Windows 2000, and so we don’t have that group feature in the task bar. When I have a reminder, it always pops on top, no matter what app has the focus. The taskbar flashes, even if I have the task bar on auto-hide it will pop up and flash.
Maybe I’ll have her run the /cleanreminders switch to see if that fixes anything.
-
WSsdepriest
AskWoody LoungerAugust 8, 2005 at 12:01 pm in reply to: Outlook Today Customization won’t stay, icons (2003 SP1) #965164Thanks for responding, jscher2000.
No we don’t have roaming profiles in my organization. As for a PST file, the user’s OUtlook profile is attached to her Exchange mailbox, not a PST. I did create a profile based on a new, Outlook 2k3 PST file, but that didn’t cause Outlook Today to look funny. Maybe I’ll have the user try it herself, since Outlook Today is messed up on hers.
Maybe she has an old 2000-PST in her folder list that could be causing something funny. I’ll contact her and find out.
In the mean time, has anyone else seen this or can recreate it? Thanks.
-
WSsdepriest
AskWoody LoungerOh you are so smart.
That worked. Forgot about that. I take it that’s necessary with crosstabs. I know it isn’t for regular select queries.
Thanks for the help.
![]() |
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
-
CISA warns of hackers targeting critical oil infrastructure
by
Nibbled To Death By Ducks
2 hours, 28 minutes ago -
AI slop
by
Susan Bradley
1 hour, 39 minutes ago -
Chrome : Using AI with Enhanced Protection mode
by
Alex5723
3 hours, 45 minutes ago -
Two blank icons
by
CR2
10 hours, 14 minutes ago -
Documents, Pictures, Desktop on OneDrive in Windows 11
by
ThePhoenix
12 hours, 39 minutes ago -
End of 10
by
Alex5723
15 hours, 19 minutes ago -
End Of 10 : Move to Linux
by
Alex5723
15 hours, 48 minutes ago -
Single account cannot access printer’s automatic duplex functionality
by
Bruce
12 hours, 17 minutes ago -
test post
by
gtd12345
21 hours, 20 minutes ago -
Privacy and the Real ID
by
Susan Bradley
11 hours, 27 minutes ago -
MS-DEFCON 2: Deferring that upgrade
by
Susan Bradley
3 hours, 34 minutes ago -
Cant log on to oldergeeks.Com
by
WSJonharnew
1 day, 1 hour ago -
Upgrading from Win 10
by
WSjcgc50
3 hours, 3 minutes ago -
USB webcam / microphone missing after KB5050009 update
by
WSlloydkuhnle
20 hours, 47 minutes ago -
TeleMessage, a modified Signal clone used by US government has been hacked
by
Alex5723
1 day, 17 hours ago -
The story of Windows Longhorn
by
Cybertooth
1 day, 5 hours ago -
Red x next to folder on OneDrive iPadOS
by
dmt_3904
1 day, 19 hours ago -
Are manuals extinct?
by
Susan Bradley
6 hours, 47 minutes ago -
Canonical ditching Sudo for Rust Sudo -rs starting with Ubuntu
by
Alex5723
2 days, 4 hours ago -
Network Issue
by
Casey H
1 day, 15 hours ago -
Fedora Linux is now an official WSL distro
by
Alex5723
2 days, 16 hours ago -
May 2025 Office non-Security updates
by
PKCano
2 days, 16 hours ago -
Windows 10 filehistory including onedrive folder
by
Steve Bondy
2 days, 18 hours ago -
pages print on restart (Win 11 23H2)
by
cyraxote
1 day, 19 hours ago -
Windows 11 Insider Preview build 26200.5581 released to DEV
by
joep517
2 days, 21 hours ago -
Windows 11 Insider Preview build 26120.3950 (24H2) released to BETA
by
joep517
2 days, 21 hours ago -
Proton to drop prices after ruling against “Apple tax”
by
Cybertooth
3 days, 4 hours ago -
24H2 Installer – don’t see Option for non destructive install
by
JP
1 day, 20 hours ago -
Asking Again here (New User and Fast change only backups)
by
thymej
3 days, 15 hours ago -
How much I spent on the Mac mini
by
Will Fastie
23 hours, 9 minutes 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.