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

    Form with two list boxes how to pass selections to report

    Hey PHV, Thanks for your help, it worked fine. Now, why did it work? Thanks, Pecia
  2. peciam

    Form with two list boxes how to pass selections to report

    ...to form, report points to query. In my form I have the following: Under office I ahve in the criteria as:Like [forms]![frm_selection]![office]&"*" and under job title criteriaI have: Like [forms]![FRM_selection]![job_title] Here's my code: Private Sub OK_Click() On Error GoTo...
  3. peciam

    Is there a better approach?

    Hi, I hope I can explain. I am able to do the task assigned, but I have started to wonder if I am doing it right, is there a better way. The profile(report) I create has many data parts. Of which come from many files. My link is the school district code, ie. Albany SD is code 010100. I...
  4. peciam

    Is there a better approach?

    Hi, %L1, %l2, etc... they are the field names from the original file. That's part of the question(s), what does set up properly mean? I have read the normalization paper, and many others, taken courses on it. Still not clear when you get a file from the state that has thousands of records...
  5. peciam

    Is there a better approach?

    Hey Ginger, No it's not a one-shot deal, if I undersatand your statement. The user(s) will run the queries when ever they need a school district profile. The english and math is only a part of the whole profile. The reason I have six tables for each test, the original data came in one table...
  6. peciam

    Is there a better approach?

    Hi to all, I am working with student performance data by school district for grade 3-8. The data is both for English and math. The data came to me in one complete table. I had to break it out by school district, type of test, english or math, and then by grade level. So I have 6 tables for...
  7. peciam

    Creating one record for multiple data items

    Hi GingerR, I have a table with 266 records. It contains data for school district teachers total experience and median salary for that experience level. For example: [School District] [Totexp] [Count] [Median] Andes Central school 2 4 31750 Andes Central...
  8. peciam

    Creating one record for multiple data items

    Hi, I need to find a way to create one record for many records for the same school district. I have many records that I get from the state. School district name and total experience and a salary for that exerience. 1 year of experience, count of 3 people, salary of 32,000. Here's the data...
  9. peciam

    Form with 2 list boxs how to pass selections to report

    Well said, by the way I really appreciate your help. I guess I'll just keep plugging away. I have started a 3-ring binder with code snip-ets and notes from lessons learned. Thanks again, TC
  10. peciam

    Form with 2 list boxs how to pass selections to report

    Hey GingerR, Thank you so much for your help! It worked out perfect, I can't believe it was right in front of me the whole time. Is there any reading, books, whatever, that you would recommend to read to get a better understanding of the syntax, and the whole process of how things tie...
  11. peciam

    Form with 2 list boxs how to pass selections to report

    Hi, Thanks I'll try the code. What do I put in my query. The report(s) source is seperate queries. Thanks, TC
  12. peciam

    Form with 2 list boxs how to pass selections to report

    Here's my code, Private Sub OK_Click() On Error GoTo err_preview_report_click Dim title, wclause, RO_name, ro Dim frm As Form, ctl As Control Dim varitm As Variant Dim strlist As String Dim strlsit2 As String Set frm = Forms![frm_srp_sal_ro] Set ctl = frm![Ro_list] 'Build my list of offices to...
  13. peciam

    Form with 2 list boxs how to pass selections to report

    Hi, I'm really stuck! And having a very hard time trying to explain it. I have 12 reports, of which they are all different data items. For instance: Account Clerk salary report, Clerk Salary Report, etc., 12 total different reports. I have figured out how to allow the user to select one or...
  14. peciam

    Form with 2 list boxs how to pass selections to report

    My code is not working. Is my approach wrong. How can I store the selections and then process them? Thanks, Tony
  15. peciam

    Form with 2 list boxs how to pass selections to report

    Hi, I'll try to setup my question. I have a form with a 2 listboxs(multiselect). The first listbox I want to allow the user to select the report to run, 1 or up to 12 different reports. The second list box I want to allow the user to select a office, 1 or up to 16. The report source is a...
  16. peciam

    Form Question

    Hi, Sorry, it would help if I did ask a question. I want to allow the user to select the office(s), one or many or all. Then allow them to run one report or many, or all the reports. The reports would be only for the offices selected and the reports selected. TC
  17. peciam

    Form Question

    ...= "" EXIT_OK_CLICK: Exit Sub err_preview_report_click: MsgBox "Select a report!" Resume EXIT_OK_CLICK End Sub The reports are based on queries: I have this in the queries: Like [forms]![frm_srp_sal_ro]![ro_list] & "*" Each report has a seperate query. Any thoughts much appreciated.
  18. peciam

    Selecting Many School Districts to print reports on

    Hey Instructor, Throw it out! I already have put it to work. Of course I gave you all the credit! Thanks again, TC
  19. peciam

    Selecting Many School Districts to print reports on

    ...you are right I did say a report. I think I'm on to something. I put in my query the form under criteria:Like [forms]![lookup]![sd_list] & "*", I then have my source for the report point to the query. Seems to work, scary! It's nice to have such experts to bounce things off. I'm not too...
  20. peciam

    Selecting Many School Districts to print reports on

    Hi Instructor, Thanks for your help. How do I link the mutli-list to the report? Before I went to a form and then the user could print the form. Here was my code: DocName = "studentpro" LinkCriteria = "[DistName] = Forms![lookup]![Field1]" Forms!lookup.Visible = False...

Part and Inventory Search

Back
Top