Search results

  1. C

    VBA SQL Update string to update table using Now Function

    hi, Im using a SQL string to update several columns within my table, one of whcih needs to be now() but i cant get it working. the sql string is: qs = "UPDATE [Holidays] SET Cancelled_By = '" & Me.User_iD & "', Date_Cancelled = " & Now & ", which throws the error: Runtime Error 3075 syntax...
  2. C

    VBA to subtract form field time value from another form field time value

    Hi all, Fairly new to Access VBA and i cant for the life of me figure this out or find anything through searches on google/this site that cover my specific problem. I have a form that when the save button is clicked adds a new line to a table based on the fields completed within the form...
  3. C

    How to export table data based on criteria to a new excel workbook wothout saving it

    Hi. I need export records form a table to excel. Everything ive come accross so far requires the excel file to be saved as part of the code and the docmd.transferspreadsheet method seems to be the most common way to export to excel but i dont want the excel file saved anywhere. Just need it as...
Back
Top Bottom