Results 1 to 8 of 8
  1. #1
    RCBNewbee is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    4

    simple math coding for form field??

    Five numbers inputed into their own database fields by the use of a form



    Judge 1, Judge 2, Judge 3, Judge 4, Judge 5

    I need the high number and low number seperated and put into a their own field with high go in field high and low go in field low.
    Then i be using these fields for other function which i already figure out.

    can anybody help me. VB code or something

    I know this is simple but I am new and only doing this as a hobby
    Last edited by RCBNewbee; 07-11-2009 at 06:49 PM.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Since it is only a hobby, were you looking for someone to do it for you or are you ready to learn some VBA?

  3. #3
    RCBNewbee is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    4
    when i said it a hobbie i don't create anything for other just for myself.(didn't goto school for it, self learn) I allways willing to learn more and I think to get what I want to work it will need some VB coding. I have two projects going.so more i soak up the better it will be.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Can you create a standard function that returns the higher of two values passed to it?

  5. #5
    RCBNewbee is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    4
    I found a MDB file on the web and change feild to macth what i am using.
    It does create the low value and high value, but now i have a problem getting these value in the main Table. if I create a qry i can not update the table. I know I doing something wrong but was up all night trying to find it. if i email you the MDB that i am using could you help?

    Thanks Randall

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    You can just attach it to a post here. When you post, scroll down to the "Manage Attachment" button.

  7. #7
    RCBNewbee is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    4
    Thanks, hope someone can help

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    There is almost always more than one way to achieve a particular result in Access. The method you found has some limitations, however. The controls on your form are not saved to the table until you do so explicitly or move off of the record. Queries can only see fields that have been saved so unless you do the saving, queries are not the answer for you. You of course can do anything you want. It is *your* db after all.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Lookup Form (should be simple)
    By joshlee in forum Forms
    Replies: 3
    Last Post: 05-06-2009, 12:04 PM
  2. Math problem
    By kbrodrick in forum Programming
    Replies: 3
    Last Post: 05-06-2009, 08:56 AM
  3. Simple Nav Form Code Not Working
    By alsoto in forum Forms
    Replies: 10
    Last Post: 04-10-2009, 09:30 AM
  4. Bar-Coding
    By texasprincess7 in forum Access
    Replies: 1
    Last Post: 02-12-2009, 10:29 AM
  5. parsing data in access (coding?)
    By banker247 in forum Programming
    Replies: 0
    Last Post: 01-13-2009, 12:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums