Search results

If [status] = "order recived" then msgbox("error") exit sub else end if end sub

I have tried it but it will run the code nomatter which option the status fiekld is set to. If [status] = "order recived" then etc etc but it runs even if the status is set back to awaiting delivery

how can I stop a record being changed after it is changed to a cirtain value? my senario is this: a shop has an order table one of the fields is status. the status can be [order recived] or [awaiting delivery]. I have code that updates the amount in stock when the field is changed to order...

what can I do to make it only import data which is correct. I know I have done this before and I am pretty sure it will generate another table with the data which can not be entered.

sorry I misunderstood you, if mothers will have differant fields to those of fathers then you need two tables.

one table would seem to be fine then

it depends on what you want to do with the data. ir would help if you are more specific

I have a field in a table with the input mask LLL0000;0;_ when I use an append querry to put data in the table it still puts in data which does not follow the input mask. Is there some tick box I have not checked or somthing because this is getting really annoying. All help really appreciated.

thanks for the advice.

yes, but it's opportunity cost: I will be better off learning about things which I know I will do in my exam rather than learing about things which will help me use access but not raise my grade. I know this might seem a very monetary way of looking at it but I am not planning on following a...

thought of that but I am doing an an exam for a specific exam board. I think it is differant in the USA but I have to know specific things about access. It would be a waste of time to do a test for things that I will not have to know in my exam. Thanks anyway.

I'm not doing one this minuet but I would still appreciate help. the exam is in the UK and with AQA. does anyone know of any sites which will give me tasks to do to test myself. Thanks in advance:D