-
WSG-Wog
AskWoody LoungerMay 26, 2003 at 5:30 am in reply to: Filter applied that blocks whole recordset (Access 2002) #679774Yes, I had the data entry set to “Yes”. Thanks Hans, that’s fixed the problem.
Really appreciate the speedy responses
-
WSG-Wog
AskWoody LoungerMay 26, 2003 at 5:25 am in reply to: Filter applied that blocks whole recordset (Access 2002) #679772I must have hit save after selecting Records->Filter->filter excluding selection. That explains the bit after AND. The current selection was [ID] = 0 (no record) and it put (Not TblTemplates.ID=0) into the filter property. Still getting the same problem tho no matter how I open the form. With or without a filter applied the form shows a filtered recordset of 1 item until I remove filters using the menu.
Thanks for your assistance Pat
-
WSG-Wog
AskWoody LoungerMay 26, 2003 at 4:41 am in reply to: Filter applied that blocks whole recordset (Access 2002) #679766addendum to above, when I open the form with no filter, remove filters using the records menu to reveal the whole recordset, switch to design view and view the form properties I find the following line in the filters property:
([ID] = 10) AND ((Not TblTemplates.ID=0))
Where did this come from? I was viewing the record with [ID] = 10 but as to the expression right of the AND, I have no idea…
-
WSG-Wog
AskWoody LoungerThanks Charlotte. The dlookup seems a much easier way of doing things. A big whoops on the cleanup of recordsets. I usually remember to set the recordsets to nothing but only because I was told that was the correct thing to do, never why. Now I know…
Once again, thanks for all your help on this.
-
WSG-Wog
AskWoody LoungerThanks Charlotte, I think your right. I don’t even remember adding that field to the table or why.
In a text box on the “Costing Tab” I use the function in an expression. The function cycles through the materials table till it finds the right material and then plugs the on cost value of that material into the expression. Can you suggest a better way of doing this?Thanks again.
-
WSG-Wog
AskWoody LoungerThere is a report designed to print out the form that has 2 functions identical to the ones in the form in its module. I tried changing the names of them and the reference to them but it doesn’t fix the problem. I prefix all Form, Report and module names with Frm, Rpt or Mod so there is no chance of a container object being called “MatOnCost”. I haven’t used any macros at all. I’ve attached a zipped version of the db thats been cut down a bit as Hans suggested.
-
WSG-Wog
AskWoody LoungerI’ve found the conflict but it’s a bit wierd. I compiled the code like Hans and Charlotte suggested and it pointed to the second function “MatOnCost” which is in the forms module. I changed the function name and the references to it to “MatOnCost1” and the problem went away. Suggests there is a control somewhere called “MatOnCost” but I can’t find it. I’ve looked at every text box, label and button but nothing has that name apart from the function. Is there anything else it could be?
Thanks everybody for your help on this. I really appreciate it.
-
WSG-Wog
AskWoody LoungerNope. All the forms procedures are of the form “CmdButtonName_click” except for 2 functions which do not have similar names to controls. I checked all modules and code for all forms in the DB just to be thorough. I tried putting a breakpoint in the OnCurrent event procedure but it doesn’t get to the breakpoint before the popup appears. Is this significant?
-
WSG-Wog
AskWoody LoungerYes, just a few lines to enable or disable a few controls depending on the value of one of the fields in the underlying table to the form:
Private Sub Form_Current()
If Me.SandType = “Chemically Bonded” Then
Me.SandQty.Enabled = True
Me.SandUOM.Enabled = True
Me.TxtSandCost.Enabled = True
Else
Me.SandQty.Enabled = False
Me.SandUOM.Enabled = False
Me.TxtSandCost.Enabled = False
End If
End Sub -
WSG-Wog
AskWoody LoungerThanks Charlie. Sounds like a good solution. I’ll check it out.
Ryan
-
WSG-Wog
AskWoody LoungerThats right. When the router is connected directly to the switch a regular cable is used. However, when the router is connected directly to the server via a second NIC (First NIC connects server to internal network via switch) a crossover cable has to be used just as if I was connecting two computers together with a single cable and no hub. I checked out the KB articles but they refer to Backoffice Small Business Server 4.x not Small Business Server 2000 and relate to MS Proxy Server, not ISA Server which SBS 2000 uses.
I had everything working breifly last night with the router connected to the second NIC and the NIC having the same IP address as the router, but soon afterwards the server threw up an error because of the IP Address conflict between the NIC and the router. -
WSG-Wog
AskWoody LoungerThanks Dan. That sounds exactly what I’m looking for.
-
WSG-Wog
AskWoody LoungerWe are running W2K on nearly all of the workstations with W98SE on 1 or 2 of them. Thanks for your responses. I will check out RealVNC and TightVNC.
Cheers,
Ryan
-
WSG-Wog
AskWoody LoungerThanks Hans, I’ll give it a try.
-
WSG-Wog
AskWoody LoungerRupert is right. You need to pass the date in US format to the query. Try :
strSQL = “Select * fromqryProductionSales Where tdate >= #” & Format(txtStart, “mm/dd/yyyy”) & “# and tdate <=#" & Format(txtEnd, "mm/dd/yyyy") & "#"
Ryan
![]() |
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
-
Asking Again here (New User and Fast change only backups)
by
thymej
2 hours, 14 minutes ago -
How much I spent on the Mac mini
by
Will Fastie
2 hours, 20 minutes ago -
How to get rid of Copilot in Microsoft 365
by
Lance Whitney
2 hours, 12 minutes ago -
Spring cleanup — 2025
by
Deanna McElveen
8 hours, 6 minutes ago -
Setting up Windows 11
by
Susan Bradley
1 hour, 8 minutes ago -
VLC Introduces Cutting-Edge AI Subtitling and Translation Capabilities
by
Alex5723
3 hours, 33 minutes ago -
Powershell version?
by
CWBillow
4 hours, 26 minutes ago -
SendTom Toys
by
CWBillow
14 hours, 50 minutes ago -
Add shortcut to taskbar?
by
CWBillow
8 hours, 22 minutes ago -
Sycophancy in GPT-4o: What happened
by
Alex5723
1 day ago -
How can I install Skype on Windows 7?
by
Help
23 hours, 26 minutes ago -
Logitech MK850 Keyboard issues
by
Rush2112
6 hours, 22 minutes ago -
We live in a simulation
by
Alex5723
1 day, 14 hours ago -
Netplwiz not working
by
RetiredGeek
1 day, 1 hour ago -
Windows 11 24H2 is broadly available
by
Alex5723
2 days, 3 hours ago -
Microsoft is killing Authenticator
by
Alex5723
14 hours, 55 minutes ago -
Downloads folder location
by
CWBillow
2 days, 9 hours ago -
Remove a User from Login screen
by
CWBillow
1 day, 5 hours ago -
TikTok fined €530 million for sending European user data to China
by
Nibbled To Death By Ducks
2 days ago -
Microsoft Speech Recognition Service Error Code 1002
by
stanhutchings
2 days ago -
Is it a bug or is it expected?
by
Susan Bradley
3 hours ago -
Image for Windows TBwinRE image not enough space on target location
by
bobolink
2 days ago -
Start menu jump lists for some apps might not work as expected on Windows 10
by
Susan Bradley
23 hours, 30 minutes ago -
Malicious Go Modules disk-wiping malware
by
Alex5723
2 days, 13 hours ago -
Multiple Partitions?
by
CWBillow
2 days, 14 hours ago -
World Passkey Day 2025
by
Alex5723
10 hours, 33 minutes ago -
Add serial device in Windows 11
by
Theodore Dawson
3 days, 22 hours ago -
Windows 11 users reportedly losing data due forced BitLocker encryption
by
Alex5723
1 day, 23 hours ago -
Cached credentials is not a new bug
by
Susan Bradley
4 days, 3 hours ago -
Win11 24H2 Slow!
by
Bob Bible
3 hours, 36 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.