Search results

hi there, i can't remember if I posted this, but if so, I DEEPLY apologise. I have a query which searches a label of a track via a form with a text box. what I need to know is, if we enter text in this box, how can i make the query search PART or ALL (really PART) of the inputted text. so if...

hi there. working on a project of my own. i have a main form/table with all information made a query that searches for tracks made a form based on this query made another form, with a text box and a button, so when u type in the name of the track to search for, it goes and searches it. all...

yeh, tyvm :)

:cries: lol thx.. :rolleyes:

hmm...ok it's just that, I can't figure out how it's gonna work cause when the manufacturing department puts in new products, they have to enter the qty availible...so other ppl know how much is gone/left etc... and all the availible stock is then told in the purchases subform/form and...

hm well, it should belong to a table cause it's gonna b in the database, the product details form has a certain qty availible/made and then this is taken to the products purchased form anyway, another way round?

but it technically belongs to that table/form. so, what else can be done? i mean, surely there is a way, even using vba on the text box? or something?

k, thx, n e more suggestions folks, post here :)

ftp://temp:temp@techftpserver.co.uk/mdffc1.zip basically, when the customer has ordered QTY of 4 for a product, to take away that from the total stock BUT...it shouldn't do it ALL the time, when we move from record to record, ONLY when the QTY of the product ordered has been changed, will it...

there is also no updateTo cell? and also, what would the name of my subform be? will it just be the same name as the original form? (that is going to be put in as subform)

I don't think that will work for me, it may do the same thing but I would then have to update the form and make major changes? like add new fields or start again? :confused:

hi there. in the order form database I have, it has number in stock of product, eg 100. this figure comes from another form (so it's a subform) what i need to know is, if we order 4 (qty = 4) I know how to subtract that from the number of stock, but would it not subtract it every single time...

ok cool, what about, telling that field to display it in currency and rounded to 2 dec places?

it's ok..sorted :)

it's ok..sorted :)

hmm..using the original query i am working on, i can't find the unique values when i go to view > properties.

hi there. in a query, how can I add a "non existant" field, where it can do a calc, for example, the sum of all prices or something like that. i have like a total price/order value and need to calculate commision, of lets say 10%. what do I put in a field in the query design view?

hmm...ok, but where is this unique value? what happens if I need to put in additional info, such as customer number and price and also customer name?

orderdetails? I can't find that...

thx. cause if emp1 takes 1 orde (order 52), this order has 2 item, it shows order 52 2 times...y?