Search results

Hi again @plog I took your advice and made some changes. Thanks again for taking the time to advise me. Kindly see below updated Sample database. "Anyone else who would like it as a template is welcome to use it :) "

Thank you very much for your input. I will consider your words carefully while implementing the recommendations.

Good day everyone, I've been struggling with this for almost a week now. Was hoping one of the geniuses on here might have any idea's on how to resolve this. I have an unbound form StatementF with 3 unbound combo boxes on it. Namely CustomerName, StartDate and EndDate. I then have a Query...

Thank you gentleman/gentlewomen for your feedback. @MajP 1. The more comprehensive calculation sounds really enticing. I was just going to manually check every time. Knowing now that it is possible, I will definently look into it. Thanks! 2. The general rule of thumb would be 5 days upon...

Good day everyone, I have two Fields in my InvoiceT. Namely InvoiceDate and InvoiceDueDate. Data in the InvoiceDate field changes based on the certain situations. What I'm trying to achieve is having the InvoiceDueDate field populate with the same date as the InvoiceDate field + 5 days. I...

Thank you again👋

@arnelgp Your VBA code is still going strong. Thank you again! Can you please assist with a slight modification. I'm trying to get it to work on a different Main form with no subform. When I try the above code but insert the form's name into the With [SubformName].[Form], then I get the...

You Sir/Mam are my Hero! Thank you!

Good day everyone, I have a subform "InvoiceActiveList" on my main form "Invoice" form. I have an On Click event that opens a report in Print preview based on the clicked InvoiceNumber Is it possible to create a function that if the SalesInvoice Yes/No field is true then it opens a...

Thanks to everyone for their input. I implemented a Discount field and a Invoice Total that stores the final value. I appreciate the insights.

Sorry for the late reply everyone, year end is hectic. @Pat Hartman thanks for your suggestion. I don't store the calculated field (Fixed Price). Only the Time & Labour rate (Calculated) fields are stored in tables. The Fixed Price field is simply for the sake of printing the invoice. I'd...

Good day everyone, Really sorry to ask such a mundane question here, but I'm struggling to finish off my invoicing. In short, I make use of a query (InvoiceSalesQ) to calculate Totals on my InvoiceSalesF form. However, there are times where I want to amend the Total amount for certain...

Thank you kind souls for pointing me in the correct direction and the example VBA codes. It worked perfectly.

Thank you very much. I will look into this

Good day internet geniuses. Please can you assist. I have a form InvoiceSalesF, with a continuous subform that displays records in the cost table CostT. (Forms are linked via InvoiceID) I have a button that opens up a pop up form that's control source is the Cost table CostT. The...

Ok, so it is working now. The easiest solution is curtsey of @Ranman256 , @Minty and @ebs17. 1. Store the value in the table as a Number data type. 2. On the Form I used the following VBA code to find the largest number in the InvoiceNumber field and incremented it by 1: Private...

Thank you everyone for your feedback. I'm going to try setting it to a Number value and play with the format of the property in the Form. Will post result when I get it working.

Good day everyone, I have a sequential field called InvoiceNumber. I'd like to use DMax to reference the highest value and then add a one to it. I have this setup in the On_Load Event on my Invoice New Form. However, I'm getting the following error Is this due to it referencing the I...

Hi @Pat Hartman, thanks for your feedback. For the most part the invoicing section will only be processed by a single user. The issue with the updating of each record individually is that its time consuming. Imaging having to click on 50 records to update them. I know as database designers we...

It was so small that I didn't see it:ROFLMAO:. Thanks again for your awesome solution and everyone for their input. #11 was the fix