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!

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

    Form Closes if Enter is Pressed

    I made a parameter form that works great, but when the enter key is pressed it will close the form. I would like the OK button (vba routine) activated if the enter/return key is pressed. Is this easy to do? Peter
  2. PJHAction

    Need report to separate records

    I query a class by class number (08-027), but now I want to break that class down by A, B, or C Group based on number of students in query, this week it could be 80, next week 110. What I am looking at. - Run a query to pull everyone in that class (08-027) - Based on the class size (lets say...
  3. PJHAction

    Table Normalizing

    Creating a new DB to track students. I created a Table with like 25 fields for personnal information etc. I also created a Table with 20 fields to track scores for events with a one to one relationship. Question is should I keep the tables split with a one to one or should I just throw them all...
  4. PJHAction

    I need to get a desired result from a query

    I have some knowledge on VB, just need help solving a routine, I cannot get the desired results in Access query: Scenario: I have two tables in Access that I joined, Left outer join to select all names and then my sub table all of the evaluations (1 per quarter). I need an access rpt to state...
  5. PJHAction

    Need help writing select statement

    I have tblpersonnel with SSN (Join one) to tblEvaluations with SSN (many) and EvalDate (1 per quarter) End result, I need to know who has not received an evaluation after a certain date. I want to select All records in tblpersonnel and only records in tblEvaluations where the date is null or...
  6. PJHAction

    Copy record to another table

    I have a database for personnel, the problem is they rotate in and out, so I want to move people who left to a history table. I have an access table of personnel with two related subtables. My thought is have a macro delete the records from the sub table then select the record from the...
  7. PJHAction

    Networking

    I put a network together with 4 computers, using a name in the workgroup to see each other. 3 computers see each other just fine. My problem child - 1 computer: I run through the wizard and it finishes, but Windows XP says the workgroup is not available when I click "View Workgroup computers"...
  8. PJHAction

    Removing profiles or files (Registry?)

    I have a Lab where students log into W2K to a server, which in-turn creates a profile for them. This fills up my hard drive with profiles and Temp Internet Files. Can I set the Registry to either delete the profile or delete the Temp Internet Files when the user logs off. Pegte
  9. PJHAction

    Auto Fill them fields

    Point me in the right direction! I have a table of names of people and a table of restraunts. I want to pull up the person which is already assigned a city by a field, I need the city information filled in on my form (like Zip, Restraunt name, telenumber") to be filled in. Not sure if I...
  10. PJHAction

    Lost/Got Focus

    I have a Form, lets say it is Form1, on it is SubForm2 and SubForm3. I am trying to tab key from SubForm2/Field6 to SubForm3/Field1. How do I get the Focus option to work. Pete
  11. PJHAction

    Autofill Date Fields

    When I fill in a date field call one, how can I have field two, three and four filled in automatically based on date one. I do not want to use Action Query, they will affect my complete table! Pete

Part and Inventory Search

Back
Top