Search results for query: *

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?

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

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

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

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

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

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

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

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

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?

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?

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.

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

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

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

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

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

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

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?

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?