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 Chriss Miller 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. wvandenberg

    Prefix first Column Header with #

    I have a stored procedure that builds a dynamic query. I would like to prefix the first column header with a pound sign (#) but the following does not include the # in the final SQL string. Please note that the first colomn is intended to be filled with an empty string. Current select portion...
  2. wvandenberg

    NotInList Selects Different Page on Tab Control

    Yes, the command button with this code works to select the page.
  3. wvandenberg

    NotInList Selects Different Page on Tab Control

    OK, I re-jigged my code and am still getting the same error. Here is my new code Private Sub cboClient_NotInList(NewData As String, Response As Integer) Dim rstClone As DAO.Recordset Response = AddToList(Me, "tblClients", "Client") If Response = acDataErrContinue Then...
  4. wvandenberg

    NotInList Selects Different Page on Tab Control

    Hello Everyone, I am having trouble with code for a NotInList event. Here are the details of my form. I have a main form (frmMain) with a tab control (tabMain). On Page1 of tabMain, I have a subform. In the subform I have a bound combo box (cboClient). I am trying to capture the NewData...
  5. wvandenberg

    Item to append containing square brackets not appending

    Thanks, I will give it a try.
  6. wvandenberg

    Item to append containing square brackets not appending

    Hi all, I have a query that checks one table against another then appends any missing items. However, if a missing item contains square brackets (eg. Benzo[e]pyrene), then it is not recognized as "missing". Could anyone suggest how to fix this problem? Here is the SQL: INSERT INTO...
  7. wvandenberg

    Data type mismatch in crosstab

    Sorry for the late reply. I thought for sure it was going to work but alas, sadly it did not :-( I'm pretty sure there is no way to have both double and text data formats in the same column yet treated as double and text where applicable. It just resulted in the same problem as my original...
  8. wvandenberg

    Data type mismatch in crosstab

    ...records (different analysis methods) and I need to output the Max value. 3. The sql for qselWizExpResults2Sort SELECT qselWizExpResults1Select.*, IIf([UnitsID]<>[fkReportingUnitsID],ConvertUnits([ResultValue],[UnitsID]),[ResultValue]) AS ResultCALC...
  9. wvandenberg

    Data type mismatch in crosstab

    Hi all, I have a crosstab query TRANSFORM Max(IIf([P_GroupID]=7,IIf([Symbol]=">",Replace([ResultCALC],"-",[Symbol],1,1),Val([ResultCALC])),Val([ResultCALC]))) AS Result SELECT qselWizExpResults2Sort.P_Analyte AS Analyte, qselWizExpResults2Sort.P_Group AS [Group], qselWizExpResults2Sort.Unit...
  10. wvandenberg

    Undo Togglebutton click

    Thanks Duane, worked great. Wendy
  11. wvandenberg

    Undo Togglebutton click

    Hi all, I have a toggle button and have implemented the following code in the BeforeUpdate event: Private Sub tglDate_BeforeUpdate(Cancel As Integer) If Not ApplyCriteria Then Me.tglDate.Undo Cancel = True End If End Sub The problem is that the togglebutton stays...
  12. wvandenberg

    Query performance slow

    Remou: TempVars is a new collection for storing global variables (added to Access 2007). From the Help file: "To refer to a TempVar object in a collection by its ordinal number or by its Name property setting, use the following syntax form: TempVar![name]" [TempVars]!{Samples} contains a...
  13. wvandenberg

    Query performance slow

    Hi all, Just wondering if anyone may be able to suggest a way of making this query run faster? SELECT DISTINCT Month(Nz([StartDate],0)) AS Expr1, MonthName(Month(Nz([StartDate],0))) AS Expr2 FROM tblSamples WHERE (((InStr("," & [TempVars]![Samples] & ",","," & [pkSampleID] & ","))>0)) ORDER BY...
  14. wvandenberg

    Select query using TempVars as criteria

    Sorry, I should have mentioned that I'm using Access 2007 and TempVars is a new built in global variable. However, I tweaked your suggestion to SELECT DISTINCT tblSamples.SampleName, tblSamples.pkSampleID FROM tblSamples WHERE InStr("," & [TempVars]![Samples] & ",","," & [pkSampleID] & ",")>0...
  15. wvandenberg

    Select query using TempVars as criteria

    Hi all, I have a select query where I use a TempVar item as the criteria. SELECT tblSamples.SampleName, tblSamples.pkSampleID FROM tblSamples WHERE tblSamples.pkSampleID In ([TempVars]![Samples]); [TempVars]![Samples] contains a string and tblSamples.pkSampleID is a long integer. Possible...
  16. wvandenberg

    Update foreign key of duplicate records

    Thanks, that's just what I needed to get going.
  17. wvandenberg

    Update foreign key of duplicate records

    ...tblAnalytes.pkAnalyteID HAVING (((tblAnalytes.AnalyteName) In (SELECT [AnalyteName] FROM [tblAnalytes] As Tmp GROUP BY [AnalyteName] HAVING Count(*)>1 ))) ORDER BY tblAnalytes.AnalyteName; I created another query, joining the "Find duplicates for tblAnalytes" and tblResults SELECT...
  18. wvandenberg

    Rewrite SQL to make query faster?

    ...ON tblSamples.pkSampleID = tblResults.fkSampleID) ON tblSites.pkSiteID = tblSamples.fkSiteID WHERE (((tblSites.SiteName) Like "AB0" & "*"))]. AS A ON tblWizTempWDS.MEASUREMENT_ID = A.Comments WHERE (((A.Comments) Is Null)); I was just wondering if anyone had any suggestions on how I...
  19. wvandenberg

    Crosstab query headers are duplicated

    Sorry for my slow response. Thanks for everyone's suggestions. Remou, after changing the PIVOT, I found that "Sample:" & [SampleName] was causing the problem. Thanks
  20. wvandenberg

    Crosstab query headers are duplicated

    TRANSFORM Max(IIf([GroupName]="Toxicity",IIf([Symbol]=">",Replace([ResultValue],"-",[Symbol],1,1),[ResultValue]),IIf([fkQualifierCode]="X","-" & [DetectionLimit],[ResultValue]))) AS Result SELECT [_qselExpResultsSorted].GroupOrder, [_qselExpResultsSorted].AnalyteOrder...

Part and Inventory Search

Back
Top