Recent content by K3vin

Thanks this making whole load more sense now. Appreciate you taking the time to help me out. Just one last question by using set like this am really making this statement So if I write a with statement, I am fully referencing the workbook. for example this would fail Hope this makes...

Thanks for the explanation. The code is running however sometimes its not picking up the instance of excel. I have the correct reference however get global fail errors. Is this because am not fully referencing the file as it will be active when I open it. Bit confused at times why it running...

Hi could someone explain the difference between creating instance of excel in access Dim xlApp As Excel.Application Set xlApp = CreateObject("Excel.Application") The above produced run time errors when running my code within access when opening excel files for example this method is not...

Thanks Nautical and Plog for the feedback. I have download the project management database and will start to study the relationship, tables etc....... It does feel like a big task started building from a new database I can't seem to move forward even building the tables and relationships. I...

Hi, At the moment am working on the structure for a planning database. I have attached image of the structure so far. The problem is that I want to capture the user which is the planning team actions. So if they amend or add for example a holiday I can track who in the team action the request...