Search results

Hi Pat, There are no issue with my database. I was only asking if anyone would like to see it to offer me ways to improve it further. ~Matt

I have been slowy growing a custom CRM at work which now has over 200 tables, over 300 forms across all the different apps I have made. I use custom ribbons and have some code I am very proud of to do tasks for us. My best one of late is product BOMs which works out cost price, labour, price...

Thanks all, I shall give these a go when I am back in work. ~Matt

Hi All, Is there a way of exporting to PDF and then merging another PDF file to my report? I have a code that exports my report to PDF then attaches it to an email. What I would like to do now is export it, merge it, then email the combined file. Is this possible? ~Matt

Update. I have now run out of things to try. If I change the combo box to a different source with less rows, it works. Change it back to the source I want, fails New query, fails New form, fails New database, fails All options work on Windows 10. It seems to be down to the number of rows...

This issue is still live. I have reported the issue, but nothing yet. It is not consistent on all combo boxes. Some work, some don't. Seems the fewer rows in the list, the better it works. It could not be more frustrating. I have a combo box where I really need to see the information I am...

Hi Pat, I already have this setup. This issue seems to be Windows 11 related, as I can open the same database on Windows 10 and there are no issues. I have now switched back to my older, slower machine on Windows 10 as access run faster this way. Windows 11 was slower on every form used, which...

Some new information, if I change the row source to the tbl, it works. If I base the combo on a query, it fails.... ~Matt

Hi All, I have figured this out. The ODBC driver to Sage Accounts on Windows 11 is worse than ever. When I remove the link to the Sage tables, it is fast again. I will work on a better method to tie into the crap that is Sage. ~Matt

Hi All, I have a new issue that has appeared with Windows 11. Below is an image with 6 combo boxes. All of these are setup the same with properties. They all have 2 columns, with the first PK bound column width at 0cm. A query displays the right information, the combo holds the number. The...

I have tried all that, nothing works. I have also noticed that some of my combo boxes no longer autofill when I start typing. It is not all of them, but they are all built the same. It is very weird. Windows bloody 11 :( ~Matt

Hi Minty, Just added them, but no dice. It takes 9 seconds to open the form first time. Less than a second the next time I open it. It is only on the Windows 11 machine. I use it on Windows 10, perfect..... ~Matt

Hi all, I have just upgraded to Windows 11 at work and now my forms are really slow when I open them. If I close them, and reopen, they are fast. Has anyone else experienced this at all? ~Matt

Hello coding wizards, Is anyone out there able to add seconds to the below code? Public Function CalcHoursOrMinutes(CalcType As String, Hours, Minutes) ' This procedure calculates the values for the CalcType, "Hours" or "Minutes". ' If either Hours or Minutes is Null, the function returns...

I just did something like this yesterday. I used the code from here. https://www.fmsinc.com/microsoftaccess/modules/code/Access/Environment/AccessWindow.htm I added the below to the top of my form module Private Declare Sub Sleep Lib "kernel32" (ByVal lngMilliSeconds As Long) Then just Sleep...

Hi Arne, The code is all good. Every time it will be used will be a unique file name, so it wouldn't have an issue. Once the import is done into the 3rd party software, the file is deleted. ~Matt

I love you. Marry me. ~Matt

Why not? They can if I edit the name manually. Why can I not export to there with spaces? ~Matt

Hi all, I am exporting 3 queries to a spreadsheet for import into another program. Export works fine, but 1 tab is giving me issues. The tab needs to be named Bill of Material Records. But when exported it replaces the space with an underscore, Bill_of_Material_Records. Does anyone know how I...

Thanks Maj