Search results

You have an interesting point, I have had some suspicions about that. I have to confess I am never entirely sure which variables need to be cleared and the best way to do so. The code is quite long (I'm not the most efficient programmer) it generates a 5 sheet workbook with a lot of charts and...

I have an access database, for reporting I have a number of routines that each create an excel workbook with multiple worksheets of tables and charts. All of these routines run fine and without error the first time I execute them. But if i execute any of them immediately after running another...

I have a backend data file saved on a different server \\myserver\backend. \\myserver\backend is mapped to K on my machine. Currently I link to K but i would rather link to the UNC path. Problem I have is in linked table manager even if I select the UNC path, it converts it to K. How can I...

Will probably change to that, more elegant, thanks.

I only need to alternate between weeks to provide what I need so I only used 2 (could have used 1 TBH)

I have successfully implemented CJ_Londons proposal, with some interesting findings. The form I was styling was in fact a view only form all fields on it were locked and disabled. I added an unbound text box (txtBackground), moved it behind all the other controls and then set the conditional...

Thanks for all the replies Thanks in particular to CJ_London, you have interpreted exactly what I am looking to do. I had realized I couldn't get CF to change the detail section, but never thought of adding a textbox the entire dimensions of the detail section in the background. I will try it...

I have created a database to record time bookings. A user is able to see a history of their bookings for each week in a continuous form. Most weeks will contain multiple lines: W26 - Holiday - 8hrs W26 - Project 1 - 20 hrs W26 - Project 2 - 12 hrs W25 - Project 1 - 20 hrs W25 - Project 3 - 20...

Hi Just Joined the forum. I have done quite a lot in Access but always open to learn more. I use Access a lot as a user interface to SQL Server databases and a reporting tool where I use it to drive reports in Excel. Outside of using Access I spend time with family and dogs and have a passion...