I am trying to update a record in a table based on the criteria in a field, let's say color. There may be many records that have the color RED but I only need to grab the first one to make an adjustment to the price. I am using the code below which is making a price adjustment but it is not grabbing a RED record, it is grabbing another color. This is a snippet of the code:
rstJournalShell![GLCOLOR] = strEntities(iCounter) 'this is an array that hold the color RED
.Fields("SumOfCoursePrice") = rstJournalShell.Fields("SumOfCoursePrice") - curBalance 'This is the price adjustment .Update
Is there a way that I can grab a record that has the color RED and make the adjustment to that?
Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
When developing Access applications, often we need to know whether an object exists. This article presents a quick and reliable routine to determine if an object exists without that object being opened.
If you wanted to inspect/ite…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …