Results 1 to 3 of 3
  1. #1
    Gagnon is offline Novice
    Windows 8 Access 2007
    Join Date
    Oct 2016
    Posts
    2

    Problem Importing Query To Form

    I am trying to import a query into a form.

    Because its a query, when I go to 'add existing field' in design section, will only let me pick tables. I need to do a querty

    When I am highlighted on the query and select 'create form' it does import all data from the query. But I cant individually size certain fields, i resize and try to move ont field and they all move and change size.

    Any way I can unlock this? Or import query data one field at a time?

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    You can use a Query as the Data Source of your Form just as easily as you can a Table.
    If you go to Properties of your Form and select Record Source, you can choose your Query name here.
    Then, all the available fields will be the fields from your Query.

    When I am highlighted on the query and select 'create form' it does import all data from the query. But I cant individually size certain fields, i resize and try to move ont field and they all move and change size.
    That is the default behavior, but it can be changed. See: https://support.office.com/en-us/art...8-f8db0650a761

  3. #3
    Gagnon is offline Novice
    Windows 8 Access 2007
    Join Date
    Oct 2016
    Posts
    2
    Bingo! Thanks!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Problem importing data from a .csv file
    By RickK in forum Access
    Replies: 4
    Last Post: 09-22-2016, 08:58 AM
  2. Problem with data type when importing CSV via VBA
    By raynman1972 in forum Import/Export Data
    Replies: 1
    Last Post: 04-30-2013, 11:40 AM
  3. problem with importing email attachments to access
    By funi.t in forum Import/Export Data
    Replies: 1
    Last Post: 12-20-2011, 10:20 AM
  4. Problem with date when importing
    By ds_8805 in forum Import/Export Data
    Replies: 5
    Last Post: 01-27-2010, 02:30 AM
  5. Replies: 0
    Last Post: 03-27-2008, 08:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums