Jump to content


  • Posts

  • Joined

  • Last visited

About VICH

  • Birthday 10/23/1987

Profile Information

  • Slogan
    Teenage Prodigy

VICH's Achievements

Rising Star

Rising Star (9/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. you could do this using conditional value lists instead...might be alittle cleaner and will help with learning relationships also. you end up with two fields. the first would be the body location. the second types of surgery. the types of surgery change based on what part of the body you choose. http://fmforums.com/forum/showpost.php?post/170316/ that post is what helped me learn to do it.
  2. assign each employeeID its own color...that way regaurdless of the order the colors are always different just a thought though B)
  3. two options. set up the month(get(currentdate)-1) calc. but then have set it to some like if(month(get(currentdate)-1)=1;"January"; if(month(get(currentdate)-1)=2;"Febuary"; if(month(get(currentdate)-1)=3;"March";..... so on and so forth.... but the last line would be if(month(get(currentdate)-1)=0;"December";"")))))))))))) the second option would be monthname("1/"& month(get(currentdate)-1) & "/" & year(get(currentdate)) both of those should work.
  4. close as possible is kinda like new house options: extra bedroom, extended living room, tray ceiling in the master bedroom. predesigned house options: extra bedroom, extending living room. the only thing the origional house would be missing is maybe one or two options worth. ive been asked to set the find up as almost a check list of all the options they need. as those options are picked the list of possible matches becomes smaller. the catch is that lets say there are options a, b, c, d, e new house has a, d, e, a pre existing house that has just "a" would be considered a match. or one that had a, b, d if the house didn't include a, d, or e it shouldn't show up at all but if it has atleast one of those 3 it should
  5. where i work we have job folders in draws. its a building company so each folder is a house design. each house design has options. when ever a new design is being made with its own set of options the designers go to the drawers and find a folder already made that is close a possible to copy and work from. how could i go about setting that up.
  6. from that explaination... i see... each game being its own record. with a point value feild and a win/lose feild for each player. then with scripting have the appropriate values subtracted from everyone considered a loser and added to the winner. do you think something like that could work for you?
  7. the portal is absolutly the right tool. once the self join is set up relating the committee to committee, you can use the go to related record script step to click on a portal row and go to the that individuals record.
  8. timestamps. you times have to be attatched to dates. that way you can actually get the correct amount of times. have calc fields that are formated as 24 hour time to get totals as opposed to an am pm time. then just have a sum field of all the calc fields.
  9. does it matter that i have the summary field placed in the body of my layout
  10. but i want to add up all that = 1 i can't do a total of "Y".....can i?
  11. mine is actually set up exactly like yours but my summary field doesn't update....automatically...and sorry i can't post my file right now
  12. i have a summary total field, i want it to show a grand total. the field that i am totaling is a calculation field that equal 1 or 0. if all 3 records = 1 then the summary should read 3 on all of them. if 2 of them =1 it should read 2...etc. when one of them change the total doesn't update itself accordingly. what could be wrong...and what could i be missing. other info: its not a report its just a standard record view and i need a count of how many records meet the check requirements
  13. if i were to do that what would i have choose to exclude those? i would assume strict data type...but letters only isn't an option
  14. is it possible to tell a field not to allow certian characters. i know i could set up a filter...but i need the users to not even be allowed to in put characters like / @ & any help is appreciated
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.