Search results for query: *

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

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

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

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

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

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

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

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

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

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

Thanks kjv1611, I'll give that a try.

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

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

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

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

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

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

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

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

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