Recent content by sspreyer

  1. S

    Solved how to filter a subform using a combo box to select year on main form but filter a date field on a subform

    Solved it Thanks for the Help [Forms]![MonthlySpendCal]![CVorderQRYsubform].Form.Filter = "Year([Order_Date]) = '" & Me.YearFormTXT & "'" thanks
  2. S

    Solved how to filter a subform using a combo box to select year on main form but filter a date field on a subform

    Hi Bob Me.[CVorderQRYsubform].Form.Filter = Year([Order_Date]) = '" & Me.YearFormcbo & "'" I'm getting an error guessing quotes wrong? Yeah not far at tall :) small world
  3. S

    Solved how to filter a subform using a combo box to select year on main form but filter a date field on a subform

    Hi , here what i've try but getting an error. order date field on my subform is in format dd/mm/yyyy and my combo box on my main form only holds years in yyyy hoping to filter Order_date field on the subform via year. see below what i tried. guessing i need to change the Order_date field format...
  4. S

    Solved Dlookup still showing #error on new record line

    no its a number field txt is just referance for the text box
  5. S

    Solved Dlookup still showing #error on new record line

    spot on !! thank you
  6. S

    Solved Dlookup still showing #error on new record line

    Hi , cant work out why #error is still showing on new record line i thought Nz() would supress it ? =Nz(DLookUp("sumoftotal","[Query1]","[CV_Order_ID_TXT] = " & [Forms]![Manual_Order_FRM]![CV_Order_ID_TXT]),0) thanks in advance shane
  7. S

    Solved Help with Dsum Multi Criteria

    thank you worked perfect :)
  8. S

    Solved Help with Dsum Multi Criteria

    Hi All, i have query that calulates the month spend in one column [Month_total] then i Group it via the month using a field called [Month_] then use a sum on form to call the values like =DSum("[Month_Total]","[Monthly_Cost_parts_QRY]","[Month_] = '3'") which shows the total spend for march...
  9. S

    Help with Put Data on to IE webpage

    Hi i wasn't get an error as i left on error resume next line in i get automation snytax error with below after google some more doesn't seem people use getobject with IE some how check it with shell? Private Sub Command13_Click() Dim IE As InternetExplorer Set IE =...
  10. S

    Help with Put Data on to IE webpage

    Sorry no error did nothing
  11. S

    Help with Put Data on to IE webpage

    tried Getobject not working not sure what else to try thanks shane
  12. S

    Help with Put Data on to IE webpage

    hi, I have DB with a form contain 4 Text Boxes the data from the Text Boxes populate the web page controls. Which Works great i'm not the greatest coder surprised myself it worked lol. Now the problem i have it always opens a new internet explorer session every time i run the code. i know its...
  13. S

    Check If excel file is import already

    No worries Gina :) good to be busy time fly's :) thanks again
  14. S

    Check If excel file is import already

    Thanks Gina :) for the start and thank you gasman for the help too :cool:
  15. S

    Check If excel file is import already

    sorted cheers with If DLookup("Pathname", "ExcelFileName", "Pathname ='" & selectedfilename & "'") > 1 Then MsgBox "This file was already imported!", vbCritical, "Duplicate" Exit Sub End If:cool:
Top Bottom