Search results

I am alsready to use my new database .I need to get rid of training data.,not shure how to do this .Saved it as a template with option to remove data ,seems to have worked ..Now luanched database .Is this correct RE 10 commandment When i want to update my working data base from the prototype...

Hi Bob checked out North wind Very informative but i cant see the orders form on the left hand side can see the table and i have had a good look at the relationships thats also very helpfull

Hi Bob I will do that Currently on my oderdetaild sub form as well as having the products ordered ect i also continue with fields that say for EG ordered wth supplier who took order and date order placed and chec boxes for order placed and order in stock .Should this information not be stored...

Hi Bob that makes perfect sense Its back to the drawing bd and start again Many thanks for your help and thanks for keping it easy to understand John

Bob if i am understanding you I have a table orderdetails.These records show in the order details form and the sub form fields are also in the order details

Thanks Bob you are of course rite. However i have now noticed that if i try to alter the sub form in design made.I get a message saying something like the data base canot get a lock . Is this the problem Many thanks

Many thanks guys I dont think it can be any of those becouse i would have had to have changed something in the property sheet?I think The form was workink ok after entering 2 records usually new is displayed in the next line down this iswhat is not happening .I did look in the details table...

Hi just launched my data base after much testing and all seemed ok However Its gone wrong I have a orders sub form that was working great .Then all of asudden when i whent to input information into the fields i realised the grid under variuos field names has disappered (Icant enter any...

i have a table orders details with a sub form displaying the order, i have a combo box to display the product from products table to place in the sub form products box .I keep getting the eror message join key of table details not in record set I have checked my relationships and for keys and...

Thanks for the answer .But i dont know what you mean .I am very new to access .What is query syntax?

I am trying to lean how to do queries,But every time i run one .Acces says i have anbiguous outer joins .Does this mean i have joined my tables incorrectly

In the North wind database In the orders box subform they have a totals cost box underneath how do they do this

Thanks bob sorted

Hi I have a combo box to show bring up the cost of my products .Although it shows the correct prices in the combo box ,when i select the cost it posts an entirely diffrent cost in the apropriate field.It seems to be posting the product id number witha £sign in front of it Thanks for all your help

I have created an orders form with sub form for details .I have to put a combo box on subform to obtain products but this will only alow me to put the product name in the products field i also need to get the cost in the form field .How do i do this Thank you

Many thanks or your help bob

I have all my forms and tablles ready to go except my order details form not sure hoe to do this.The orders details form in northiwnd looks great but i suspect it is complicated .I am very new to access and need to keep it simple All help welcome

very informative many thanks john

Many thanks for that I am very new at this .What is the control source property What is the bound coloumn Allso i find if i hide the id column as recommended i dont get to see the customers name just id.s Sorry to be so dim

I use a combo box to add customers to my orders table via a form I notice the orders table customer id is not updated IS this OK? If not how do i also update this field from my form .I want to see the customers from the combo box