Search results

Hello there everyone, Looking for a nudge in the right direction please. I already have a StatementR report that reflects Invoices details (InvoiceNumber, InvoiceAmount, AmountDue etc.) The AmountPaid field on the report is calculated in the StatementRQ query: Amount Paid...

Good day good people of the internet. I have a database that I use to keep track of jobs, invoices and quotes. I also have to keep track of travel, stock and labour data linked to each of the above. Below is my current database format: When a record in the JobsT table has a corresponding...

Hi everyone, I'm attempting to use the following VBA code to print a record on a form: Me![Paid] = True Me.Refresh DoCmd.OpenReport IIf(SalesInvoice, "InvoiceSalesR", "InvoiceJobR"), acViewPreview, , "InvoiceID=" & InvoiceID The form InvoiceActiveList that the record is on uses a query...

Good day everyone, I was searching around the forum and couldn't find a solution to this. I use the Report Footer to show final totals and payment advice, so in my case it needs to be the end of the report. I know the Report Footer follows the Detail portion of the Report. So sometimes the...

Good day everyone, Please can you assist me. I have the following code which opens my reports InvoiceJobR/InvoiceSalesR in Print Preview, depending on the IIF criteria. Private Sub InvoiceNumber_Click() DoCmd.OpenReport IIf(SalesInvoice, "InvoiceSalesR", "InvoiceJobR"), acViewPreview, ...

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...

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...

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...

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...

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...

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...

Good day everyone, Just a quick one. Is there a way to select a specific record based on the selected radio button on a continuous form? I know that the radio buttons has a different option value. I think making them unbound is the way to go? All I basically want to achieve is when the...

Good day everyone. I have an Invoice form with a subform on it pulling records from another table (JobT) pertaining to the PK. The TicketNumber on the Invoice form is a Relational Combo box that runs off of a query. It essentially filters the JobT for records marked as Completed. Is there...

Good day everyone, Does anyone know any way (VBA or Function) to select a "option" and then based on that selection open a desired form. Example: Thanks!

Good day everyone, I have a Text Box at the bottom of my report called Subtotal, which acts as a calculated field: =[InvoiceJobRSF1].[Report]![LabourTotalSum]+[InvoiceJobRSF2].[Report]![CostTotalSum]+[InvoiceJobRSF3].[Report]![TravelTotalSum] InvoiceJobRSF1, InvoiceJobRSF2 & InvoiceJobRSF3...

Good day again everyone. Hope all is well :). I have a strange one. I have a report that shows information from 3 Subforms (linked by Primary key). At the end of the report are some Text Fields running calculations. This is all working smoothly in Report View (Fields in Red are usually...

Good day everyone. Please could you lend a Machete to my intellectual bush. I have an Invoice form that calculates values from 3 tables (Master Fields Linked by Primary Key). However, whenever a single table (Cost in this case) has no records. The Calculation fields stop working. I've...

Hi everyone! Please can you shed some light on my storm of confusion. I want to create a stock control method wherby when a stock item reflects 0 quantity items then it shouldn't be able to be selected for future allocations. I have 2 tables "StockT" & JobCostT". The tables are joined by a...