Search results

Thanks Pat, That explains it perfectly for me. My next question then would be, is it better to have the form Record Source based on a query or a table with a filter in the DoCmd.OpenForm code? ~Matt

Hi Forumers, I have been reading many posts and viewing much code on here and notice the Recordset is mentioned alot. If I have a form that cannot move between records, is there any benefit in declaring the recordset? My frmQuote is based only on the tblQuote, and cannot move next/previous...

I have found the issue. The original programmer had a module called RefreshTableLinks that ran when every form is opened. I have removed the call for this and all forms now open fine. If I never change the details or location of the linked tables, hopefully this will not cause an issue? Public...

Further Update If I remove the option from Display Form, the error does not happen. But if I select a Display Form (any form), the error appears. ~Matt

Hi Gasman, It is yes. And the table works fine in other FEs. Despite the error message, the table still opens and works fine, as does the code I am using the table for (User Access Rights) ~Matt

Update. I have this FE linked to 2 BEs and the error is linked to the only table from the secondary BE. All the others tables are from the main BE and they all work fine. ~Matt

As soon as I open the FE. The database opens a main form and then this error appears. There are lots of linked tables and this is the only one that has an issue. ~Matt

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