Search results for query: *

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

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

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

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

Thanks, I will give it a try.

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

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

1. The data in [ResultCALC] are all data type double and can be either positive or negative. When the value is negative, it allows for a format to be applied in XL after the data are exported. Negative numbers are used to indicate "<" For example -0.0005 would be formatted in XL to display...

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

Thanks Duane, worked great. Wendy

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

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

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

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

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

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

Hello, I have modified the structure of my database a little bit and now I am faced with removing duplicate records from a table. The two tables I'm working with are joined 1(tblAnalytes.pkAnalyteID)-to-many(tblResults.fkAnalyteID) as described below: tblAnalytes tblResults...

Morning, I have this query that works correctly. INSERT INTO tblWizTempALS ( SAMPLENUM, CLIENTID, MATNUM, SMPDATE, PCODE, METHOD, ANALYTE, RESULT, ResultFixed, Symbol, UNITS, QUALIFIER, RComments ) SELECT tblWizTempWDS.SAMPLE_NO, tblWizTempWDS.STATION_NO, tblWizTempWDS.SAMPLE_MATRIX_CODE...

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

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