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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: EastCoast
  • Content: Threads
  • Order by date
  1. EastCoast

    Multi-plot single line custom grouped chart in Access Report

    I have 4 columns of data in the same table (Min, Mid,Max, Salary). I am trying to create a chart that plots these 4 on the SAME line going horizontally across so basically it would look like a line with four different "X" marks. The value also needs to display. Example below - note that the...
  2. EastCoast

    Convert String to a Number/Cur?

    Issue: I am trying to create an Average field (in the group footer)for a field called "Evaluation Scores" (which is in the Detail section). Problem: The field is a String type (the choices on the eval are 1,2,3,4,5 and "N/A" - the evil string part) so I cannot run any summary operations on it...
  3. EastCoast

    SELECT DISTINCT from different Table

    Hello, I have a "Courses" table and a "Classes" table (1 to many relationship - 1 Course = many Classes). The problem is in my "Classes" Form. I want the "CourseName" field from the "Courses" table as a DISTINCT dropdown box inside my "Classes" form. Example: If I offer a course in...
  4. EastCoast

    Auto populate same field across different forms

    I have the same "ID" field in my 1st form and my 2nd form. When I click on a cmd button to go to the 2nd Form, the "ID" field on the 2nd form needs to automatically populate itself with the same "ID" that was in the 1st form. Example: "ModelID" in the "Models" table (the 1st table) equals "10"...
  5. EastCoast

    Synching the same field

    I have a "Class" form with a field on it called "ClassID" and a cmdbutton on the same form named "Evaluations". When I click on the "Evaluations" button, I need it to take me to the "Evaluations" form (that part is working). I also have the "ClassID" field on the "Evaluations" form and I need...
  6. EastCoast

    Where Condition Macro not linking

    I have a Macro that is attached to a button on a form. When clicked, the button should open up another form that is linked by the ID field. Here is the code I typed into the "Where Condition" section of the macro: [ID]=[Forms]![Products]![ID] When I click on the button, it goes to the form...
  7. EastCoast

    Linking a field (not a subform)

    <b>The Setting:</b> I have a "Classes" form and an "Evaluations" form whose underlying tables are 1 (Classes) to Many (Evaluations). The Classes form has its own subform and the Evaluations form has its own subform. <b>What I would like:</b> is to click on a button on the Classes main form...
  8. EastCoast

    Fields from 2 tables displayed in Form without using Subforms

    I have a "Courses" table and a "Classes" (every occurence of a course)table. I want to display a few fields from the "Courses" Table on the "Classes" Form. I don't want a subform because that would show one course and then every occurence of that course on that screen. What I need is for each...

Part and Inventory Search

Back
Top