Search results

Hi, I want to update the column qtyOpen from the table InventoryComponent in a condition that the ComponentNumber from InventoryTable and OrderNumber from the CompanyPurchasesDetailsComponents and PackageItem from the CompanyPurchasesDetailsComponents tables meet. I think I am getting there but...

I have a report that displays invoice number with first name, last name, data and owed. An example illustrated below: Invoice # First Name Last Name Date Owed --------------------------------------------------- Invoice # First Name Last Name Date Owed...

I have entered the following code below, but when I run it it doesn't work I a get an error: Public Sub ExportOrderDestination(TableName As String, intNumber As String, YourOrderNumber As String, SalesRep As String, JobNumber As String, Terms As String, inNumber As Integer, valueOrderNumber As...

I have entered the following code below, but when I run it it doesn't work I a get an error: Public Sub ExportOrderDestination(TableName As String, intNumber As String, YourOrderNumber As String, SalesRep As String, JobNumber As String, Terms As String, inNumber As Integer, valueOrderNumber As...

I have a question I need help for, below is a very strict detailed explination of the current scenario I am in and I need assistance for it: 1) I have a percentage of Commission I need to calculate, the percentage of commission constitudes of the following information: a) Date, b)...

This is the scenario I am in: NewClient have one to many relationship with estimate. There is one new client for as many estimates. The new client table holds information of the client, name, address and so on, the estimate table ONLY holds information about the estimate, what evre the case be...

I am having problem specifying App.path in VB using Access, here is the line: DoCmd.TransferDatabase acExport, "Microsoft Access", Path & "MarbleExport.mdb", acTable, "Estimate-Address", "Estimate-Address", False DoCmd.TransferDatabase acExport, "Microsoft Access", Path & "MarbleExport.mdb"...

I have a little problem I need help with. I have two subforms one is called "Estimate" the other one is called "Internal/Invoice". In the estimate subform there is a button called "Export to invoice" when that is clicked the approriate information from Estimate (using SQL statement) is then...

Hello, I have a major problem with the tables I have and the forms. This is the scenario: For every single client info (address and so on) it can have many estimates, many invoices and many internal invoices. This applies for all the three what I am going to say next, but I will use the...

I keep getting the error Syntax Error in INSERT into statement. I don't know why This is the sql statement: Dim intRequest As Integer Dim intRequest2 As Integer Dim strSQL As String Dim intInvoiceNumber As Integer Dim strInvoiceDate As String Dim strName As String Dim intBalanceDue As Double...

I have an invoice set in a lovely form using Microsoft Access. Each of the invoice there is an option on the top called Paid, ones I check the paid it will stamp it as paid, how do I make it such as, it will copy the paid ONLY record into a summary cheat, which is a report? It have to be copied...

I have two tables, one is called Table A and the other is called Table B: Table A contains these data: I II III Table B contains no data in the form of Microsoft Access, I want to be able with a push of a button and DEPENDING...

I have an outstanding invoice, it contains all the necessary information about the invoice, such as the customer name, billing info and so on. Each of the invoice holds the total balance after calculating the taxes and if there are certain discounts to be calculated. By the end of the invoice I...

I have couple of problems I need to be resolved and I hope someone here can be able to help me. I have an estimate (all form designed), that when I click the button export to internal invoice, I want the contents of all the estimate moved to the internal invoice and display the invoice, without...