Results 1 to 2 of 2
  1. #1
    cb122 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2023
    Posts
    4

    linking query data to a new FE form/page (crash course)

    Hi


    I have not done any form of Microsoft Access development work for over 10 years, but due to issues with resources/leavers, I need to make an amendment to an access application. There is a form, with several pages (tabs). I have written an SQL query that I need to display on a newly created form. It needs to be read/write, as one of the key purposes of the new page is to allow a user to sign off certain records (yes/no data type). It is just a very basic form, display data, allow users to tick a specific box. It doesn’t need to be a form whereby new data is entered into the database, no new records etc.
    I am trying to cast my mind back, if there a wizard within Access that can guide you through the process of linking the page to a query and display the data or is it a totally manual process? If the latter, can you recommend a basic tutorial on linking a newly created form/page to the newly created SQL query to display the data in read/write format please, in line with the requirements I have described? I will obviously do any proposed change in a test version, where it will be tested rigorously, before trying it on a live system.
    Thanks

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,943
    Highlight the required table/query, then use the Create tab and the Form button.
    Search YouTube.com for how to create forms and much more. Pleanty of videos on there for Access.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Linking a table post to it's form page
    By Axson in forum Macros
    Replies: 2
    Last Post: 07-09-2020, 03:12 AM
  2. Replies: 4
    Last Post: 11-14-2012, 03:08 PM
  3. TextBox control not linking to query data
    By tylerg11 in forum Forms
    Replies: 3
    Last Post: 09-28-2011, 09:56 AM
  4. Query SQL Crash
    By Scorpio11 in forum Queries
    Replies: 1
    Last Post: 07-20-2010, 02:32 PM
  5. Replies: 2
    Last Post: 09-14-2006, 04:12 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