Recent content by pauldt123

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