Search results

  1. T

    Combo / Drop down in a query

    Perhaps I have not phrased my question very well, I am very much a novice so perhaps I do not make it very clear. I would like, from a form, to be able to select a Country, once I have selected the Country I would like to be asked to input a weight which would produce a result based on details...
  2. T

    Combo in a Query

    Being new here I did not realise this was a transgression, I thought that the question had changed suffeciently enough to warrant a new thread. I shall however consider my wrists slapped and attach the zip to my orginal post. Cheers Tig
  3. T

    Combo in a Query

    Perhaps I have not phrased my question very well, I am very much a novice so perhaps I do not make it very clear. I would like, from a form, to be able to select a Country, once I have selected the Country I would like to be asked to input a weight which would produce a result based on details...
  4. T

    Combo / Drop down in a query

    Sorry, Tried all day but I can't see the wood for the tree's. I have tried many things and this is the most promising but it still doesnt work 1. I have made a query and then made a form based on it. I have then opened the form in design view and changed it to make it a combo box. The query...
  5. T

    Combo / Drop down in a query

    Thanks but! (isn't there always a but) Being new can you tell me where that statement needs to go? I opened a new query double clicked 'country' from tblCountry and then typed [FORMS]![COUNTRY]![COMBO2] in the criteria box but no joy I also tried [FORMS]![frmCOUNTRY]![COMBO2] I know I am...
  6. T

    Combo / Drop down in a query

    Hi, this is probably simple but how do I make a field in a query into a selectable drop down? I have a table upon which I have based a simple query that asks a user to type in a country and a weight which produces a rate and a transit time. Looking at it though the user will have to be a good...
  7. T

    Multiple query

    Hi Paul Thanks, but this is similar to how I have it already on my form, apart from taking up so much room it does not allow me the flexibility to go above 10 cartons. I don't know too much about Access but I do understand that one of the principles is not to store useless information, which...
  8. T

    Photos on forms

    On the MS office tips website you can download a copy of the Northwind db that shows the employee details along with a photo. MS allows you to rip the code etc. Tig
  9. T

    Multiple query

    Good Morning (UK) I work in the freight forwarding industry and the airlines charge us freight on weight or volume whichever is the greater. The airline formula is LxWxH divided by 6000. If for example the actual weight is 20 kilos and the calculation resulted in 25 kilos this would become...
Back
Top Bottom