Recent content by mshirwan

How to check those? How to check those measurments, , and is that 11 cm? or 11 inches?

My report alwats prints an empty page when printing, this should be trivial to you guys but it is doing my heading. any ideas?

many thanks that worked fine, thank you Dont know why i havent thought of that, as i have used the tecknick for filtering data into a combobox on a form.

make a search on the forum I saw something similar on this form, an example, make a search u will find it, make search for something like linked combo boxes

Does anyone know how to run a query from form and set the query parameters to fields in the form. This is what I have a query that have a date between start date, End date, I want to be able to run it from a form and set the query paramiters from the start date field that I have on the form...

the record gets deleted I already setup proper relationship with cascading deletion, so it does gets deleted. What I wanted to do is not even save it to the table to start with. but I guess i am use to SQL Server transactions, were u can undo the transaction altogether.

Re 2 for £5 promotion Well the company's policy is that if you buy 1 it is £3, 2 is for £5, 3 is £5 + £3 = £8, and so on. I ended up doing another product called 2 for £5 promotion of original product.

could someone tell me how to do an undo record save? I have an order form based on a query, the problem that I have it saves data in the sub forms when I do the undo save record, using a button.

Re 2 for £5 promotion that works for even no. not odd, If they chose 3 for ex, it will be a hassle to select it, it will be 2 different products? that will be confusing

hi all I have a order system like the one in Northwind db, the problem that I have is need to implement 2 for £5 offer on one product, any ideas on how to do that?

Does anyone has an example of an automated stock control? please let me know

that worked Thanks mate, that worked fine, I though it would be a built in function

Does anyone know what is the function for rounding a number to the nearest integer, I tried int() but this does cutting, i.e. cuts the fraction bit. any ideas?

It does work I think I developed so much of the project to change it. but on a positive note it does work on a multi user usage as i tested it. thanks for the responds guys

I have an order table that stores orders from different supplier, but how can I have a different order ID for different supplier of product that increases serialy. i.e general order id for all orders which i have. another order id for orders by a specific supplier.