Advertisement

06.02.2008 at 05:17AM PDT, ID: 23449559
[x]
Attachment Details

Microsoft, Access, 2007, Where to put validation code? Form_BeforeUpdate to early.

Asked by SheahaST in Access Forms, Access Coding/Macros

Tags: Microsoft, Access, 2007, Where to put validation code? Form_BeforeUpdate to early.

I have the following the following tables: tblCalls, tblCallers, tblProspectiveResidents, tblWorkOrders, tblResidentRequests.  The last 4 tables are linked to tblCalls via a CallID foreign key, and the information in these tables is entered via subforms to the form for Calls.

The amount of time a call center agent talks with the client needs to be recorded.  This information is stored in tblCalls.  The call center agent gets the duration of the call from their telephone.  I was hoping to use Form_BeforeUpdate to enforce that the call center agent has entered the duration of the call, but this event occurs more often than I anticipated (each time I switch to another subform).

I want this enforcement to occur before the agent moves onto another record in tblCalls.  How do I do this?Start Free Trial
[+][-]06.02.2008 at 05:25AM PDT, ID: 21691314

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.02.2008 at 05:30AM PDT, ID: 21691349

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.02.2008 at 05:32AM PDT, ID: 21691362

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.02.2008 at 05:33AM PDT, ID: 21691368

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.02.2008 at 07:27AM PDT, ID: 21692238

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.02.2008 at 07:23PM PDT, ID: 21697198

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.05.2008 at 07:46PM PDT, ID: 21725845

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Access Forms, Access Coding/Macros
Tags: Microsoft, Access, 2007, Where to put validation code? Form_BeforeUpdate to early.
Sign Up Now!
Solution Provided By: SheahaST
Participating Experts: 3
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628