Search results

Ridders ... Sorry, I didn't know. I will let people know next time. I posted it over a month ago on Utter Access. Besides split form, no other suggestions or solutions were provided to solve the problem. So I decided to post elsewhere to try to find answers.

Split Form was suggested to me on another site where I posted this problem. It works, but layout is not workable for what I am doing. Thanks for emulated split form idea, but think I am going to try the two-forms idea.

I tried what you suggested earlier and the filter options do not appear in the shortcut menu if more than one column is selected. Seems the advice I have gotten from you and others is to not allow users to switch views. I thought of possibly having two different forms based on the same query...

Thanks for the suggestion, but that doesn't work. Once both columns are selected, as soon as I click the small filter menu on the column header of Column 2, it unselects Column 1 automatically. And the large "Filter" button on the Ribbon is disabled if more than one column is selected.

Out of all the bizarre bugs and behaviors I have experienced with Access over 20 years, this one has got to be one of the strangest. One of my users helped me discover this. This happens on ALL forms, no matter what. If anyone has seen this behavior and knows what to do to fix it, please let me...

Finally found the problem!! I have four unbound boxes on that tab that have their control sources all set to complex DLookup functions. I forgot I had these as DLookups, which from what I read, can really slow the system down! I changed them everywhere but here. If I set all four to null, it...

Gemma ... I did confirm the consistent connection. I monitor the folder where the backend is. As soon as someone opens the database, the locking file appears and does not disappear until they close the database. It does not disappear and reappear like it did before I created the consistent...

Update on this. The server changes IT made did not work. We’ve done a lot of testing Friday and today with the database, trying to pinpoint the problem. The network slowness is especially noticeable when moving from record to record. So, we decided to do some speed testing based on that. Here is...

Thanks for your help everyone. IT said they have tried something on the server and are going to reboot it tonight to hopefully help performance. I guess they changed something. I have also gotten a few suggestions from other boards on thing to try on the front end. I will test again Friday...

Thanks Minty. If I could wave a wand, we'd have 1G bandwidth. Unfortunately, that's not even my department and I don't have magic powers either. :( I have gotten some other feedback of things to try such as making the FE an MDE. The IT guys also said they tried something on the server and...

I have been doing Access development for 20 years and this is the most frustrating problem yet. I have a new database I have created from scratch. I have the Access backend on the server and Access frontends are distributed to users desktops. When I test it, it's lightning fast. As soon as only...

My name is Traci. I have been developing Access databases for over 20 years. Seems I am constantly learning new things about Access and VBA, even now. With each new customer or employer comes different challenges. I have found these type of forums helpful over the years. I am thankful to...