Results 1 to 7 of 7
  1. #1
    SlingShot is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Dec 2024
    Posts
    3

    Lightbulb MSExcel Translate MS Access

    Good day to all,

    newbie here Is anyone can help me to translate attach file Excel into MS Access Please.Lending Payment Schedule.zip




    Thank you.

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,555
    Not easily.
    Might be better to look for a template.
    https://www.google.com/search?q=micr...hrome&ie=UTF-8
    Last edited by Welshgasman; 12-22-2024 at 06:47 AM.
    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

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,555
    Here is one to start with, though they expect monthly payments not weekly, so you will have to do some work yourself.
    Attached Files Attached Files
    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

  4. #4
    SlingShot is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Dec 2024
    Posts
    3
    Thanks i will check.

  5. #5
    SlingShot is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Dec 2024
    Posts
    3
    Thank you bro. but my ms access is just basic.

  6. #6
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,555
    Stick to Excel then, as they are two different beasts and require different thinking.
    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

  7. #7
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,820
    Hi
    The first part of selecting a Client and entering the Loan Amount is easy to setup. The payment side si more difficult
    and out of my knowledge range.

    See the attached example.
    Attached Files Attached Files

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

Similar Threads

  1. Replies: 1
    Last Post: 10-18-2020, 10:00 AM
  2. Replies: 1
    Last Post: 12-06-2019, 02:44 PM
  3. Replies: 41
    Last Post: 05-29-2015, 02:58 PM
  4. Replies: 0
    Last Post: 09-03-2009, 01:58 PM
  5. how to translate "row_number"?
    By mfran2002 in forum Queries
    Replies: 0
    Last Post: 09-17-2008, 03:13 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