Search results

  1. J

    NA option value

    I have an option box items 1-10 and want to add an NA option. On the NA option value, I want to put NA, but it says "the value you entered isn't valid for this field". I know this is happening because it expects a number. I do not want a number, I want to Enter NA or leave it null. Is this...
  2. J

    Avg in Report Footer

    How do I go about adding an average field in report footer that will give me the average of all the scores. Thanks. jwood29
  3. J

    Close Event, Clear All Fields

    What would the code look like for Form Close event to clear all fields, except my prepopulated today's date field. Mainly I want my text box Evaluator: to not have persons name from before. And the Employee to be null or blank in the drop down list. Thanks in advance.
  4. J

    Combo Box Move To Next After Save

    I have Category Combo Box with: "Professional Dev" "Quality" "Quantity" "Appearance" "Time Managment" I would like to have my category combo box move down to next one in list after clicking Save button. Can someone get me in right direction for code on this. Thanks in advance. jwood29
  5. J

    Sum or average of user eval_score

    I have an Admin form that I need help with getting sum and/or average from two different tables. How would I go about getting a text box to display Sum or average of users evalution scores. Table: User user_name Table: Evaluation eval_score Table: Admin Form: user_name combo...
  6. J

    combo data highlighted displays txt from another table

    I have a combo box that when highlighted I would like to have it display description from another table in a text box. What would the code look like for this on click or after update. Thanks all. Example: Combo Box highlights "Quality of Work" (pulled from cat_name) Text...
  7. J

    Options Click: Display Free Text in Text Box

    I am trying to use an option group that has radio buttons 1-10, that when clicked it will display free text into another text box that I have. 1 and 2 would say: Needs Improvement 3, 4, 5 would say: Satisfactory 6,7,8 would say: Above Average 9 and 10: Superior. What would the code for...
  8. J

    Query pass to Report

    I have a query that has parameters that are on a form. I can get the form to work via entering parameters and return correct data to the query. But how do I then get that query to return the results to a Report. I have it setup to when I click the Report, it pulls up the Form, where I enter...
  9. J

    Query with two combo boxes, Null?

    Not sure if this would go in the queries or forms section, but here it is. I have query that uses parameters from a form. My problem is on the form I have two dropdown combo boxes and they both need to be populated with data otherwise it returns No Data at all. How do I make it where I can...
  10. J

    Combo Box Keep Data on Command Execution

    How can I keep the initial elected data on a combo box drop down present after I click Save. It would be nice to keep. For instance User, Donald Duck goes to the Ticket Form and Enters an older date like 5/1/08, chooses his name, Project, Hours, and Notes. Clicks Save. That days Ticket...
  11. J

    Form Query parameter Issue

    Help. Please, can someone take a look at this project. I cannot get my TicketForm to work correctly with TicketQuery. I get NO returned results, but when I run the query by inputting data (e.g. 5/1/08 , 5/13/08 , Mall , Goofy ) I do get returned data, and the query is working correctly. It...
Back
Top Bottom