Search results for query: *

Sorry, I did not get Remou first post but you are both correct. Thank you

Set statement is the third line and space does not seem to make a difference. When code runs it runs through the connection open and then loops back up to where the sql statement is created.

...Set rst = New ADODB.Recordset Dim strSQL As String Dim dteInDate As Date Dim dteOutDate As Date strSQL = "SELECT * FROM [qryTrackingData_EndTimes]" strSQL = strSQL & "WHERE [UserID] = '" & Me.UserID & "'" strSQL = strSQL & " AND [SystemDate] >= " & "#" &...

You should be able to stop prompting the user by simply using reportname.printout False

I have a grid with multiple bands that need to be sorted. When using rs.sort it is only sorting band 0 and I need to apply the same sort on all bands.

Thank you both for the quick replies, I have been scratching around trying to get this and all along it was because my field was an int so it was always rounding down. Thanks again!

Could someone give me an idea of how I can round numbers to the nearest five in a select statement? Thank you, Any help would be appreciated.

Thanks for the response. The period is included in the path variable and CO_NUMBER is alpha numeric. Any other thoughts would be appreciated.

Another clue in this puzzle is that when I replace CO_LN_NO with "001" it works fine.

I have already tried using a one long string with no sucess and I believe the last "&" is need to concatenate the closing ".

This is my sql statement: stsql = "SELECT CO_NUMBER as CoNumber,CO_LN_NO as Line,COMP_WC as Parent,COMP_WC as Item, " & _ "ITEM_DESC as ItemDesc,QUANTITY as AuthorizedQuantity, COMP_PRICE as ListPrice, QUANTITY as OriginalQuantity FROM " & strKnzFSDataSQLPath & "FSExtract_HCPCFG WHERE CO_NUMBER...

Thank you both for the quick response. Took you advice and replaced my code with the Replace() function and of course it works like a charm. Thanks again

I am using this code to find line breaks in a string of text retrieved from our ERP system and replacing it with a carriage return on my report. Dim strNotes As String Dim strFormatNotes As String Dim intEnterPos As Integer Dim i As Integer strNotes = Me.COLIN_XTXT ReDim strTemp(0) As...

Thanks for the quick response. Your response was correct and I appreciate you pointing out the errors of my ways.

I have this sql statement in a module strSQL = &quot;SELECT SUM (IVC_QTY * InvoiceUnitPrice)AS Sales&quot; strSQL = strSQL & &quot; FROM tblSalesDbMaster&quot; strSQL = strSQL & &quot; WHERE IVC_DATE >= &quot; & dteBegin strSQL = strSQL & &quot; AND IVC_DATE <= &quot; & dteEnd Set rst =...

I have a user with Outlook 2000 client (with SR-1 (9.0.0.4201) and the security update installed) that also hangs on exit. We are using Windows 98 SE on the front end. On the back end it is a Microsoft Exchange Server Version 5.5 Build 2653.23 Service Pack 4 running on a NT 4.0 server with...

Thanks for the response. I have played with those functions but was unable to make them work.

I have a form that users enter order numbers in to find them. This form has only one field that the user can enter into. I would like to make it select everything in the field after the user enters the search criteria. I have tried setting the focus on this field and have also tried doing a...

Chris, I would be interested in the app you mentioned. Please e-mail to lwilliams@norwood.com

Still nothing, I believe there is something in this database that will not allow this. I have other Access databases that I have no trouble with. Thanks for your help.