Recent content by rob1

tried this, it just returns blank boxes in report view?

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

Ive just tried using a query but it only gives me the option to link [ProductID1] with a [ProductPrice] and [ShippingPrice] what do I do for the other 4 ProductIDs??

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

Hi Isskint, It is definetely the dlookup i was after but i just seem to be having trouble with it. Ive tried the codes that you put but it just shows #Error when I take the form out of design view.

thats perfect .. and yes i want it on a form. Thankyou very much :)

ok ive created a thread of my own, ive watched the video, i still dont properly understand. Is it possible for it to sort of "autofill" the field with the data, in a form screen?

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