Search results

I have a form which needs to have the location of stock entered into it. It should look like this when its done L-06-B-R - can i format it so that you only have to enter a single figure when it is below 10 and it puts a 0 in front of it eg. enter l6br and it reads L-06-B-R. The current mask is...

All sorted and working fine as a form - thanks for your help.

Hello, It is for entering purchase orders - It draws the information from tables and writes them to another table. In form view it all shows fine but when I print or do a print preview nothing shows apart from the header and footer.

A form. It is a purchase order with all supplier details in the header, product details in the detail and totals etc in the footer. When i print it it shows the supplier details and the totals but not product details.

The problem was solved when I removed the page numbering. But now when i print it doesnt show any of the detail - just the header and footer...

Hello, I have an access form that won't print or print preview. It just takes ages saying formatting and doesn't do anything! Any ideas??

Thanks, How do i get that to display in a cell in a form?

Hello, How can i return the name of the computer currently using a database into a form field? Many Thanks

Sorted! =DLookUp("=[" & [Customer Ref].[Value] & "]","Sheet1","[Reference_Number] = [Combo100] and [Price Breaks] = 'SMALLS' ")

I'll try explain this a bit more clearly! I have got a table with the following fields: Reference Number(Product Code), Price Break(Smalls, 1plt, 5plt, 10plt, 26plt etc), then all the customer account numbers (eg BON001, GNE001, SCR001 etc). I have then made a form based on this table so that...

The reference number is returning fine as it it is - that is linked to the "combo100". i was wanting to link the first part ("[BON001]") to a combo box ([Customer Details]![Combo104]) which contains the customer account numbers so that when i put the customer name in, it will automatically look...

Sheet 1 has a list of product codes on the left and the fields are all named by the customer account number. when i open the form i want to put in the customer account number and product code which will pull the price for that customer and product. the reference number refers to the product...

I am using the following expression to look up prices with 2 criteria: =DLookUp("[BON001]","Sheet1","Reference_Number]=[Combo100]and[Price Breaks] = 'Smalls' ") Is there any way I could put the cell reference of a combo box where it says "[BON001]" so that it returns the prices for the...