User Profile

Collapse

Profile Sidebar

Collapse
acoppini
acoppini
Last Activity: Aug 13 '10, 10:30 PM
Joined: Jun 18 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • acoppini
    replied to SQL Syntax for Strings in Select Queries
    in Visual Basic
    Hi Veena,

    Thanks for your help. I tried your suggestion but got the following error - any ideas? Copy of the new code below:

    Run-tim error '3075'

    Syntax error (missing operator) in query expression '(((z_RatingsBy Issuer.Issuer_N ame)='Reader's Digest Association, Inc.'))GROUP BY z_RatingsByIssu er.Rating_Ratin gType_ID,zRatin gsByIssuer.Rati ng_Rating_Type_ Name'

    Code:
    Dim mySQL3 As String
    ...
    See more | Go to post

      Leave a comment:

    • acoppini
      started a topic SQL Syntax for Strings in Select Queries
      in Visual Basic

      SQL Syntax for Strings in Select Queries

      I need help! I think that my problem is one of syntax using strings. Specifically I have defined a string field called issuername that I am later trying to use as an input into select queries. I have tried different syntaxes because I believe I need to use the & operator in SQL to let it know that it is searching for a string. Despite trying several approaches I have not succeeded. Any ideas? My code is below: Thanks, Adrian

      ...
      See more | Go to post
      • acoppini
        started a topic Using a stored variable in an SQL select query
        in Visual Basic

        Using a stored variable in an SQL select query

        I am trying to use string variables LIN and Portfolio defined from a recordset recControl in VBA SQL Select Query in Microsoft Access 2003. My syntax must be wrong as I keep getting a Syntax error. Can someone help?

        Code:
        LIN = recControl!LIN_Number
Portfolio = recControl!Portfolio_Name

Dim mySQL5 As String
mySQL5 = "SELECT TempAPT.*, TransactionTypes.TranType"
mySQL5 = mySQL5 + "
        ...
        See more | Go to post
        • acoppini
          replied to Creating an Index in a Table
          in Visual Basic
          Figured it out - need to use autoincrement as field type:

          Code:
          strSql = "ALTER TABLE TempAPT ADD COLUMN Ind AUTOINCREMENT"
CurrentProject.Connection.Execute strSql
          See more | Go to post

            Leave a comment:

          • acoppini
            started a topic Creating an Index in a Table
            in Visual Basic

            Creating an Index in a Table

            Hi - I am trying to create a unique index in an existing table that I will be able to use later to update records. I have the code below. The index Ind field is being created in the table TempAPT but it is not populating with an index. A simple index starting at 1 and growing at an increment of 1 for each row will suffice. What am I doing wrong? This is in VBA Access 2003. Thanks

            Code:
            Public Sub addColAPT()
DoCmd.SetWarnings
            ...
            See more | Go to post
            • acoppini
              replied to How to narrow a recordset by date range
              in Access
              haha - you are awesome - i will try this out when I am back in the office on Monday - thanks so much!...
              See more | Go to post

                Leave a comment:

              • acoppini
                replied to How to narrow a recordset by date range
                in Access
                Thanks colintis,

                tradedate is a variable I define in VBA to store the tradedate of the first sell records. My goal is then to use tradedate as a condition to select all preceding buy records.

                I don't quite understand the use of the [#"&] - can you explain further?
                See more | Go to post

                  Leave a comment:

                • acoppini
                  started a topic How to narrow a recordset by date range
                  in Access

                  How to narrow a recordset by date range

                  I have been trying to select a recordset that filters on a text field for all records in the source table that are <= a specific date that I tried to specify earlier in the code. The select works fine without the AND date condition, but fails every time whenever I try to add a date.

                  My code is below - any help you can offer would be great. I am new to this. Thanks Ozy

                  Code:
                  Dim db As Database
Dim recTest
                  ...
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...