Page 7 of 7 FirstFirst 1234567
Results 91 to 98 of 98
  1. #91
    deepaksharma is offline Competent Performer
    Windows 7 32bit Access 2016
    Join Date
    Jul 2023
    Location
    india
    Posts
    389


    Quote Originally Posted by mike60smart View Post
    I have corrected your Primary Key in Grey_Offer Table

    It is now linked to the Subform on GreyOfferID
    Thanks for help......
    Well I don't understand why you would want to create an auto number field named Gray Offer ID in the Gray Offers table file when it has no use. And by the way my problem is about not finding the data.

  2. #92
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,566
    No your problem is because your table Grey_Offer is a spreadsheet layout
    You have all of your process in 1 table for data entry when you need a Form that allows you to select a Party
    then enter related data for the Offer and then related data for the Shade.
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  3. #93
    deepaksharma is offline Competent Performer
    Windows 7 32bit Access 2016
    Join Date
    Jul 2023
    Location
    india
    Posts
    389
    Quote Originally Posted by mike60smart View Post
    No your problem is because your table Grey_Offer is a spreadsheet layout
    You have all of your process in 1 table for data entry when you need a Form that allows you to select a Party
    then enter related data for the Offer and then related data for the Shade.
    After the changes made by creating auto id field in your gray offer table, you are not able to enter in gray shade table, please check

  4. #94
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,566
    Sorry Here with updated Data Entry Form
    I have only put 1 Shade in for the First Record
    Attached Files Attached Files
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  5. #95
    deepaksharma is offline Competent Performer
    Windows 7 32bit Access 2016
    Join Date
    Jul 2023
    Location
    india
    Posts
    389
    Quote Originally Posted by mike60smart View Post
    Sorry Here with updated Data Entry Form
    I have only put 1 Shade in for the First Record
    This file is hanging problem
    I don't know why

  6. #96
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,566
    Hi
    Well I would suggest here is some problem with your PC as the process of Uploading
    Files has worked for years for millions of people.
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  7. #97
    deepaksharma is offline Competent Performer
    Windows 7 32bit Access 2016
    Join Date
    Jul 2023
    Location
    india
    Posts
    389
    Quote Originally Posted by mike60smart View Post
    Hi
    Well I would suggest here is some problem with your PC as the process of Uploading
    Files has worked for years for millions of people.
    I just tried this file on another computer, there was an issue with the version of Access. Still this file is opened with little problem.
    You have designed a very nice program.
    You tell me what is the difference between getting the data inserted in the form from the master and the program you have created?
    Why did you choose a different way to enter party data?

  8. #98
    deepaksharma is offline Competent Performer
    Windows 7 32bit Access 2016
    Join Date
    Jul 2023
    Location
    india
    Posts
    389
    In this program GST number of every party will be fixed GST number is not changeable for any party

Page 7 of 7 FirstFirst 1234567
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 9
    Last Post: 04-26-2019, 08:17 PM
  2. Replies: 6
    Last Post: 04-16-2018, 09:15 PM
  3. Replies: 3
    Last Post: 09-01-2015, 04:36 AM
  4. Replies: 7
    Last Post: 06-12-2012, 08:56 AM
  5. Replies: 5
    Last Post: 03-03-2011, 03:56 PM

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