Search results

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.

More details please That is interesting, how does that hidden form work

What is the best way to forward data from one form to the next and then to the next, i am currently doing it by saving the data into user defined data types, but my worry is it might not work when i go into a multi user usage. I am saving userid, amd customerid and supplier id, into variables...

Thanks that worked That was good it works fine

Can anyone tell me how to make sure that the cursor is at the begining of the field when a field gets focuse By the way it is a text field on a form

Hi all I have an order form similar to the one of Nothwind sample db, the problem that i have is when data entered to the form there is not way of undoing the data since there is two subforms that store data in different linked table, any ideas? I am still waiting for an idea.