ACCESS FEED: Re: [MS_AccessPros] Query by form on a union query

Selasa, 12 Agustus 2014

Re: [MS_AccessPros] Query by form on a union query

No problem. My database has two tables. One with organization name and one with activities. However, I didn't create the other 3. So, they aren't set up the same. I can go back to the creators of the other 3 and get them to change their set up. They should be able to do this quickly, so I will talk to them now.

I don't have look up fields in any of the tables.

Karen

On Tuesday, August 12, 2014 9:54 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

Karen-

Also, in a properly designed database, organization name should appear in one and only one table. Knowing the design of your tables would help.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

On Aug 12, 2014, at 4:39 PM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Karen,
It would help if you provided the SQL views of your queries.
Are any of your fields "Lookup Fields" defined in your table designs?

Duane Hookom MVP
MS Access

Subject: [MS_AccessPros] Query by form on a union query
Hello everyone.

Situtation: I created a union query selecting data from 4 different tables. I set up a form to display the information and run a search for data using query by form. This works just fine. However, 3 of the tables have a field for organization name and one doesn't. The one that doesn't has and OrgID field that links to another table Activities by OrgID. So, in order to get the name of the organization added to the table I used in my union query, I created a separate select query to add the orgranization name. I tried replacing the 4th table in the union query with the select query. If I just run the union query, not using the form, everything looks great. Then I added search criteria to the union query in the query design mode and the query works fine. However, when I try to search by form, I don't get any results.

I hope I explained everything well.

Is there a way to get the results that I need using query by form or is that just not possible?

Karen