Search results

Hi all, I have just started receiving an error message with a linked table. It has only appeared today and the related FE still works fine using this table. I am still able to open and access the table and all queries and code related to it work. Has anyone ever had anything similar? ~Matt

Thanks for the help guys. In the end I figured out where the existing module was that did this for his right click menu and called the into my own new form and it works. ~Matt

Hi forumers, I have a modified drag and drop planner we use at work that places new activities on the screen with an X and Y coordinate to place it when added. I am trying to figure out how to work out the next X and Y values based on the last values in the table. X starts at 10 and increases...

I am like you, I still have the issue. And still no resolution. It is only Windows 11, it is very frustrating. It only works with the top <insert number here> rows. I haven't yet worked out how many rows it works with. ~Matt

Thank you for this link. I went with this and it works perfectly. Very simple and easy code once I downloaded the sample database. Thank you for your help. This is now solved. ~Matt

Thanks CJ, That is perfect and allows expansion for future price breaks, or changes to the existing ones. Thank you ~Matt

Hi All, I am working on a quantity price break query and wondered if there is a an easy way for the below. I will have 8 breaks of 1, 2, 5, 10, 25, 50, 100, 250. I would like the expression to take the QuoteQuantity (IE 32) and quickly find where that sits in the price breaks. As in >25 AND <...

I have fixed this now by removing the MVF and using a table to allow me to select multiple values. I know never to use MVF again, it was a pain. What was strange though was the "fix". Just moving the table in query design view and saving it to make it work. ~Matt

Hi all, I have a strange error on a query and wondered if anyone else had ever seen anything like it. I am getting the below error. The field it mentions is only in a single table on the query, so the message is incorrect. This only happens when I edit the related form on a Windows 11...

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