Recent content by bruggied

unable to create relationship, not an unique id.. database included why this create relationship module, i import multiple excel files in to mutiple tables and each table need to be linked to the main table _match _skill _ player

hello, the issue remains : The database engine could not lock table "_match' because it is allready in use by another person or process

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

file = Mid(CustomerFile, InStrRev(CustomerFile, "\") + 1) WrksheetName = Left(Mid(CustomerFile, InStrRev(CustomerFile, "\") + 1), (InStrRev((file), ".") - 1))

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