-
WSJimDettman
AskWoody LoungerThat should work fine as long as both are Date/Time fields, which their not. Check the data types your using.
Jim.
-
WSJimDettman
AskWoody LoungerIf you unwilling/cannot change the design, then fixing up the data is the only solution. Write an update query to look for the extra character:
=”SSB_BCP_”
and update to:
“SSB_BCP”
Of course that does nothing for fixing the problem itself as it can easily happen again.
Jim.
-
WSJimDettman
AskWoody LoungerSo if I understand correctly, your saying this is a input error?
You should be validating the broker code at time of input rather then trying to fix the problem of a incorrect code later on.
Jim.
-
WSJimDettman
AskWoody LoungerODE – Office Developers Edition – You only need it if the folks your distributing to don’t already have a copy of Access installed.
Jim.
-
WSJimDettman
AskWoody LoungerThe limit for the number of fields in a table or query is 255. The limit for the number of controls on a form is 754.
As Mark said, you need to rethink what your doing.
Jim.
-
WSJimDettman
AskWoody LoungerIt’s not clear from you question if your remote users already have Access installed or not. You only need the ODE if the users your distributing to don’t already have Access installed. Otherwise, they just need a copy of the MDB file and any supporting files.
Jim.
-
WSJimDettman
AskWoody LoungerAugust 2, 2001 at 12:13 pm in reply to: “Couldn’t save; currently locked by user ‘Admin'” (97 SR 1) #535633First, you should update to SR2 anyway just because of bug fixes. But if you want to avoid that I think you can because you probably won’t need to run JETCOMP as long as the regular one works.
Instead do this:
1. Create a fresh MDB container and import everything into it. This will (in most cases) eliminate any database corruption.
2. Before opening, delete any .LDB files in that database directory. Typically, when someone disconnects abnormally, you’ll end up with an entry in the .LDB file giving you a phantom user. Deleting it will clear this up.
3. Check the client PC’s were this is happening. Ensure that the TEMP and TMP environment variables point to a valid drive/directory and it has plenty of free disk space. This addresses the “out of memory” error, which may be the main cause of your problem.
4. If the MDB is on a Novell Server, you may need to adjust the locks up or use the dbEngines SetOption method to set the max locks that JET can use below the setting in Novell. “Out of memory” occurs for a number of reasons other then being out of memory. This is one of them.
HTH,
Jim. -
WSJimDettman
AskWoody LoungerThere are quite a few MSKB articles on pulling data into Access from Outlook as well as updating Outlook data from Access.
Go to MSFT’s web site and do a search in the KB for product Access and keyword Outlook.
Jim.
-
WSJimDettman
AskWoody LoungerAugust 1, 2001 at 1:47 pm in reply to: Error, because a field has no value (Access 2002 (Access Data Project)) #535474Just an FYI. The substitution argument is optional unless used in a query, so Mark’s code would have worked.
Jim.
-
WSJimDettman
AskWoody LoungerAugust 1, 2001 at 1:45 pm in reply to: Error, because a field has no value (Access 2002 (Access Data Project)) #535473For subforms with no records, you need to use something other then NZ() (Null to Zero). That’s because a subform/subreport with no records returns an error. So there are two ways to handle it:
=IIF(IsError(NZ( Me!ControlA,0) + NZ( Me!ControlB,0) ,0,NZ( Me!ControlA,0) + NZ( Me!ControlB,0) )
or the method I perfer:
=AvoidError(Me!ControlA + Me!ControlB)
AvoidError being the following function that you paste into a module:
Function AvoidError(n As Variant)
On Error GoTo Trap
AvoidError = n
Exit FunctionTrap:
AvoidError = 0
Resume Next
End FunctionNote that you can modify AvoidError to check for Null as well if you wish and return a 0.
Jim.
-
WSJimDettman
AskWoody LoungerOh no….the really tough sell.
Jim.
-
WSJimDettman
AskWoody LoungerFairly difficult. I can think of two ways to do it, neither very attractive and I probably can come up with a few more.
Try and talk the client out of it. You’d be doing them a favor. The report will waste paper (ie. Nurse1 has more patients that 2 or 3 leaving lots of white space) and be more difficult to read. Also, if additional info is required in the future, it would be difficult to modify the format.
They really need to avoid taking the “spreadsheet” approach to report design. The two don’t mix.
Jim.
-
WSJimDettman
AskWoody LoungerYes it’s doable, but a very difficult report to format and one that’s not very flexable as the the horizontal space limits the number of nurses that can appear on the report.
You’d need to fill in a few more details before I would suggest a method for doing this. For example, is this a horizontal snaking format? i.e.
Nurse1 Nurse2 Nurse3
Patient Patient Patient
Patient Patient PatientNurse4 Nurse5 Nurse6
Patient Patient Patient
Patient Patient PatientNurse7 Nurse8 Nurse9
Patient Patient Patient
Patient Patient PatientBut the real question is, why would you want to. Your fighting natural report design all the way. If you outline what your trying to accomplish, there my be a better approach that someone could suggest.
Jim.
-
WSJimDettman
AskWoody LoungerThe correct way is:
NextRecord = True
PrintSection = False
MoveLayout = FalseJim.
-
WSJimDettman
AskWoody LoungerBob,
I would not put a duplicate check on the name, but instead on the phone number.
If that is not workable, then you’ll need to add more info to the student table to prevent duplicates or you may find that you cannot prevent them and will need the human touch to keep them from happening (ie. display a list of sudents when a name is keyed in and allow the user to pick one). It really all boils down to how do you really identify a student?
Jim.
![]() |
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
-
Updating Keepass2Androis
by
CBFPD-Chief115
9 minutes ago -
Outdated Laptop (Awaiting moderation)
by
jdamkeene
12 minutes ago -
Another big Microsoft layoff
by
Charlie
29 minutes ago -
PowerShell to detect NPU – Testers Needed
by
RetiredGeek
10 minutes ago -
May 2025 updates are out
by
Susan Bradley
2 hours, 7 minutes ago -
Windows 11 Insider Preview build 26200.5600 released to DEV
by
joep517
5 hours, 13 minutes ago -
Windows 11 Insider Preview build 26120.3964 (24H2) released to BETA
by
joep517
5 hours, 15 minutes ago -
Drivers suggested via Windows Update
by
Tex265
5 hours, 6 minutes ago -
Thunderbird release notes for 128 esr have disappeared
by
EricB
2 hours, 50 minutes ago -
CISA mutes own website, shifts routine cyber alerts to X, RSS, email
by
Nibbled To Death By Ducks
12 hours, 6 minutes ago -
Apple releases 18.5
by
Susan Bradley
6 hours, 31 minutes ago -
Fedora Linux 40 will go end of life for updates and support on 2025-05-13.
by
Alex5723
13 hours, 32 minutes ago -
How a new type of AI is helping police skirt facial recognition bans
by
Alex5723
14 hours, 9 minutes ago -
Windows 7 ISO /Windows 10 ISO
by
ECWS
3 hours, 1 minute ago -
No HP software folders
by
fpefpe
21 hours, 50 minutes ago -
Which antivirus apps and VPNs are the most secure in 2025?
by
B. Livingston
1 hour, 14 minutes ago -
Stay connected anywhere
by
Peter Deegan
1 day, 3 hours ago -
Copilot, under the table
by
Will Fastie
18 hours, 26 minutes ago -
The Windows experience
by
Will Fastie
1 day, 9 hours ago -
A tale of two operating systems
by
Susan Bradley
1 day ago -
Microsoft : Resolving Blue Screen errors in Windows
by
Alex5723
1 day, 14 hours ago -
Where’s the cache today?
by
Up2you2
2 days, 6 hours ago -
Ascension says recent data breach affects over 430,000 patients
by
Nibbled To Death By Ducks
1 day, 22 hours ago -
Nintendo Switch 2 has a remote killing switch
by
Alex5723
23 hours, 13 minutes ago -
Blocking Search (on task bar) from going to web
by
HenryW
1 hour, 27 minutes ago -
Windows 10: Microsoft 365 Apps will be supported up to Oct. 10 2028
by
Alex5723
2 days, 23 hours ago -
Add or Remove “Ask Copilot” Context Menu in Windows 11 and 10
by
Alex5723
2 days, 23 hours ago -
regarding april update and may update
by
heybengbeng
3 days ago -
MS Passkey
by
pmruzicka
2 days, 2 hours ago -
Can’t make Opera my default browser
by
bmeacham
3 days, 8 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.