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: *

  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?

    I put in exactly what you have. Not working still. I get the same error message as before. To create this formula I created a new field from the field list. Perhaps my table links that I created when I chose my data source is the problem? I appreciate the help, I can't think of what else...
  3. EastCoast

    Convert String to a Number/Cur?

    That field is a string field - it had a [25] which I assume is the field size. It has values in it of 1,2,3,4,5 "Fast", "Slow", and "N/A".
  4. EastCoast

    Convert String to a Number/Cur?

    I created the field, put it into the details section to test and got the following information dialog box (the only button this box gave me was the "OK" button to acknowledge the message below: "A number, currency amount, boolean, date, time, date-time, or string is expected here." It let me...
  5. EastCoast

    Convert String to a Number/Cur?

    I used your code but didn't get it to work. if isnumber({STUDENTEVALS.EVAL_ANSWER}) then val({STUDENTEVALS.EVAL_ANSWER}) else 0
  6. EastCoast

    Convert String to a Number/Cur?

    Thank you. I have Crystal 8.5 and it is a Sybase Database I am connecting to.
  7. 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...
  8. EastCoast

    SELECT DISTINCT from different Table

    That makes sense. I think discussing this has helped clarify some things for me. The reason I had the same course listed multiple times in the Courses table (even w/o the Levels field) is because I have distinct description, length, prerequisites, etc. for each individual course. Given what...
  9. EastCoast

    SELECT DISTINCT from different Table

    Thanks. I did separate the skill levels into a separate table already (which solved one issue) but still did not solve the issue of pulling in the CourseName field from the Courses table into the Classes form and displaying each CourseName distinctly in the dropdown.
  10. EastCoast

    SELECT DISTINCT from different Table

    I did try the DISTINCT option as well, but then I had to change the ColumnCount and ColumnWidth to display only one column (CourseName) but then whatever I choose in the dropdown arrow ("Typing" for example, is entered into every class for every record - it doesn't just choose "Typing" for that...
  11. EastCoast

    SELECT DISTINCT from different Table

    Yes, I think you understand my predicament. Each CourseID is different. Ex: For the course "Typing Intro" the Course ID is 1, for the course "Typing Intermediate" theh Course ID is 2. I have done distinct rows using a field from the current form (current underlying table), but never a field...
  12. 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...
  13. EastCoast

    Auto populate same field across different forms

    Hi Eupher, I put in the two lines just as you typed them. The first line in the OnClick event of the cmd button on the 1st Form and the second line of code in the OnOpen Event of the 2nd Form. I got an error for the 2nd line of code. Here is the line it highlighted: Me!ModelID = Me.OpenArgs
  14. EastCoast

    Auto populate same field across different forms

    Okay - I think I get the second line of code, but where do I put the first line (the "DoCmd.OpenForm...")? Is this attached to an event or just write it in VBA. (VBA is not my strong suit yet).
  15. EastCoast

    Auto populate same field across different forms

    Where do I type this? In the macro or in the field itself (which property of the field if it is the field?)? The 2nd form is supposed to open on the click so it is supposed to be opened and populate together.
  16. 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"...
  17. EastCoast

    Synching the same field

    One other thing to be aware of. My "Evaluations" form is a main form with a subform as well, so when I click to go to the "Evaluations" form, it will show me the Evaluation type and then in the subform show me everyone's eval scores so every eval in theory will be tied to that ClassID field. I...
  18. 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...
  19. EastCoast

    Where Condition Macro not linking

    Here is the code that is in the "On Load" property of the second form (EvaluationType): [Forms]![EvaluationType]![ClassID]=[Forms]![Classes]![ClassID]
  20. EastCoast

    Where Condition Macro not linking

    I did that - when I go to open the 2nd form now, it gives me an error message: Access can't find the Macro 'Forms!...and the rest of the phrase for the code

Part and Inventory Search

Back
Top