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

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

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

    VBA Excel Import text file

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

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

    Subform Record is changing

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

    Forms randomly requerying

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

    Forms randomly requerying

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

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

Part and Inventory Search

Back
Top