What I need sounds simple but I just can't get my head around the problem. Its been a while since i used VBA.
I have a lending library database (access 2010 on Windows xp). I have another patron registration database.
I link the TRANSACTION table from the Library application into Registration application. The unique identifier for both is the MembershipID.
When member registration form opens at library: Match the MembershipID from the Transaction table.
If Due Date is past today’s and the Checked in Date is Null, then a message to pop up saying something like: [Title] was due on [Due Date].
The title is field name [ASSET] and is a LookUp field from the Asset Table: SELECT [Assets].ID, Assets.[Title] FROM Assets;
I cannot get the correct syntax to accomplish this. Any help will be most appreciated. Thanks
I have a lending library database (access 2010 on Windows xp). I have another patron registration database.
I link the TRANSACTION table from the Library application into Registration application. The unique identifier for both is the MembershipID.
When member registration form opens at library: Match the MembershipID from the Transaction table.
If Due Date is past today’s and the Checked in Date is Null, then a message to pop up saying something like: [Title] was due on [Due Date].
The title is field name [ASSET] and is a LookUp field from the Asset Table: SELECT [Assets].ID, Assets.[Title] FROM Assets;
I cannot get the correct syntax to accomplish this. Any help will be most appreciated. Thanks