Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by clackl

  1. clackl

    Create email with a command button

    We have a database which we use to accept referrals from a peripheral source. They fill in the form with all the referral details, then send an email via outlook to let us know that the details have been entered into the database. Is there a way of using a command button on the access database...
  2. clackl

    Setting limits in a caculated field

    I am wondering if it is possible to take this one step further. I think I need to use a different example to make it clear. If a medication is prescribed according to weight, then by multiplying weight by dose we get the daily requirements of the patient. But if the medication is only...
  3. clackl

    Transferring ID numbers to multiple forms for one subject

    The form comes up blank.
  4. clackl

    Transferring ID numbers to multiple forms for one subject

    I have a database where I keep extensive records for individuals. These involves one main demographics form with a unique ID number. The rest of the information is kept in a number of individual forms accessed by control buttons on the main form. However each time I access the forms via...
  5. clackl

    Setting limits in a caculated field

    Perfect. Thank You.
  6. clackl

    Setting limits in a caculated field

    Thanks for the prompt reply. The forumula I am using to round to multiple of 5's is: IIf(([num] Mod 5)>=3,[num]+(5-([num] Mod 5)),[num]-([num] Mod 5)) When I tried to use the formula that you had given me it highlights the comma after the 3 and gives the error message "You have entered an...
  7. clackl

    Setting limits in a caculated field

    I have a calculated field in a query which I use to calculate postage according to weight. This has code in it to round the figure up or down to the nearest multiple of 5. What I would like to be able to do is to set an upper limit of 40 to the result that the calculation produces. So that no...
  8. clackl

    Rounding whole numbers to multiples of 5

    It works perfectly. Thank you so much for your help with this. Lynn
  9. clackl

    Rounding whole numbers to multiples of 5

    I am sorry I forgot to check with you GoDawgs where you would enter this piece of code? I am afraid I am still finding my way around Access and realise this may be a stupid question, but I appreciate your help with this.
  10. clackl

    Rounding whole numbers to multiples of 5

    Thanks for this. I will be working on the project again tomorrow and I'll try this out.
  11. clackl

    Rounding whole numbers to multiples of 5

    I have created a query with calculated fields that I have set to only display whole numbers. Is there a way of also asking the calculation to round the result to multiples of 5?
  12. clackl

    Automatically entering data into a field on a form

    Mostly the layout would look something like this: Table 1 Client ID (PK) Number Firstname Text Surname Text Address1 Text _ _ _ Table 2 Client ID (PK) Number Date (PK) Date/Time Contactname Text Problem1 Text _ _ _ However some of the tables need to generate...
  13. clackl

    Automatically entering data into a field on a form

    Thanks for these comments. In fact I obviously didn't make it quite clear enough, most of the tables are jointly linked on client id and date, as we hold more than one entry for each client in the related tables/forms. So they are one-to-many relationships. However it is just the client id...
  14. clackl

    Automatically entering data into a field on a form

    I have a database that keeps various sets of information about my clients. The unique identifier for each client is used to link up these sets of data, which are held in seperate tables. So for example I have a client demographic form which has several control buttons that then open other...
See more

Part and Inventory Search

Back
Top