-
WSAlexya1
AskWoody LoungerThanks Mark!
I have it working now… We’ll be upgrading soon… The boss said “Not until AFTER year end!”
I like your idea about “standard format for incoming data“… BUT
Ever heard of ADP?? ‘Nuff said…
-
WSAlexya1
AskWoody LoungerThanks Mark!
I have it working now… We’ll be upgrading soon… The boss said “Not until AFTER year end!”
I like your idea about “standard format for incoming data“… BUT
Ever heard of ADP?? ‘Nuff said…
-
WSAlexya1
AskWoody LoungerI agree with you Hans… When I started in this department I found that there were TONS of make table queries in about every mdb I looked at…. I almost never use them now… Except during the design process… OR when a query is getting way too slow because of the amount of levels of joins and subqueries…
Someone much more experienced than I once told me “If you have to make tables during daily processing… the database design isn’t right… ” …In most cases, if not all, I agree with him…
This seems to be processing in a reasonable amount of time at this point, so I’ll leave it for now…
Again… Thanks a million! -
WSAlexya1
AskWoody LoungerI agree with you Hans… When I started in this department I found that there were TONS of make table queries in about every mdb I looked at…. I almost never use them now… Except during the design process… OR when a query is getting way too slow because of the amount of levels of joins and subqueries…
Someone much more experienced than I once told me “If you have to make tables during daily processing… the database design isn’t right… ” …In most cases, if not all, I agree with him…
This seems to be processing in a reasonable amount of time at this point, so I’ll leave it for now…
Again… Thanks a million! -
WSAlexya1
AskWoody LoungerOkay… It’s settled… I’m a complete idiot today!
I had commented out the last line of Mark’s function… GetMonthPosRev = intPos + 1… because I didn’t want it to add one to the position…
So guess what?… The function was returning 0…
I’m kinda concerned about the efficiency of these functions though… Maybe I’m wrong (Very Probably!!!) but I was stepping through the code and mannn does it do a lot of looping for each string… The query is using this on over 50,000 records… Who knows… I suppose something similar is happening behind the scenes when I use InStr() too… Oh well…
It works!!! …Thank you both VERY VERY MUCH for the help!!!!!!
-
WSAlexya1
AskWoody LoungerOkay… It’s settled… I’m a complete idiot today!
I had commented out the last line of Mark’s function… GetMonthPosRev = intPos + 1… because I didn’t want it to add one to the position…
So guess what?… The function was returning 0…
I’m kinda concerned about the efficiency of these functions though… Maybe I’m wrong (Very Probably!!!) but I was stepping through the code and mannn does it do a lot of looping for each string… The query is using this on over 50,000 records… Who knows… I suppose something similar is happening behind the scenes when I use InStr() too… Oh well…
It works!!! …Thank you both VERY VERY MUCH for the help!!!!!!
-
WSAlexya1
AskWoody LoungerThanks Hans… Now it’s returning 0 for the position for every record… I don’t know what’s wrong at the moment but I guess I’ll have to keep trying… It was working find the first way I had it….. except now with this exception…
I really think I need to go forward and check for “Chr(32) MMM Chr(32) and a number” or “Chr(32) MMM and a number”… but right now, I don’t have a clue how…
This HAS to happen at Year End right??
-
WSAlexya1
AskWoody LoungerThanks Hans… Now it’s returning 0 for the position for every record… I don’t know what’s wrong at the moment but I guess I’ll have to keep trying… It was working find the first way I had it….. except now with this exception…
I really think I need to go forward and check for “Chr(32) MMM Chr(32) and a number” or “Chr(32) MMM and a number”… but right now, I don’t have a clue how…
This HAS to happen at Year End right??
-
WSAlexya1
AskWoody LoungerThanks Mark… but I’m still having problems… Since I can’t use InStrRev, I have no clue how I was supposed to adapt this for my purposes…
I must be brain dead today… Sorry…We really need a smilie for STRESSED OUT!!
-
WSAlexya1
AskWoody LoungerThanks Mark… but I’m still having problems… Since I can’t use InStrRev, I have no clue how I was supposed to adapt this for my purposes…
I must be brain dead today… Sorry…We really need a smilie for STRESSED OUT!!
-
WSAlexya1
AskWoody LoungerHi Colin…
Why not do something like only showing the user a combo box with the Month name?
ie… They select that the person wants to start in March or May or whatever… Behind the scenes on the form you take that value and fill a date field with the correct date…If you don’t want the users to be able to input a date and chance that they get it wrong, don’t let them input a date at all…. Only give them a choice…
and PLEASE tell me that they are not going into the tables and making changes as they wish… -
WSAlexya1
AskWoody LoungerHi Colin…
Why not do something like only showing the user a combo box with the Month name?
ie… They select that the person wants to start in March or May or whatever… Behind the scenes on the form you take that value and fill a date field with the correct date…If you don’t want the users to be able to input a date and chance that they get it wrong, don’t let them input a date at all…. Only give them a choice…
and PLEASE tell me that they are not going into the tables and making changes as they wish… -
WSAlexya1
AskWoody LoungerWait a minute… I just realized that I misunderstood… Are they going to be able to choose ANY month in the future??… For example, IF I sign up today, can I start a year and a half from now, on the first of the month?
-
WSAlexya1
AskWoody LoungerWait a minute… I just realized that I misunderstood… Are they going to be able to choose ANY month in the future??… For example, IF I sign up today, can I start a year and a half from now, on the first of the month?
-
WSAlexya1
AskWoody LoungerJust a thought, but why don’t you put a combobox on the form that has two values…
FirstOfMonth… DateSerial(Year(Date()),Month(Date()),1)
FirstOfNextMonth… DateSerial(Year(Date()),Month(Date())+1,1)
That way the user would only be able to choose one of the two…Does that 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
-
Search Forums only bring up my posts?
by
Deo
39 minutes ago -
Windows Spotlight broken on Enterprise and Pro for Workstations?
by
steeviebops
8 hours, 28 minutes ago -
Denmark wants to dump Microsoft for Linux + LibreOffice
by
Alex5723
1 hour, 4 minutes ago -
How to get Microsoft Defender to honor Group Policy Setting
by
Ralph
9 hours, 4 minutes ago -
Apple : Paragon’s iOS Mercenary Spyware Finds Journalists Target
by
Alex5723
19 hours, 13 minutes ago -
Music : The Rose Room – It’s Been A Long, Long Time album
by
Alex5723
20 hours, 19 minutes ago -
Disengage Bitlocker
by
CWBillow
10 hours, 16 minutes ago -
Mac Mini M2 Service Program for No Power Issue
by
Alex5723
22 hours, 18 minutes ago -
New Win 11 Pro Geekom Setup questions
by
Deo
2 hours, 4 minutes ago -
Windows 11 Insider Preview build 26200.5651 released to DEV
by
joep517
1 day, 5 hours ago -
Windows 11 Insider Preview build 26120.4441 (24H2) released to BETA
by
joep517
1 day, 5 hours ago -
iOS 26,, MacOS 26 : Create your own AI chatbot
by
Alex5723
1 day, 9 hours ago -
New PC transfer program recommendations?
by
DaveBoston
4 hours, 52 minutes ago -
Windows 11 Insider Preview Build 22631.5545 (23H2) released to Release Preview
by
joep517
1 day, 13 hours ago -
Windows 10 Build 19045.6029 (22H2) to Release Preview Channel
by
joep517
1 day, 13 hours ago -
Best tools for upgrading a Windows 10 to an 11
by
Susan Bradley
1 day, 1 hour ago -
The end of Windows 10 is approaching, consider Linux and LibreOffice
by
Alex5723
5 hours, 58 minutes ago -
Extended Windows Built-in Disk Cleanup Utility
by
bbearren
14 hours, 52 minutes ago -
Win 11 24H2 June 2025 Update breaks WIFI
by
dportenlanger
2 days, 8 hours ago -
Update from WinPro 10 v. 1511 on T460p?
by
CatoRenasci
1 day, 6 hours ago -
System Restore and Updates Paused
by
veteran
2 days, 11 hours ago -
Windows 10/11 clock app
by
Kathy Stevens
1 day, 22 hours ago -
Turn off right-click draw
by
Charles Billow
2 days, 14 hours ago -
Introducing ChromeOS M137 to The Stable Channel
by
Alex5723
2 days, 17 hours ago -
Brian Wilson (The Beach Boys) R.I.P
by
Alex5723
30 minutes ago -
Master patch listing for June 10, 2025
by
Susan Bradley
2 days, 19 hours ago -
Suggestions for New All in One Printer and a Photo Printer Windows 10
by
Win7and10
2 hours, 9 minutes ago -
Purchasing New Printer. Uninstall old Printer Software First?
by
Win7and10
3 days, 1 hour ago -
KB5060842 Issue (Minor)
by
AC641
1 day, 13 hours ago -
EchoLeak : Zero Click M365 Copilot leak sensitive information
by
Alex5723
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.