Search results

Many thanks for your help

Hi Alan Thanks for your time ,I thought just by setting the PK and FK and doing a relationship this would self populate clearly i was wrong . So to clarify if i have a customer and orders table I need to sep a subform for those tables and if i have a orders detailds table do i need to set up a...

Hi i am a Newbee I have a related data base .and thought i was doing ok Now i realise that that the primary key auto no from one table does not appear in the ralated table in the FK field asigned to it . I think this must be wrong .Please clarify If it is wrong what am i doing wrong EG...

Ok think i have got that . In the query editor do i place all the fields from my customer details form that i whish to see on the report ,and all the fields from the surveys form . Is this not going to bring up every record in my customer details table .How do i go about selecting the customer...

Thanks for getting back I understand about creating the query but not shure about the criteria.can you you make it easior to undestand ,sorry

Hi I am a Nebe I have a customer details form which works great I now need a nother form ,if the customer wants a survey carried out I need to print the form with the customers details and survey details What would be the best approach ,I do not want to have to type all the customers details...

Hi bob Thanks for the reply .I cant get my head around the database example.Does this mean i have to have the two combos in the orders sub form

Can someone plese tell me the best way to get a catogory and product details selection to work in a sub form order details table . I have no trouble with a products combo box but as soon as i try to put a catogory combo box in and use cascading combo boxes it wont work .Ican make the cascading...

Hi I have a form with a subform .Ihave cascading combo boxes in the form but want to enter the result from the combo box into a field on the subform. I.have tried setting the row source to that of the subform by using the expression builder .but when i try it out i get a message saying cant edit...

Hi John dont really want to do that .not shure i know how to . But thanks for your help I will study your replies

Hi john That does look very interesting ,but is going to take some time to my head around it .this is my where statement forms!customer new orderdetails].[combopick and it works Is it possible you could you coild give me an examlple where statement . also if i use my current form that...

Hi John I have a customers order table with a subform where i have a combo box to display the products and selec the product . I soon realised i needed a catogories list .as i had far to many products I decided a cascading combo box was the answer .I have spent many hours trying to get this to...

Hi Is it posible to send the selected combo box item to a different table to that from which it resides the form relates to

Hi I now know how to do a simple cascading combo box on the same form .I know need to know how to put the result from the 2nd combo box into a subform try as i may i always get a parameter box

Hi have you done th requerie bit as shown in the example .if you havent that might be the problem .If the 2nd combo happens to be blank when you set it up it will remain blank unles it has the requerie after update

:sorry that should have been top right next to the totals button

I am also new to access and had similar problem . I had inadvertently selected the parameter button on the top left of screen .It may be worth checking good luck

Hi jdraw It works | I have learnt so much from this .I now know a little about sql a liitle on programming and my knoledge on combos vastly improved and I can now look at a querie and it makes some sence I almost gave up but persisted and its all been worthwhile Once agaain many thanks for...

Hi jdraw Thanks so much for all your help I am shure i can now get this to work .I will let you know

Hi jdraw Thanks for taking the time to reply I call the form combo1 as this is just experimental at this stage to get it to work .once i know i have it right i can go to the nest step .I will try what you suggest many thanks