Recent content by dkmoreland

Good idea - I'll do just that. Thanks

Key Preview is set to No. I did get around it though - I deleted and recreated the button that was opening the form. Now it works like it's supposed to. Thanks to everyone that chimed in - I appreciate the help Access is so weird sometimes.

I don't have any events for those properties. The only event I have on this form at all is a GotoRecord New in the On Load property. But all the other forms that have the same event are still able to load the Ctrl F dialog. I have never seen this behavior before.

I have one form - just one - where the find and replace dialog will not open when Ctrl F is pressed. This database has dozens of forms and it works just find on all of them except this one. I'm using Access 2016. Is there a property somewhere I need to look at? Thanks

Oh - ok. I see what you mean. I'll give that a try. Thanks so much for the additional explanation!

I'm not sure I'm getting your full meaning. The monthly data is in a date format calculated field in the original query. If I put the months fields in a separate table, even with a join, how will this work when the field calculation in the original query returns a value other than null?

I wonder if it would work to use an if statement in the report control - that basically says if the field doesn't exist, display a zero.

I am trying to create a report that shows monthly totals and YTD totals. I also need to show monthly totals of jobs that were not approved. Here's initial query: SELECT [Carrier Release].[Job Number], [Carrier Release].Supplier, [Carrier Release].[Date Eval], [Carrier Release].Approved...

I know you folks have seen this question a hundred times but I need to ask it anyway.:p On my report, if the shipped quantity is equal to the order quantity, I need it to display 0 in the field. If it is not equal to the order quantity, I need it to display the value of the shipped quantity...

I did end up adding them to the form but hiding them. Thanks for the suggestion!

I am trying to duplicate the record on a form and at the same time, add values to the new duplicate record that are not displayed on the form but are present in the table. For example, the form fields are id, job number, order qty, mfgdate and po number. I'm duplicating everything except the...

I have a form with a tab control that has 3 pages. The master job number is entered on the first page, along with some other info. I have subforms on each of the second and third pages on the tab control. I have the master / child fields set to populate the job number field on the subforms...

Thanks to all of you, I have made some progress. I installed V-tools and did a deep search on the GotoRow sub. I found it in 3 different forms. I'm not sure why it was there - this is an inherited system and I saw no evidence the code was even in use. So I commented it out everywhere I found...

Also, I ran compact and repair after I removed them.

I removed the idle timeout form and the 2 macros that were connected to it. Unfortunately, it did not make a difference in either the data issue or the VBA editor issue.