Search results

Im trying to make an invoice, Im trying to autofill the products name using a dlookup The ProductID1(2,3,4 OR 5) is selected from a list in a form and is sourced from "Products!ProductID" =DLookUp ("Products!PName","Products", where "ProductID1" = "Products!ProductID") How do i make this...

Hi there, I am stuck with using a DLookUp whilst making an invoice style report. I am using 2 Tables "Transactions" & "Products" with Fields : TransID ProductID Product1 ProductName Product2 ProductPrice Product3 ShippingPrice Product4...

I am wanting to make a text box on a form, to return a number (amount of records returned by a query) basically so if the query returns 5 records, the text box on the form will show"5", Lets say the form is called "A", and the query is called "B" How do I put this in the source control of...

Can I make a macro in access that will take data from a customer table. So Find the customer > press a button > To put this data in some way so that I can print address labels. taking the data from the fields named (FirstName, LastName, Address) At the moment I am copying and pasting the data...

Im tryin to add 5 items together to get an overall total Text44 Text46 Text47 Text48 Text49 These text boxes already contain expressions to gain me the subtotals. Im wanting to get an overall total but using just "=[Text44]+[Text46]+[Text47]+[Text48]+[Text49]" Gives me a blank box and...

Right, I have two Tables .. One Customer, One Transaction Fields in Customer: C-ID CName CAddress Fields in Transaction: T-ID P-ID Date C-ID CName CAddress How do i create a situation so I can select C-ID in the Transaction Table and it fill the CName and CAddress fields for me. I have...