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!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Crosstab query in Teradata (nothing to Sum)
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...- Picard012
- Thread
- Replies: 0
- Forum: NCR: Teradata
-
InfoPath / Access 2003 - VBScript SQL (update query)
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... -
VBA Excel Import text file
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...- Picard012
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Forms randomly requerying
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...- Picard012
- Thread
- Replies: 6
- Forum: Microsoft: Access Forms
