Search results

  1. I

    Open Report

    Hi When opening a report I am unable to right click on the report as I whish to export the data nto word. Is there code which enables this function!
  2. I

    SQL Statement

    Hi I have this sql statement in some code but it appears not to work. Can any advise if it is incorrect. strSelect = "SELECT ProductDescription, PricePerUnit FROM qryQuote " _ & "WHERE ClientID = """ & Me.cboCustomer.Column(1) & """ AND " _ & "ComparisonDate = " & strDate...
  3. I

    ADO to DAO

    I understood you can only have referenced either ADO or DOA not both!
  4. I

    ADO to DAO

    Hi Here is the original code where I have not tried to convert to DAO. Dim appWord As Word.Application Dim doc As Word.Document Dim rngWord As Word.Range Dim rst As New ADODB.Recordset Dim strSelect As String Dim intMonth As Integer Dim intCount As Integer 'check for null controls If...
  5. I

    ADO to DAO

    The datbase I am currently using has code that uses DAO. Dim appWord As Word.Application Dim doc As Word.Document Dim rngWord As Word.Range Dim rst As DAO.Recordset Dim strSelect As String Dim intMonth As Integer Dim intCount As Integer 'check for null controls 'If IsNull(Me.cboCustomer) Or...
  6. I

    ADO to DAO

    Hi I am trying to convert some code I have found from ADO to DAO. Can anyone advise how this code should be converted! rst.Open strSelect, CurrentProject.Connection, adOpenDynamic
  7. I

    Minus Figure

    Hi This is probaly really easy, I want to identify just minus figues in a query ie -5.00. I have tried iif([TotalPrice])<0,[TotalPrice]) this shows no result. Can any one advise. Thanks in advance.
  8. I

    SQL Statement

    Hi I am using this code but the sql does not seem to work, can anyone help! Dim strDate As String strDate = Forms![frmComparison]![cboComparisonDate] strSQl = "SELECT * FROM qryTest WHERE qryTest.ComparisonDate =" & strDate
  9. I

    trusted SQL SERVER connection

    Hi I am using code to create and relink to ODBC tables. Is there a way to set the 'use trusted connection' to yes by using code, as I have to manualy select 'Yes' each time the code is run!
  10. I

    Update Sage Tables

    Can anyone advise me on how, or where I can find info on how to update tables in Sage Line 50 from Access. I would like to automat the process of creating POP and SOP in sage from my DB. Thanks in advance!
  11. I

    Unbound Text Box

    Hi Brian Yes thats correct!
  12. I

    Unbound Text Box

    The idea is when a letter is input the code is called to update the Recordsource of a form to create a search. I have put it in the On Change Event.
  13. I

    Unbound Text Box

    Hi I have a unbound text box on a form. I am using code to complete a search, each time a letter is input into the text box the code runs. My problem is that I am only able to input one letter in the text box. Has anyone any ideas why this is! Code I am using: Function FilterForm()...
    • IanT
    • Thread
    • Replies: 5
    • Forum: Forms
  14. I

    continuous form

    I have a continuous form which I have placed a unbound text box. For some reason when I place a value in the box it duplicates the value in all the correponding records! Any ideas why!!
    • IanT
    • Thread
    • Replies: 1
    • Forum: Forms
  15. I

    SQL Statement

    Hi Can anyone see why this sql statement errors! Thanks in advance! strNewRecord = "SELECT * FROM qryFurnitueTypesForm " & _ "WHERE qryFurnitueTypesForm.supplier" & strSupplier & " AND qryFurnitueTypesForm.fil1" & strType & "" & _ "AND qryFurnitueTypesForm.fil2" & strFil2 & " AND...
  16. I

    Data Manipulation

    Hi Shadez The original data is in Excel. I have attached example of data imported into Access.
  17. I

    Data Manipulation

    Hi I have data which looks like this: Type: Band1: Band2: Band3: Chair 10.00 15.00 20.00 Stall 20.00 25.00 30.00 I would like to arrange the data to look like: Type: Price: Chair 10.00 Chair 15.00 Chair 20.00 Stall 20.00 Stall 25.00 Stall...
  18. I

    Continuous Forms Loop

    Hi Have been trying to find a solution with-out success! I have a Continuous Form, I need to check the value of a particular field for each record that appears on the form. Obviously the code I have at the moment only looks at the first record. Can anyone help!!!
  19. I

    Command Button

    I used the frame wizard.
  20. I

    Path

    Hi I am trying to us a variable in a path without success, am I missing something! picPath = "R:\CapitalGoods\ProductImage\strProdCode" Thanks In advance................
Back
Top Bottom