Search results for query: *

Good afternoon. I am trying to create a crosstab query in Teradata, but virtually everything I see online states to use a PIVOT with SUM. I have nothing to sum, and it doesn't allow for nulls. Basically I am trying to do the following: Customer Coverage --> Customer...

Good morning. I was wondering why I might be getting an error (FROM statement) when I run the following code: Sub CTRL10_7_OnClick(eventObj) ' Submit Button Dim strSQL, MyConn Dim MainAdapter Set MainAdapter = XDocument.DataAdapters("Main connection") 'SQL statement to run apend...

Thank you Skip. I'll give that a try. Picard012.

Good morning people. I am trying to import a text file into my existing spreadsheet tab. If I open a blank spreadsheet, and click File --> Open --> Filename it populated the Worksheet and changes Sheet1 to the filename (eg. Customers). When I do the same thing in code, it creates a new...

Does anyone know if there is a Windows refresh that envokes if you let a link Access DB 'sit' there without entering or changing data? Anything to do with API calls? Thank you, Picard012

What I would like to do is use the Form_current event to test for this record requery. I realize that you cannot test for Me.Requery or Me.Refresh, but there must be a way to capture what event or control is causing the recordset to requery. I am not too proficient with the Debugger, but I...

I believe the form is based on a ODBC recordset and we have it set to 32766. Is there any way to disable this? Can't find any rouge Requery or Refreshes. Maybe I can upload it. Thanks for all the great ideas and suggestions. Picard012

Good morning all. Randomly our DB forms are requerying without rhyme or (known) reason. This making the record jump back to record 1. I want to create some code and store it in the Form's current event. I have the following code: Private Sub Form_Current() Dim Num As Long If Me.Requery...