Search results

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

Hi All, Is there any way I can get a query to create a sequence number based on the first column, but start again when the data in the first column changes? I have a query that has 511 rows. Column1 is BomReference and this has a total of 30 different BomRefences. What I am after is the query...

Just to throw more brown smelly spanners into working fans please see below for more information. If I take a copy of the form and save it "Copy of frmBarcodeProductionManagement" and edit this form I do not get the save issue. If I then rename the corrupted form to...

I am still stuck in the save mode, and I finish at 1pm, so I am going to revisit this on Monday. I am going to take a backup of the form, then delete all controls. If the save speeds up, I will add them back, 1 by 1, to see which one has ruined my Friday. In all my time using Access, this is...

Hi Gasman, That is what I did to create the new form, which is why the codes are all the same. The only difference between the 2 would be the source query to the main listbox used on both. If I use the old version of the form and use the new query source, it still saves fast. It has really...