Results 1 to 3 of 3
  1. #1
    JOJO9895 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jul 2018
    Posts
    7

    fonction to execute a request

    I created my database already, so i want to create a temporary table, in this table use two attribute of another table and for enter data into the temporary table i want to use fonction.

    Please help me

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    copy the fields from the source table and paste them into the temp table.
    make a form to allow users to enter data.

    make an append query to add the temp table data to the target table.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,725
    Welcome,

    Please tell us more about the proposed temporary table and the fields involved.
    What is the purpose of the temporary table? What is the intended logic of the function?

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

Similar Threads

  1. suppress request for a parameter
    By markjkubicki in forum Reports
    Replies: 4
    Last Post: 01-16-2018, 02:26 PM
  2. RunSQL vs. QueryDef.Execute vs. CurrentDB.Execute
    By caubetiep1337 in forum Queries
    Replies: 8
    Last Post: 12-16-2015, 05:35 PM
  3. Replies: 10
    Last Post: 02-27-2015, 11:28 AM
  4. Request for an Example of eCount SQL
    By SwensrnTaz in forum Access
    Replies: 4
    Last Post: 03-12-2012, 11:56 AM
  5. Number operation request.
    By Playerpawn in forum Access
    Replies: 0
    Last Post: 05-18-2011, 11:29 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