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: peciam
  • Content: Threads
  • Order by date
  1. peciam

    Form with two list boxes how to pass selections to report

    Hi to all, I have a form with two list boxes(miltiselect). First box I want to allow user to select one or many offices, second box I want user to be able to select one or many job titles. My code below works ok when one selection of office and job title, but not working correctly when...
  2. 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...
  3. 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...
  4. 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...
  5. peciam

    Form Question

    Hi, The user has changed/added more items to what I thought was a completed item. Here's the setup: Form was designed to select a Office, using a listbox from a table. Same form they added a listbox for jobtable, linked again to a table. There is a seperate report for each job title, 12 in...
  6. peciam

    Selecting Many School Districts to print reports on

    Hello to all, I currently have a form that allows a user to select a school district and then previews that school districts data in a report form. That has worked fine for a while now. We are starting to get large requests in and we now want to be able to batch process the lot. Allow the...
  7. peciam

    Relate based on part of a field(like)

    Hi, Can you create a relationship from one table to another based on only part of the field? Example = Table 1, Field name = "Berlin TA" Table 2, Local Name = "Berlin Teachers" I want to link based on "Berlin" Thanks, TC
  8. peciam

    Update Query

    Hello to all, I have two tables. I want to update a field based on the name. Problem is the name in table 1 and the name in table two are not exact matches. Example: Table 1 = Name field= Berlin Teacher Assoc., table 2 Name Field = Berlin TA. I want to take the local number from table 1...
  9. peciam

    Report based on a query for Office, one or all

    Hi, I have 10 reports that are based on a different queries. When that report is selected I want the user to be able to select one office and get the results or all offices and get the results. I have an input in my query, but now I want to have one form that has a list box of the office...
  10. peciam

    Need Help with a parent/child report

    Hello to all, I have a parent table, main contract information. And then a child table for salary data for each year the main contract covers. A one to many. I want to develop a report like this: Clerk/Typist Salaries County District 2005-06 2006-07 2007-08...
  11. peciam

    ListBox as blank to start and Currency as blank to start

    Hi again, Great site, great folks. Users want to handle data entry this way: A yes or no choice for a field, but they want it to be blank first, how do I do that, field options? Currency field, want it to be blank when starting data entry. Thanks, TC
  12. peciam

    Best way to delete a record on a sub-form

    Hello to all, Have a parent table with a child of salary data. The main form has the parent record, sub-form has the salary data for that parent. What's the best way to allow users to delete a sub-form record? Thanks, TC
  13. peciam

    ranking query question

    Hi, I want to know how I can update a rank field with the results of my ranking query. Here's my query statement and it works great when displaying the query. ranking: (select count(*) from Tab_tc where [percent_L3_L4] >[emp1].[percent_L3_L4];)+1
  14. peciam

    Development Best Approach Question

    Hello to all, I am at a developers block or just stuck, or maybe just stupid. With that said I have a question(s)on best approach method. Users have a collective bargaining agreement(CBA) database. It lists info about the CBA, years covered, who CBA covers, type, etc. They now want to add...
  15. peciam

    Why a subdatasheet

    Hi, Here's a questions that may sound dumb, but here goes. Why use a subdatasheet? Why not just link two tables? Thanks to all that reply. TC
  16. peciam

    Brand new looking for suggestions

    Hi to all, Very new to access 2003. I'm looking for suggestions on how to approach this assignment. Here's the setup: Table in access that contains Labor union contract information, name of local, county, regional office, type, years contract covers, etc. User now wants to add salary data...
  17. peciam

    Master Form with a condition if subform is available

    Hi To all, Here's the question: I have a master contract table, it contains information about the contract, years covered, local type ext. I have a field(Yes/No)called teaching assistant in the contract table. I have been tasked with creating a salary table now that would contain salaries for...

Part and Inventory Search

Back
Top