Search results

Hi All, I'm using a stacked bar chart driven off a simple query. It has 15 groups (bars). Everytime I run it, the first bar is reporting incorrect data!! But it is only the first bar, all the rest are fine. It is even different from the accomanying datasheet (in design view). Please, please...

Hi guys, The below SQL statement returns a requirement name and the SUM of the number of number of tests run in each test related to that requirement for Release 10. To filter on a particular release, I need to convert this statement into an equivalent INNER JOIN because 'Tests_run' isn't the...

Hi guys, What would be the syntax of a join query when you have multiple joins, and need one of them to filter with a 'WHERE'? E.g. SELECT Table_A.Name, Table_B.Age, Table_C.Address, Table_D.Gender FROM Table_A LEFT JOIN (((Table_B ON Table_A.Name=Table_B.Name) LEFT JOIN (Table_C ON...

Hi guys, My database is accessed by several users. When the user opens my report it first makes a table of temporary data from one query, then uses another query on that table to populate my report. The problem is, when another user wants to view the same report, I get a table lock problem -...

Hi guys, My database is accessed by several users. When the user opens my report it first makes a table of temporary data from one query, then uses another query on that table to populate my report. The problem is, when another user wants to view the same report, I get a table lock problem -...

Hi, Is it possible to access a tables data over multiple joins? For instance, for each row of Table A, I want the associated data from Table D. Is this possible in access? If it's not, could you suggest an alternative? Please see the example. Many Thanks. SELECT Table A.Person_Name, Table...

Hi guys, I'd like to set the controlsource of a subform's textbox. The subform is continuous. I declare an sql query on form load and wish to dynamically bind the fields from that query to the various objects on the form. Here is my code so far. Dim alpha As String Dim strSQL As...

Is it possible to update the "Source Object" of a subform dynamically? I'm using the below code to open an "edit" form based on a double click in some filtered results. I want to display the form that opens as the source object of a subform, is that possible? Private Sub...

Hi guys, I'm trying to print a report without actually viewing it and I've been messing around with this statement: 'DoCmd.RunCommand acCmdPrint' Is there anyway you can pass a report name to this command so it knows what to print (if printing what you're not viewing)? I would simply...

Hi Guys, Background: I have a continuous subform within a form. The continuous form is used to display search results. Each search result (record) has a checkbox at the end to (hopefully) allow the user to select it to enter that record into a listbox which will allow the compilation of a...