Page 1 of 2 12 LastLast
Results 1 to 15 of 28
  1. #1
    farmer4H is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Location
    College Station, Tx
    Posts
    14

    Step by Step viewing Submit Button actions

    I inherited a data base. It is updating multiple records every time a record is submitted using the form created for that purpose. It should only be adding one new record to two tables.

    I want to see what the submitpbutton is doing step by step after the submit button is selected. I am not having any luck. There are no macros I can find in the database. I have poured over the modules that are in the database and cannot find what is occuring.

    Can someone offer some debugging advice?

    Thanks for the help.

  2. #2
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    Can you upload a zipped copy of theDatabase?

  3. #3
    farmer4H is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Location
    College Station, Tx
    Posts
    14
    I can zip it but it is giving me a little trouble. This is a Front End, Back End application. Should I zip these seperatly and upload? I also need to delete a little bit of sensitive finacial information.

  4. #4
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    Yes, submit both. We can reconnect them on this end.

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    if it's an accde or mde file, likely they will be of no use.

    EDIT

    BE VERY CAREFUL IF REMOVING DATA. IF YOU COPY BOTH FILES AND START DELETING STUFF, YOU WILL PROBABLY DELETE FROM YOUR PRODUCTION DATA.
    You would copy both, rename back end copy (where the tables are) and re-connect copy FE to the new BE copy. Then look at all connections and ensure they're all pointing to the new BE copy.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  6. #6
    farmer4H is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Location
    College Station, Tx
    Posts
    14

    upload

    Ok, I have managed to zip and upload the files. A little background:
    • After making copies of the data base files I relinked the front end to the back end to make sure I was not working in the previous backend tables
    • I removed 99% of the records from the table titled tbl_Errorincident
    • After doing this the dang thing works when I created a new record using the form without making a bunch of additional entries in the table tbl_incidentstatus (this is the original problem I am trying to fix)



    Thank you for any help you can provide.
    Attached Files Attached Files

  7. #7
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    Which Form is the Submit button on??

  8. #8
    farmer4H is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Location
    College Station, Tx
    Posts
    14
    Sorry. When I open the database I have it set to launch the form: frm_TrasactionErrorLog it is on the tab, New Ticket.

  9. #9
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    We've never seen your db or forms before. We don't know anything about them or what their purpose is. Perhaps you could tell us what form you are working with, and how the user interaction on that form causes the problem, and how we can see the results, good or bad.

  10. #10
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    OK Your problem is to do with your Relationships between tbl_ErrorTypes and tbl_TransactionTypeErroirIndex

    If you try to set Referential Integrity between these 2 tables you will get an error message indicating that an Error Type is missing frm tbl_ErrorTypes

    The Error Type nr 14 is currently stored in your tbl_TransactionTypeErrorIndex but Nr 14 has been deleted from your tbl_ErrorTypes

    If you delete this record from your tbl_TransactionTypeErrorIndex and then set Referential Integrity between these tables you should be OK.

    There may be other issues

  11. #11
    farmer4H is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Location
    College Station, Tx
    Posts
    14
    Dang. I have no idea how you figured that out but I owe you! Now how do I change the Referential Integrity?

  12. #12
    farmer4H is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Location
    College Station, Tx
    Posts
    14
    Ok. I deleted Error type 14 from the tbl_transactiontypeerrorindex and set the Enforce Referential Integrety between tbl_errorTypes and tbl_TransactionTypeErrorindex. When I submit a record on the form frm_tranactionErrorLog I still get multiple entries in the tbl_incidentStatus.

    Any ides.

  13. #13
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    Once you have deleted the unwanted record from the Backend table you then display the Referential Integrity Window.

    Double Click on the Join between the tables and select Enforce Referential Integrity, then click OK

  14. #14
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    For the double trouble, try these:
    Click image for larger version. 

Name:	qry_append.png 
Views:	17 
Size:	42.4 KB 
ID:	39169

    Click image for larger version. 

Name:	qryMax.png 
Views:	16 
Size:	23.9 KB 
ID:	39170

  15. #15
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    You have the same problem between tblErrorIncident and tblIncidentStatus

    Unable to enforce Referential Integrity

    Also your qryInitialStatus is generating 2 records

    Davegri has also found the same problem

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 22
    Last Post: 07-18-2017, 01:05 AM
  2. Replies: 2
    Last Post: 10-21-2016, 11:26 AM
  3. Northwind Database Tutorial step by step
    By AATQA in forum Access
    Replies: 1
    Last Post: 10-22-2013, 06:20 AM
  4. step and step proccess
    By toochic in forum Programming
    Replies: 5
    Last Post: 10-09-2011, 09:34 AM
  5. Replies: 4
    Last Post: 04-29-2009, 04:59 PM

Tags for this Thread

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