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: *

  1. pauldt123

    Removing record navigation bar on sub-form

    Hi Toby, View the subform in Design View, right-click in the top left-hand hand corner of the form (thus selecting the form), select "properties" and set navigation buttons to "no". Thanks Paul
  2. pauldt123

    Record order in continuous form

    Thanks for the swift replies guys, a star for each of you for your help. I'd already tried ORDER BY comments.date Descending, so close and yet so far! Thanks again Paul
  3. pauldt123

    Record order in continuous form

    Hi guys, Quite a simple one I think (but evidently not simple enough!). I have a continuous form which displays records from a comments table, at present the form displays the oldest record at the top and the newest at the bottom. How would i go about reversing the order so the most recently...
  4. pauldt123

    Report formatting

    Sorry guys, I was unaware of the Reports forum. Thanks for your replies. Paul
  5. pauldt123

    Report formatting

    Hi guys, I've got an annoying recurring problem with a report. It's a simple report, displaying some boolean fields and some date fields, all from one table. It's set to preview in landscape orientation in design view, to accomodate the large number of fields. Basically, the first time I launch...
  6. pauldt123

    Update Query that checks if a record exists

    Hi Randy, When I hover the pointer over the companyid2 part of the code it already returns the expected value, so I don't think the problem lies there. I tried the single quotes and it threw up a compile error "Expected: expression". Any other suggestions to get this one working? Thanks...
  7. pauldt123

    Update Query that checks if a record exists

    Hi Randy, I tried that code but it's returning a runtime error 2001, "you cancelled the previous operation". I've pasted the code I've tried below. [Cast ID] is the customer ID, and "companyid2" is the textbox on the main form which contains the company ID of the currently selected company...
  8. pauldt123

    Update Query that checks if a record exists

    Hi Randy, Thanks for the reply, but as far as I can tell, the above is merely checking if there is an existing record in the issues table, with a customer ID that matches the currently selected customer. I need the code to check if there is/are any existing matching records (as the above code...
  9. pauldt123

    Update Query that checks if a record exists

    Hi guys, I was wondering if anyone could help me with the following: I have a form which is driven by a "select customer" combo list. Within this form there is a child form linked on customer ID which enables a user to raise an issue relating specifically to that customer. This child form is...
  10. pauldt123

    Selectively populating a Combo List

    Sorry for the delay in replying I've been distracted by about 100 different things. Your advice was extremely useful, I modified the SQL you suggested and it did the trick. Thanks again
  11. pauldt123

    Selectively populating a Combo List

    Thanks kjv1611, I'll give that a try.
  12. pauldt123

    Selectively populating a Combo List

    I have a 4 table layout; Answers, Teams, Project, Questions. Project is linked to Answers by Project ID, Teams is linked to Answers by Team ID (Answers has a composite key of Project ID and Team ID). Team ID is also the primary key for Questions and is linked to teams. At present I have a main...
  13. pauldt123

    Associating selected information only, between 2 linked tables

    I would greatly appreciate any advice on the following: I have a 3 table layout; Teams, Answers, Project. Teams has primary key of TeamID. Project has primary key of ProjectID. Answers has composite key of TeamID and ProjectID. Teams and Project are linked to Answers but not to each...
  14. pauldt123

    Updating a field based on two criteria

    Thanks for all of your help, I feel I may need to clarify my objectives a little. Essentially I need an update query based on a Dcount of the number of teams associated to each project, and a Dcount of the number of teams who have ticked "response" for each project. If the two are equal "signed...
  15. pauldt123

    Updating a field based on two criteria

    Thanks for the suggestions, I tried running the SQL query and it returned the following error message: "Unknown". Any advice? Thanks again
  16. pauldt123

    Updating a field based on two criteria

    SeeThru, Thanks for your help, I'm still struggling slightly though. I assume that the if statement is the calculated field, having tried it the syntax is apparently incorrect (operand without operator), although I can't see where the error is. Does anything spring to mind? Thanks again for...
  17. pauldt123

    Updating a field based on two criteria

    Any help would be greatly appreciated, I have a three table layout: Teams (TeamID, TeamName) Project (ProjectID, ProjectName,signedOff) Answers (TeamID,ProjectID,Response) "Teams" (TeamID primarykey) and "Project" (ProjectID primary key) are linked to "Answers" (ProjectID, TeamID composite...
  18. pauldt123

    Creating forms filtered on two criteria

    Thanks for your help, it's working perfectly now.
  19. pauldt123

    Creating forms filtered on two criteria

    I've just set up the unbound combo for team selection, and already have a combo for project selection on the same form. The record source for the mainform is the Project table, when I come to link the subform I can't link the master/child on both Project ID and Team ID because Team ID doesn't...
  20. pauldt123

    Creating forms filtered on two criteria

    Thanks for your swift reply PHV, I really need visibility of all activity by project. How would I go about keeping Project as the mainform, and having individual command buttons for each team, linked to their own form which would display the relevant questions for that team and that project...

Part and Inventory Search

Back
Top