-
WSNight
AskWoody Loungeryou’re telling me they selling it at 5 bucks a month? you’re right it does sound to good to be true. I will definately check that place out as well. Thanks a lot for the info.
-
WSNight
AskWoody Loungeryou’re telling me they selling it at 5 bucks a month? you’re right it does sound to good to be true. I will definately check that place out as well. Thanks a lot for the info.
-
WSNight
AskWoody LoungerThanks Mark. I will check them out a little later today. I appreciate the suggestion. Any other suggestions are still welcome. Just doing a little research before I make the move. I do want to change hosts for sure though. Thanks.
-
WSNight
AskWoody LoungerThanks Mark. I will check them out a little later today. I appreciate the suggestion. Any other suggestions are still welcome. Just doing a little research before I make the move. I do want to change hosts for sure though. Thanks.
-
WSNight
AskWoody LoungerThanks. I am also not a big mac person but it is for my mom’s computer at her work. So I am just looking around for her. Thanks again.
-
WSNight
AskWoody LoungerI understand that Charlotte. I thank you. But this is how they wanted it. They never do seem to listen to my advice. Either way though it’s done so I don’t have to mess with that DB again.
-
WSNight
AskWoody Loungerwell the reason is this. The way reocrd management works here there is a number corosponding with every Record Series Name. There could be multiple numbers for the same Series name because it could be a different department that has that name as well. So I needed to put the numbers by the name so people would know. Now, I needed the second column to be stored as well because if it wasn’t then I wouldn’t be able to pull a report by the number which some people very well may likely do. That is why I did what I did.
-
WSNight
AskWoody Loungeryeah I knew I was retarded. For some reason more complex things I can figure out, but the most simple of concepts I have trouble with. Ah well it works now. Thanks.
-
WSNight
AskWoody Loungerhere is my code for the selection.
Private Sub BySearchType_AfterUpdate()
Display_Click
End SubPrivate Sub Display_Click()
On Error GoTo OK_Click_Err
If IsNull(Me.OpenArgs) Then
MsgBox “You Cannot Display Records in the Definition Mode”, 16, “Definition Mode”
Exit Sub
End If
If IsNull(Me![BySearchType]) Then
Response = MsgBox(“You Did Not Select a Record to Search For”, 32, “No Record Selected”)
Exit Sub
Else
‘First Update the Definition Table with the Last Option Chosen
Dim CurDB As Database, SQLStmt As String, GetData As Recordset
Set CurDB = CurrentDb()
SQLStmt = “SELECT * FROM ezs_SmartSearchDefinition WHERE SearchID = ” & Chr(34) & DefEntry & Chr(34) & ” and Sequence = 1″
Set GetData = CurDB.OpenRecordset(SQLStmt, DB_OPEN_DYNASET)
If Not GetData.EOF Then
GetData.Edit
GetData!LastSelectedOption = Me![TypeofSearch]
GetData.Update
GetData.Close
End If
Dim Criteria As String ‘ This is the argument to the FindFirst method
Set GetData = forms(CallingForm).RecordsetClone
‘Build the criteria.
Select Case KeyDataType
Case “Number”
Criteria = “[” & KeyField & “]=” & Me![BySearchType]
Case “String”
Criteria = “[” & KeyField & “]='” & Me![BySearchType] & “‘”
Case “Date”
Criteria = “[” & KeyField & “]=#” & Me![BySearchType] & “#”
End Select
‘Perform the search.
GetData.FindFirst Criteria
If Not GetData.NoMatch Then
‘Synchronize the form’s record to the dynaset’s record.
forms(CallingForm).Bookmark = GetData.Bookmark
End If
GetData.Close
‘Return to Me![CallingForm] and Close the EZ Search Manager
DoCmd.SelectObject A_FORM, CallingForm
DoCmd.Close A_FORM, “ezs_SmartSearch”
End If
Exit Sub
OK_Click_Err:
MsgBox “Invalid Search was Found”, vbCritical, “Invalid Search”
Exit SubEnd Sub
Hope this helps at all.
-
WSNight
AskWoody LoungerWell here is what I have. On the Access Bible CD there is an easy search that was created by database creations. I basically built this same type of search function. The search is on it’s own form. I have a form where I enter in data, so on and so forth. On that I have a button that brings up the search form. Now I can click on the Radio button depedening on what I want to search by (Publication, Title, Date) whatever. In a combo box below all the things matching what was selected above show up. When I click on one of the different choices that are provided it SHOULD populate my form. For some reason though it is not. That is the only problem I am having. Once I figure this out, I am done with my database. Thanks for the help.
-
WSNight
AskWoody LoungerIt must be in my SQL statement then. I will go check it out. Thank you much.
-
WSNight
AskWoody LoungerJust curious as to what was edited in my post. Doesn’t look any different that before.
-
WSNight
AskWoody LoungerEdited by WyllyWylly on 18-Jul-02 11:02.
Oh I’ve found the geforce4 for a resonable price already. But as I stated I am going to wait because for all i know they’ll Release another card by the time I start to do the building. Right now I’m just working on my case and such so I still have a month or so before I start putting it together.
-
WSNight
AskWoody LoungerI don’t know though. That card seems to do rather well when stacked up against the gf4. But I haven’t decided yet. The video card will be the last thing I buy because there may be another set of cards out by the time I am ready to build.
-
WSNight
AskWoody LoungerAlright, I managed to talk my manager out of storing this data into another table. So now all I need to do is pull it into my retention box based on whats selected in the Combo box. They are related in the same table this is the DLookUp what I have now. Thanks for the help
=DLookUp(“[RetentionField]”,”tblRecordMgmt”,”[RecSerNameField] = ” & chr(34) & [RecSerName] & chr(34))
![]() |
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
-
MS Passkey
by
pmruzicka
14 minutes ago -
Can’t make Opera my default browser
by
bmeacham
2 hours, 8 minutes ago -
Do not Fall For This Purdentix Scam (Awaiting moderation)
by
elizabethkaur56
8 hours, 7 minutes ago -
*Some settings are managed by your organization
by
rlowe44
1 minute ago -
Formatting of “Forward”ed e-mails
by
Scott Mills
1 hour, 2 minutes ago -
SmartSwitch PC Updates will only be supported through the MS Store Going Forward
by
PL1
20 hours, 44 minutes ago -
CISA warns of hackers targeting critical oil infrastructure
by
Nibbled To Death By Ducks
1 day, 5 hours ago -
AI slop
by
Susan Bradley
1 day, 4 hours ago -
Chrome : Using AI with Enhanced Protection mode
by
Alex5723
1 day, 7 hours ago -
Two blank icons
by
CR2
16 hours, 35 minutes ago -
Documents, Pictures, Desktop on OneDrive in Windows 11
by
ThePhoenix
1 day, 15 hours ago -
End of 10
by
Alex5723
1 day, 18 hours ago -
Single account cannot access printer’s automatic duplex functionality
by
Bruce
16 hours, 30 minutes ago -
test post
by
gtd12345
2 days ago -
Privacy and the Real ID
by
Susan Bradley
1 day, 14 hours ago -
MS-DEFCON 2: Deferring that upgrade
by
Susan Bradley
1 day, 6 hours ago -
Cant log on to oldergeeks.Com
by
WSJonharnew
2 days, 4 hours ago -
Upgrading from Win 10
by
WSjcgc50
16 hours, 40 minutes ago -
USB webcam / microphone missing after KB5050009 update
by
WSlloydkuhnle
20 hours, 14 minutes ago -
TeleMessage, a modified Signal clone used by US government has been hacked
by
Alex5723
2 days, 20 hours ago -
The story of Windows Longhorn
by
Cybertooth
2 days, 8 hours ago -
Red x next to folder on OneDrive iPadOS
by
dmt_3904
2 days, 22 hours ago -
Are manuals extinct?
by
Susan Bradley
8 hours, 12 minutes ago -
Canonical ditching Sudo for Rust Sudo -rs starting with Ubuntu
by
Alex5723
3 days, 7 hours ago -
Network Issue
by
Casey H
2 days, 18 hours ago -
Fedora Linux is now an official WSL distro
by
Alex5723
3 days, 19 hours ago -
May 2025 Office non-Security updates
by
PKCano
3 days, 20 hours ago -
Windows 10 filehistory including onedrive folder
by
Steve Bondy
3 days, 22 hours ago -
pages print on restart (Win 11 23H2)
by
cyraxote
2 days, 22 hours ago -
Windows 11 Insider Preview build 26200.5581 released to DEV
by
joep517
4 days 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.