View Single Post
Old March 8th, 2005, 03:31 AM
me2357 me2357 is offline
Registered User
Join Date: Mar 2005
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Function to Find a Record

I feel bad posting because I'm sure this topic has been covered, but I'm pretty new to both Visual Basic and Access, os other than browsing several index pages, I'm not sure where to look for my answer.

I'm parsing lots of text files and placing the data into several tables using a VBA script. One of the tables is for people and another is for events. Each event has several different people and each person associates with several events and each have unique record IDs. So, when I'm making a new event record, I want to take the name I've parsed and see if it exists in the people table. If it does, I want this function to return the person's ID number.

I'm having trouble specifically with the person lookup function, so any help anyone could give to get me started would be appreciated. Thanks!