-
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.
![]() |
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
-
Office gets current release
by
Susan Bradley
38 minutes ago -
FBI: Still Using One of These Old Routers? It’s Vulnerable to Hackers
by
Alex5723
6 hours ago -
Windows AI Local Only no NPU required!
by
RetiredGeek
2 hours, 44 minutes ago -
Stop the OneDrive defaults
by
CWBillow
6 hours, 49 minutes ago -
Windows 11 Insider Preview build 27868 released to Canary
by
joep517
16 hours, 45 minutes ago -
X Suspends Encrypted DMs
by
Alex5723
18 hours, 57 minutes ago -
WSJ : My Robot and Me AI generated movie
by
Alex5723
19 hours, 14 minutes ago -
Botnet hacks 9,000+ ASUS routers to add persistent SSH backdoor
by
Alex5723
19 hours, 52 minutes ago -
OpenAI model sabotages shutdown code
by
Cybertooth
20 hours, 29 minutes ago -
Backup and access old e-mails after company e-mail address is terminated
by
M W Leijendekker
8 hours, 38 minutes ago -
Enabling Secureboot
by
ITguy
15 hours, 38 minutes ago -
Windows hosting exposes additional bugs
by
Susan Bradley
1 day, 4 hours ago -
No more rounded corners??
by
CWBillow
1 day ago -
Android 15 and IPV6
by
Win7and10
13 hours, 57 minutes ago -
KB5058405 might fail to install with recovery error 0xc0000098 in ACPI.sys
by
Susan Bradley
1 day, 16 hours ago -
T-Mobile’s T-Life App has a “Screen Recording Tool” Turned on
by
Alex5723
1 day, 19 hours ago -
Windows 11 Insider Preview Build 26100.4202 (24H2) released to Release Preview
by
joep517
1 day, 14 hours ago -
Windows Update orchestration platform to update all software
by
Alex5723
2 days, 2 hours ago -
May preview updates
by
Susan Bradley
1 day, 14 hours ago -
Microsoft releases KB5061977 Windows 11 24H2, Server 2025 emergency out of band
by
Alex5723
1 day, 5 hours ago -
Just got this pop-up page while browsing
by
Alex5723
1 day, 18 hours ago -
KB5058379 / KB 5061768 Failures
by
crown
1 day, 16 hours ago -
Windows 10 23H2 Good to Update to ?
by
jkitc
18 hours, 12 minutes ago -
At last – installation of 24H2
by
Botswana12
2 days, 18 hours ago -
MS-DEFCON 4: As good as it gets
by
Susan Bradley
14 hours, 58 minutes ago -
RyTuneX optimize Windows 10/11 tool
by
Alex5723
3 days, 6 hours ago -
Can I just update from Win11 22H2 to 23H2?
by
Dave Easley
1 day, 4 hours ago -
Limited account permission error related to Windows Update
by
gtd12345
3 days, 19 hours ago -
Another test post
by
gtd12345
3 days, 20 hours ago -
Connect to someone else computer
by
wadeer
3 days, 14 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.