Recent content by Weekleyba

The entire BE is 12.4MB. So not very large. Again, works just fine with everyone that has Win 10. Win 11 is super slow.

Here's a larger screen shot. It is probably 8 times as long as this. One is sorted for Memory the other for CPU. I also closed everything I could except Access. Very similar on the other computer with 7% CPU and 32% Memory. Set up is everyone has a FE on there own computer. BE on the server...

Only shows one.

All LAN connected.

So IT turned off the Bitlocker. I restarted twice and tested twice. Still the same slow performance result. I've sent IT your latest suggestion, maybe they can work on that RECALL feature and turn that off. Thanks for your help! If you have any other thoughts, I'm all ears, since I really need...

Thanks Doc. I will see what IT says. Hopefully they will try this, the database will become painful to use without a fix.

I have a split database that we use with 12 people. Recently IT "upgraded" two computers from Win 10 to Win 11, mine being one of them. The performance of the database is significantly slower. Each click taking 5-15 seconds with the database showing "Calculating..." for up to a minute...

Thanks for the solution. Here's what I put in the On No Data event of the report. Private Sub Report_NoData(Cancel As Integer) 'If no data in the query, just gives message box. MsgBox "No records to display." Cancel = True End Sub

I have a report that opens in acViewReport from a command button on a form. When the report shows no data from the underlying query, I want the text "NO DATA" to appear. Currently I have a label showing "NO DATA" with the Visible property set to No. In the report's On Current event, I put the...

Thanks MajP! It worked out great for what I am trying to accomplish.

I have a query that I'd like to count the number of records. Seems easy enough but, I only want the number of records where the FYID is equal to what I have on the open form Main_F. I'm close, but not there yet. Can someone lend a hand?

Thanks to all! Here's my solution that I can not put in every subform to check if the parent form has a ProjectID already created.

Maj P, I'm getting this error. Not sure what I'm doing wrong here.

How would you set this module up to check for the parent form creation of the ProjectID, (which is the primary key of the parent form)? I have eight subforms where I want to use this. Maybe I just need to place the code in all eight, since the Me.Undo is going to change also? Thoughts? It...

That worked ebs17. Thank you.