Recent content by ria.arora

  1. R

    Run-time error 3061 - Too few parameters. Expected 1

    That's the one which I posted in my first post SELECT tbl_Bankers_Mapping.[GMIS Revenue Producer], SUM([Qtr Annuity Income]) - SUM(NZ([Qtr Annuity Oneoff],0))/3 AS [QtrAnnuity] FROM tbl_Consol_Monthly_Revenue_Split AS CMR INNER JOIN tbl_Bankers_Mapping ON CMR.[Private Banker] =...
  2. R

    Run-time error 3061 - Too few parameters. Expected 1

    using below syntex Set rsTmp = gsPnPDatabase.OpenRecordset(strSelectSQL)
  3. R

    Run-time error 3061 - Too few parameters. Expected 1

    Hi Paul Yes I'm able to run the query from Normal Access Query window and got correct result as well.
  4. R

    Run-time error 3061 - Too few parameters. Expected 1

    Dear All, I'm having wiered issue with one of my SQL. Below SQL I'm executing from VBA, which is throwing error "Run-time error 3061 - Too few parameters. Expected 1" SELECT tbl_Bankers_Mapping.[GMIS Revenue Producer], SUM([Qtr Annuity Income]) - SUM(NZ([Qtr Annuity Oneoff],0))/3 AS...
  5. R

    Set the size of the form in Access 2007 using VBA

    Hi Aleni, This works. I'm wondering why it's not working when I use Tabbed documents. Thanks for the help.
  6. R

    Set the size of the form in Access 2007 using VBA

    Form is displayed on full screen. It's not taking the size I have defined. Please find below the code Private Sub Form_Load() On Error GoTo ErrHandler gsCurrentFormName = Me.name DoCmd.Hourglass (False) varStatus = SysCmd(acSysCmdClearStatus) lblStatus.Caption = ""...
  7. R

    Set the size of the form in Access 2007 using VBA

    Dear All, I'm trying to set the size of the form in Access 2007 using VBA using below code but this is not working. This was working in Access 2003. On Form_Load() I'm calling method PositionForm DoCmd.MoveSize 100, 100, 600, 600 This is not working not sure why. I have set Auto...
  8. R

    Conditional Formatting

    Dear Bob, I tried .Value = -0.1 OR >1 also tried .Value = -0.1 OR .Value > 1 but it's giving error.
  9. R

    TransferSpreadsheet - Unique Requirement

    Dear All, I'm creating new workbook and worksheet through ACCESS VBA (MS Access 2007). After creating new worksheet I'm extracting data from ACCESS and writing into the sheet. After that I'm creating new sheet and trying to transfer ACCESS query resultset to new created sheet. I'm stuck over...
  10. R

    TransferDatabase Access to Access with WHERE condition

    Hi Bob, Thanks. This is working perfectly. Any idea about conditional formatting? http://www.access-programmers.co.uk/forums/showthread.php?t=232706
  11. R

    Conditional Formatting

    Dear Bob, I want to add one more condition in existing code. If value is less 0.1%(means it's negative) then also want to show GREEN instead of RED. Sub setRAGStatusFontColorIconException(strRange As String) Dim objISet As Excel.IconSetCondition...
  12. R

    TransferDatabase Access to Access with WHERE condition

    Thanks. I'll try this and let you know.
  13. R

    TransferDatabase Access to Access with WHERE condition

    You mean that is the only solution we have. Not sure how much time that will take to insert 100K - 150K records. Any other solution?
  14. R

    TransferDatabase Access to Access with WHERE condition

    Dear All, I'm transfering data from one Access Database to another database using TransferDatabase method using below code: Set oDB = Application.DBEngine.OpenDatabase(strNNASourceDatabasePathNName, False, False) Set objApp = New Access.Application objApp.OpenCurrentDatabase...
  15. R

    Extract SUB String using SELECT Statement

    Hi All, How to extract a portion on based of search criteria from a Column string using SELECT statement. I have a table with below structure: Table A Structure ============= Name Description Transaction Value Name: James Description: Redemption: MMTIME AUD, 3.295%, 25.07.12-01.08.12...
See more
Back
Top Bottom