Solved

Infopath Form - Query Repeating Table from Access Submitting to Access

Posted on 2013-10-22
2
953 Views
Last Modified: 2013-10-22
I want to create a form that submits to an Access 2007 database. The main purpose for the form is to allow the user to submit request for vacation time. I wanted add the abiliity for the user to see their vacation time summary as well. This information is also stored in the same database and for which I have created a query for. I figured I would add the prebuilt query to the form as a secondary data source and that would be ran when the user request to see the data. For some reason I thought I would be able to set a filter (username()) before executing the query but I dont see where I can do that. I see it on the main source but not the secondary sources. Can someone tell me what I am missing? I am I able to do this? Do I need to add some code to perform the filtering?
0
Comment
Question by:spaced45
2 Comments
 
LVL 28

Accepted Solution

by:
clayfox earned 500 total points
ID: 39592649
You cannot filter secondary sources when using an ODBC connection like that.

So on the repeating field or dropdown you put a filter to hide what you do not want.  This is not as efficient as a query but it gets the job done.
You can create a formatting rule which hides where username does not equal name in the Access Data.
0
 
LVL 1

Author Comment

by:spaced45
ID: 39592687
I was afraid I was going to get this response. Thank you for your assistance.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question