Search results

  1. Z

    SharePoint List

    Hello Are there any disadvantages to using Share Point Online list as a backend Tables for Access
  2. Z

    pass-through

    thanks for the great information (y)(y)(y)(y)
  3. Z

    pass-through

    Hello I need to speed subform I have more than 3 subforms I want to bound this subform to a pass-through query but access prevents me to do that what is the solution
  4. Z

    Import Sheet Error

    Hello friends when trying to import a sheet from an excel file I face this problem DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "TempDetails", txtFolderPath.Value & "\" & cboFileName.Value, False, cboSheets.Value & "$" Sample of Sheet name Include dot 2.4_OTLDetails This is...
  5. Z

    Mail from access with attatchment

    Hello friends I have a default template with a signature in outlook I want to use the default outlook signature in outlook from access I can send the report from access to outlook but messages in outlook become normal text I need a button when I click send report1 as attachment to default...
  6. Z

    linked table backup

    Hello I don't try it yet
  7. Z

    linked table backup

    (y)(y)(y)(y)(y)(y)(y)(y)
  8. Z

    linked table backup

    Hello friends; I linked the table to SQL server online hosting what is the best way to back the table from inside access?
  9. Z

    mailto at the end of the email field (text field)

    genius (y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)
  10. Z

    mailto at the end of the email field (text field)

    hello friends when I show (preview) the data inside the report mailto: text inserted at the end of the email I don't know the reason
  11. Z

    Power Query

    Testing Thank you for all your help
  12. Z

    Power Query

    good solution Sub Macro1() ' ' Macro1 Macro ' ' ActiveWorkbook.Queries.Add Name:="Data", Formula:= _ "let" & Chr(13) & "" & Chr(10) & " Source = Excel.Workbook(File.Contents("" & strFileName & ""), null, true)," & Chr(13) & "" & Chr(10) & " Data_Sheet =...
  13. Z

    Power Query

    Friends in the attached file one contains data that come to me weekly I want to upload the datasheet to Power query Excel by Vba Excel I prepare everything to get the path of the Excel file Just I need code to: Append the Excel path to Power query Excel
  14. Z

    row version

    (y)(y)(y)(y) Thanks for the great information
  15. Z

    row version

    This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made. Hello friends I use SQL server online hosting this message appears to me I read on a post we should use RowVersion to solve the above...
  16. Z

    After Insert Trigger

    (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) Great Solution Worked with me
  17. Z

    After Insert Trigger

    Hello work with Access Table Backend and front end access ----------- my issue frontend access and backend SQL server
  18. Z

    Input Mask or Formatting??

    Hello work with Access Table Backend and front end access ----------- my issue frontend access and backend SQL server
  19. Z

    After Insert Trigger

    Yes. Percent Issue How can I solve this problem
  20. Z

    After Insert Trigger

    if possible the 2 solution one work with frontend Access backedn SQL SERVER
Back
Top Bottom