Search results

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.

This is a split database - I have opened the front end on several different machines and the problem is the same. I'm pretty sure it's not a local windows/access issue. The most recent backups behave the same way, regardless of which machine is used. I just had a thought - this did not start...

I think I am out of my league on this problem - I still can't get it to compile. The GoToRow function that it is crashing on is a Public function in another module. Plus now, one of my reports has started crashing with an 'expression is too complex to be evaluated" error. It's just a date...

this makes no sense - everything was working just fine and now when I try to recompile, it craps out on nearly every line of code. I also tried creating a new database and importing everything and all the colors on my forms changed. The Quick Style color I was using does not even show up in...

This is so frustrating - I have decompiled and when I try to recompile, I get the error shown in the attached screenshot. I tried creating a new database and importing everything but it did not help. Everything still works but I can't compile and Access still shuts down after I edit the VBA...

I appreciate everyone's input - I was afraid the consensus would be something like this. What a colossal pain in the butt. :banghead: I will try the options suggested. Thanks so much.