Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

GUID Question

Status
Not open for further replies.

Ray1127

Programmer
Feb 22, 2002
231
US
I have a form in Access 2003 the Primary key for the data table is a GUID Field. The Source of the form is a query to get all members that termed the previous month. Making sure to eliminate any members that have re-enrolled. For Example Sam Smith Terms May 20, 2011 and re-enrolled June 3, 2011. He would be excluded. So the query for the form does a left outer join between members that termed the previous month and the current members. Where the current member keyid is null. The member keyid is the GUID Field I'm talking about. For each member that termed we want to call them and find out what we can do to improve and possibly get them to re-enroll. We want to store the Date/Time the member was called. If the member answered the phone and the reason for the termination. Since the form is based on a non-updateable query I've included a command button the user clicks to save the record. The problem is when the code executes the keyid field only shows ????????? and the code errors. On the form the textbox shows the correct guid. What am I missing?

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top