Search results

Minty and missinglinq, Thank you for your responses. To answer your question:"What determines it would be a duplicate? " If user clicked on the append button more then once, a new record is added to the table that is linked to this process and when I open up this table I can see these dups...

missinglinq and Ranman256, Thank you for your responses. I wanted to mention that the form where this append button is placed is a bound form and when the user clicks on the button it runs an append query and adds records to a table. The reason why I posted this question is because I am...

Hello, I built a form that has an Append Button that helps me to add records to a table. The code that I have works very well (see below code) but I would like to add additional step to it. Once the user clicked on the append button once, I would like to add a code that would prevent/stop the...

Hello Everyone, Thank you for helping with the above listed question. I found my solution in VBA code. This issue is closed. Thanks again.

Hello Cronk, I understand your concern. I am still searching for the right answer. I am currently trying out Dave's suggestion. So far did not work for me. Thank you,

Hello Everyone, I am reaching out to you for your help. I am moving a process that was built in Excel into Access and came across with an issue where I am unable to replicate a SUMIFS formula to a work around in Access. I know that there is no such thing as SUMIFS in Access, but there must be a...

Gina Whipp, Thank you very much for your response. I really appreciate it. I agree with you regarding the issue that I am missing a unique identifier in my Table #2. Since I can't re-build this table. I was just thinking... What if I will build a new query prior to the query that I am having an...

The Doc_Man and GinaWhipp, Thank you for your responses. I tried the syntax you wrote and my results did not change. I still have wrong values. My SQL is as follows: SELECT Table2.[Account Number], Table1.[Sub Account Number], Table1.[Account Name], Table1.Amount FROM Table1 LEFT JOIN Table2...

Hello, I need Help with my query. I built 2 tables: Table 1: sub account number, account name, amount paid (Record one: abc, Tree, 100; Record two: abc, Tree, 200) and Table 2: account number, sub account number, account name (Record one: 1122, abc, Tree; Record Two: 3344, acb, Tree). I joined...

Hello, I am a beginner user of Access DB. Thank you,