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. mstekkie

    combo box item not being displayed in report

    thanks for the quick response! the occupation field is a part of the query that creates the report. even in the query, it only shows the primary key. is it possible to change the column widths here to display only the occ. name?
  2. mstekkie

    combo box item not being displayed in report

    hi coco86, sorry. i guess i'm not explaining myself properly. the combo box for the occupation is on a form. from that form i've got a button to open a report. and it's on the report that it shows the primary key. i've changed the column widths on the form to only display the name and the...
  3. mstekkie

    combo box item not being displayed in report

    hello, hopefully someone can help me with this. :) i've got a combo box that has three fields: primary key, occupation name, and occupation code. i also have a few reports that require the occupation name to be displayed. problem is, that instead of showing the occupation name, it only shows...
  4. mstekkie

    add item to combo box in alphabetical order

    hi trendsetter, i was able to get it to work using the query. thanks! ms.tekkie
  5. mstekkie

    add item to combo box in alphabetical order

    thanks trendsetter, i got it to work perfectly! ms.tekkie
  6. mstekkie

    add item to combo box in alphabetical order

    the data for the combo box is based on a table. the table contains the primary key (autonumber) and the occupation name. right now, the data in the combo box is sorted by primary key in ascending order. is there any way to change it to sort it by occupation name instead of by primary key...
  7. mstekkie

    add item to combo box in alphabetical order

    hello! i've got this combo box that allows the user to choose an occupation. if the desired occupation is not in the list, the user has the option to add it to the list. my question is: how can i add that new item to the list in alphabetical order? thank you in advance! ms.tekkie
  8. mstekkie

    buttons on a form to display certain records

    there's this one form (the company info form) and it has a link to another form (the employee form). for each company there are up to 4 different test dates, and emps can be tested on any of the four dates. what i want to do is to click on a button to list the employees for that month, and...
  9. mstekkie

    working with strings and substrings

    i'm having a lot of problems with this program. hopefully someone can help me out. the program prompts the user for an equation such as 123 + 123 = what i'm supposed to do is break up the string into four substrings and display each string on its own line. i know how to display the substrings...
  10. mstekkie

    NotInList for combo box not working

    thanks jc, i got it to somewhat work. the error i'm getting now is that it says there's a type mismatch and it highlights the line: Set rst = db.OpenRecordset("tblOccupation") did i miss something?
  11. mstekkie

    NotInList for combo box not working

    i made the change that you suggested. but now i'm getting this error message that says 'user-defined type not defined' and it highlights 'dim db as Database' any idea on how to fix it?
  12. mstekkie

    names in combo box with same number show only the first name

    i've got a primary key for each, and i've redone the combo box. the different names do show up now, but i don't know how to show the occupation number. how do i bind a text box to the combo box to show the number? thank you again.
  13. mstekkie

    names in combo box with same number show only the first name

    i have a combo box that displays occupations, and its corresponding number in a bound text box. for some occupations, they will have the same occupation number. eg. chargehand and foreman both have the code 1234567. what happens is that when i choose foreman from the list, it shows chargehand...
  14. mstekkie

    NotInList for combo box not working

    i have a combo box that lists occupation descriptions, and it has a bound text box that displays its corresponding number. i want the user to be able to add a new occupation. this is the code that i'm using to try to add a new record to my occupation combo box: Private Sub...
  15. mstekkie

    radio buttons to open reports

    thank you so much Linda. i got it to work perfectly! cate :)
  16. mstekkie

    radio buttons to open reports

    GLS, the wizard has also included these lines of code, i didn't think they were necessary so i erased them. Dim stDocName As String stDocName = "rptCompanyDate" DoCmd.OpenReport stDocName, acNormal i left the error handling statements in. when i click on the preview...
  17. mstekkie

    blank lines on reports because of grouping

    jim, i did do a keyword search before i posted my thread, and i did read that thread already, but it doesn't help me because my question is different than his, which is why i posted my question. i've already tried the can grow, can shrink options, but they don't work for me. basically all my...
  18. mstekkie

    blank lines on reports because of grouping

    i've got a report which is grouped by category. an employee may be one of the 6 different categories. what i want the report to do is to show the 6 different categories with the percentage of people in each one. what's happening is that the report is leaving blank lines on each page. i've...
  19. mstekkie

    radio buttons to open reports

    Linda, do i keep all the other code that was generated by the wizard? and do i keep the case statements as case is = 1 or do i change them to the name of the option buttons?
  20. mstekkie

    radio buttons to open reports

    GLS - the radio buttons are in an option group. each radio button opens a report. is that what you mean by what event it triggers? jbento - i'm not very familiar with macros. how would i go about doing that?

Part and Inventory Search

Back
Top