Search results

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...

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...

Hello I don't try it yet

(y)(y)(y)(y)(y)(y)(y)(y)

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

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)

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

Testing Thank you for all your help

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 =...

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

(y)(y)(y)(y) Thanks for the great information

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...

(y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) Great Solution Worked with me

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

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

Yes. Percent Issue How can I solve this problem

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

Backend SQL SERVER

Hello after the record is inserted into DB, I want the current field value divided/ 100 Current Record Only Not all records

Friends How can SetField Value after insert I want after insert row Myfield Value for this row divide / 100 You can see the field setting on Table Macro If you could fix DataMacro Thank you so much