Microsoft Access

Re: Pull Data from Access

zain123 — Fri, 24 Oct 2014 12:16:39 GMT

I have built a form based on the database template and hope want to pull records based on two mutually exclusive fields. Basically I have a table that has a username and a contactname field which contain an employee identifier. In theory if the username field has a value then the contactname should be blank and vice-versa. In certain records both the username and contactname have the same value and others have different values other than null. I want to be able to query both the username and contactname fields simultaneously so that if either field contains the value I have quer

Re: Pull Data from Access

Patrick Halstead — Sat, 24 Nov 2012 18:25:42 GMT

Hi Perceptus,

You should be able to just add a rule that changes the fields under the Query node and then queries the data source.

Pull Data from Access

Perceptus — Mon, 19 Nov 2012 18:55:33 GMT

I want to pull all the data from a query and have it displayed on an Infopath form. I dont need to modify the data in any means(nor would it be possible given the amount of joins xD). I have created a form using MS Access Connection and can see Q and D field data in the Data Source window. Where do I go from here?