Advertisement

05.13.2008 at 05:46PM PDT, ID: 23399931
[x]
Attachment Details

Subform linked via date field does not show the results

Asked by katsema in Access Forms, Microsoft Access Database, Microsoft ADP

Tags: Microsoft, Access, 2003, ADP date field as link child field

I have an Access ADP project (first time in my life!). There is a text field on the form, called Rdate which is a date. There is also a subform on the form, based on a view that has a date field called e_date.  Link Clind Field is set to e_date and Link Master field is Rdate. It does not pull data from the view into subform. If I link on another field (character field) it works fine, but this is now that I need. Something probably does not match in SQL and Access date format. Can you please help?Start Free Trial
 
 
[+][-]05.13.2008 at 05:58PM PDT, ID: 21560471

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.

 
[+][-]05.13.2008 at 06:00PM PDT, ID: 21560473

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.

 
[+][-]05.13.2008 at 11:26PM PDT, ID: 21561648

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.

 
[+][-]05.14.2008 at 09:28AM PDT, ID: 21565913

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

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

 
[+][-]05.14.2008 at 12:15PM PDT, ID: 21567690

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.

 
[+][-]05.14.2008 at 12:35PM PDT, ID: 21567884

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

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

 
[+][-]06.05.2008 at 11:18AM PDT, ID: 21722431

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

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

 
[+][-]06.12.2008 at 07:55PM PDT, ID: 21775512

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, Microsoft Access Database, Microsoft ADP
Tags: Microsoft, Access, 2003, ADP date field as link child field
Sign Up Now!
Solution Provided By: Computer101
Participating Experts: 4
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628