Search results

Hello, i have the following module created to create a relation between table '_match' with column 'match' and table '05-as2910 = WrksheetName' , column 'as2910 - teamdat' when running i receive this error : Creating Relations... The database engine could not lock table '_match' because...

hello, my customerfile is C:\david\axor\01-mavo2409.xlsx with this code "file = Mid(CustomerFile, InStrRev(CustomerFile, "\") + 1)" i receive this 01-mavo2409.xlsx i want to remove the .xlsx extention how can i do it

Hello, i use this code to import xls file in access Sub ImportXLS() ' importeer xls bestand Dim WrksheetName As String Dim i As Integer Dim xl As Object Set xl = CreateObject("Excel.Application") xl.Visible = True xl.Workbooks.Open "C:\david\axor\01-mavo2409.xlsx" With xl .Visible = True...

hello, i'm new from today and i know access a little bit but much questions without an answer