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

    This query does not assign 1, 2, 3 SELECT abc.LastName, abc.SSN, DCount("ssn","tblsstudents","ssn<=" & [ssn]) Mod 3 AS C FROM abc GROUP BY abc.LastName, abc.SSN; Results Frank 555-55-5551 1 Sam 555-55-5552 2 Homeboy 555-55-5553 1 Would like the Mod num to be 1, 2, 3 and...
  3. PJHAction

    Need report to separate records

    Actually sounds easy, I will try on Monday at work. Thanks so much. Peter
  4. PJHAction

    Need report to separate records

    OK,I can see how to get the total records from query, but now to get a report for 3 groups is the problem. Peter
  5. 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...
  6. 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...
  7. PJHAction

    I need to get a desired result from a query

    That did it, Thank you very much. Does this site have a feedback section? I try reading the code but I guess experience in using it will help. Peter
  8. PJHAction

    I need to get a desired result from a query

    OMG! That is sooo close, the results are grouped perfect, status (completed or due is perfect) just getting one error msgbox (Enter Paramenter Value, tblPEvals.Evaldate)and results have Evaldate as Expr1 as blank. SELECT tblPPersonnel.SSN, tblPEvals.EvalDate...
  9. PJHAction

    I need to get a desired result from a query

    Greetings, this is where I am at SELECT tblPPersonnel.SSN, tblPEvals.EvalDate, IIf(DatePart("q",Date())=DatePart("q",tblpevals.evaldate),"Completed","Due") AS Status FROM tblPPersonnel LEFT JOIN tblPEvals ON tblPPersonnel.SSN = tblPEvals.SSN; **** Make a query showing the SSNs, Evaldates...
  10. PJHAction

    I need to get a desired result from a query

    I tried what fneily stated and it was a quick fix but I still had duplicates. I am close on the pwise option, the select worked great but my join has issues The first part worked: SELECT tblPPersonnel.SSN, tblPEvals.EvalDate...
  11. PJHAction

    I need to get a desired result from a query

    I will look over this on Tuesday. BTW, I have always been impressed on the help I receive, thanks. Peter
  12. 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...
  13. 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...
  14. PJHAction

    Copy record to another table

    My concern was having a table slowed down due to too many records, if that is not an issue, then I will just add a field for CurrentEmployee. Peter
  15. 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...
  16. 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"...
  17. 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
  18. PJHAction

    Auto Fill them fields

    Thanks for the direction, I used Autolookup in query, man you really need the thinking cap on for this one. Pete
  19. PJHAction

    Create EXE from main switchboard

    First, place your database where everyone can get to it, mine are in a server with a folder named &quot;databases&quot;. This is the backend and will only contain tables! Lets say this is &quot;Apartments&quot;. Copy the existing backend (call it Apartment Interface&quot;), this is the...
  20. PJHAction

    Create EXE from main switchboard

    Mike Did you try looking at your database in a stored/user model. I manage multiple Access databases by keeping the database tables (called backend) on a server/shared drive and the database forms/queries/reports (frontend) in a different file. With this the data stays in one place and the...

Part and Inventory Search

Back
Top