Search results

  1. S

    Calculate value by using two combo box values

    Thank you very much it worked like a charm :) really appreciate it
  2. S

    Calculate value by using two combo box values

    Currently what I have is Four cascading combo boxes. IT starts with a minimum value and a maximum value. Depending upon what you choose you then get to choose the name. And depending on the name you get the colour. I want to make it so once you choose the colour it will tell you the exact price...
  3. S

    Creating user login with access

    In regards to my security, it is only for a school assignment so it does not have to be hack proof etc. Is there any simple way you know of that will allow me to do that without getting into too much intricate detail?
  4. S

    Creating user login with access

    Hi, I am quite new to access and I am trying to create a user login. What I currently have is a table with two fields, username and password. I want to be able to type in a username and password onto a form, then click a button and have it check whether the login details i entered match any...
  5. S

    Calculate value by using data from another table

    This is the code that I end up with when I connect the two tables using a common field of RollID INSERT INTO [Stock Ordered] ( [Length Ordered] ) SELECT (50-[Length Remaining]) FROM [Stock Available] INNER JOIN [Stock Ordered] ON [Stock Available].[Roll ID]=[Stock Ordered].[Roll ID]; But it...
  6. S

    Calculate value by using data from another table

    This is the error I get when I try to run it. http://www.uploadhouse.com/viewfile.php?id=2521165&PHPSESSID=b0bd97c60400c9dd40a81d307d9067b1 And if I say yes then none of the information in my database gets changed
  7. S

    Calculate value by using data from another table

    Thank you very much, just one quick question, when you say valuefromfield does that mean the name of the field in which the original number is located? Basically this is the structure of my database concerning this query. Tables - (Stock Ordered) and (Stock Available) Fields - (Length Ordered)...
  8. S

    Calculate value by using data from another table

    Hi there, I am trying to make a query that will grab the values from a field in one table, find the remainder left when it is subtracted from 50, then place that value into another field in another table. Does anyone know how to do this please? It is for a Year 12 assignment so it does not have...
Back
Top Bottom