Recent content by movaheditabrt

Hi Dear Friends ! I've got a problem in my access 2007 database. In my office, I have to print invoice reports on pre-ready papers. So the place of every printed object should be fixed. my problem is that whenever the list of sales icons increases or decreases in Detail section of report, the...

Hi there! I have a combobox in a form that connected to price table. There are 20 products in that table, but in this form, I need just 5 products to be shown and selected among them. for example, I want the combobox to show just product01, product04, product11, product17. The question is : Is...

Thank you so much spikeple and Steve R.

Hi guys! I'm going to design an access database for an LPGas company. This company sells LPGas and LPGas cylinders. Suppliers: 1.AlfaCylinder supplies it's cylinders(not the same kinds of cylinder as ME's) 2.MECylinder supplies it's cylinders(not the same kinds of cylinder as Alfa's)...

I wrote in the query this expression: tPrice: IIf([SaleID]= 6001 Or 6003 Or 6004; DLookUp(IIf([Datefrom] <= [datef] <= [Dateto];DLookUp(DLookUp(IIf([distancefrom] <= [distancef]<=[distanceto];DLookUp([price];"pricetbl";[distancefrom] <=...

Thanks for your reply. I changed field names. Let you know that: We have many agents that distribute our product. The price of product is variant according to Sale-ids of agents, cities of agents, the condition of the road (difficult or easy to pass), distances of agents from our company, and...

Hi there! I'm really new to access. I'm using access 2007. I've studied about table,query and form and know nothing about macro and vb. thus, please help me regarding my knowledge of access.I have three tables: agentstbl : [agent-ID] , [name] , [sale-id] , [distance] , [town] , [impassable]...