Rich_Lovina
Registered User.
- Local time
- Today, 23:33
- Joined
- Feb 27, 2002
- Messages
- 225
Can DLookup Do This One, or will Combo boxes help?
Okay, my db is getting larger & larger (41,000 recs), personnel data, and I have the following problem:
10,000 recs have a textfld with about 7,000 variations, 31,000 are blank on this field, called Sect1.
95% of data comes in under a lovely vb code tks to Forum members, balance by manual entry.
Text in Sect1 has been manually updated for fldIT = yes/no, and fld Sect_CC, where IT = yes has been manually updated with text code (linked to table ComCodes) by one of 25 types of IT executive.
My problem is : how to use a Dlookup, to lookup previous records to see if textstring "Financial Records" is already there and has already been coded IT =yes and Sect_CC = FO.
I've searched existing posts for something similar without success.
Could a Command Button create a code which refreshes or requeries the data?
Only nine months into vb, but am starting to get some successes, so thanks in advance.
Okay, my db is getting larger & larger (41,000 recs), personnel data, and I have the following problem:
10,000 recs have a textfld with about 7,000 variations, 31,000 are blank on this field, called Sect1.
95% of data comes in under a lovely vb code tks to Forum members, balance by manual entry.
Text in Sect1 has been manually updated for fldIT = yes/no, and fld Sect_CC, where IT = yes has been manually updated with text code (linked to table ComCodes) by one of 25 types of IT executive.
My problem is : how to use a Dlookup, to lookup previous records to see if textstring "Financial Records" is already there and has already been coded IT =yes and Sect_CC = FO.
I've searched existing posts for something similar without success.
Could a Command Button create a code which refreshes or requeries the data?
Only nine months into vb, but am starting to get some successes, so thanks in advance.
Last edited: