Search results

Thank you everyone for your inputs. At this moment, based on the feedback I got from you, and from what I read online on this topic, I was able to convince the management to keep using the remote desktop solution. I appreciate all your help!! Regards,

Greetings, We are using office 365/ ms access db split into BE/FE. The BE is located on the shared folder on the server and each user has a copy of the FE on his/her desktop. Currently, everyone is working from home using their laptops and accessing the database via remote desktop. Which seems...

Pat, thank you for your detailed explanation. 1. Special character: I understand your point, but as I stated in the past the database was created by someone else who no longer with the company. What makes things harder to troubleshoot is that there was no data dictionary and or documentation...

Hi Arnel, Thanks for your suggestion. I'll definitely try to implement your method. I just finished cleaning up the excel file and successfully appended new providers to the database. Now, the provider list grew to 105K. I'll post back if I still notice any performance issues. I appreciate...

Hi, Sorry about the confusion. To answer your question, I’m not 100% sure. But, my understanding, or the intention is when creating a new provider case the system was to: 1. check if the provider is in the exclusion list. The exclusion table currently contains (about 5k records). 2. see if...

Thank you both. Arnelgp: Where do I check to see if the person who design the db maintained an open connection to the back-end db? As for the reason behind for ‘searching’ my understanding is: 1. to see if the provider is in exclusion list (there is a table that stores the excluded providers)...

Thank you both. Crystal, thank you for providing the code. I’m still in the process of cleaning up the data before proceeding with updating the table. The excel file provided to us contains both the existing providers along with the new providers. I’m trying to determine the best way for this...

Thank you everyone for your input. The_Doc_Man, The wife is the boss…the same here. Everything you outlined make a lot of sense. In your summary #3. and in the previous post, you stated “wild card in front of the search string etc. as one of the causes for slowness. For instance, when...

Thank you both for your feedback. Attached is the screenshot to show the index and field size for provider table in design view. Crystal was this (2nd screenshot) the field size you were referring? The-Doc_Man As you stated there are some other things that I need to investigate as the...

Thanks for the suggestions. I'm certain the table has PK. As for index, I checked the table in design view and attached is what I see. Is this what you were referring about PK & index? TIA Regards,

Thanks for your feedback. I. I already set up a test environment to perform and test this task. 2. Every morning (before end users access the DB) I do compact and repair and backup the database. After I completed these tasks, I right clicked the backend, go to properties to learn the size (780...

Thank you both, theDBguy, I wanted to know how to find out the file size of the database. As for updating the table from excel, the plan is adding new ones. But, looking at the list, we were given existing providers that are already stored in the database along with new providers. My...

Greetings, We're currently running office/access 365 the db is deployed in split (be/fe) environment. We have a provider table w/ almost 80k records. The way the db is designed (by someone else), or supposed to work is as follows: Whenever users create a new case, a search window appears...

Many thanks everyone! Regards,

I created the combo box onto frmFinancial which is a subform. I was able to access the wizard when creating combo box. I verified the table is updating my test values, and everything seems to work fine now. Thanks everyone for your feedback. Regards,

The main form is unbound. The tab page is a subform (frmFinancial). I tried creating the combo box onto frmFinancial, this time the wizard appeared. But, now the financial tab becomes blank. TIA Regard,

The field I created doesn’t show in the wizard. This is because I created the combo box in a form and cut/paste onto the tab control. TIA Regards,

Hi, Thank you for your feedback. I actually did exactly what was suggested: I first clicked the tab where I want the drop down to appear, I clicked combo box and placed it in the tab, still the wizard didn’t appear. I then used theDBguy’s suggestion: I created the combo box onto a form then...

Hi the DBguy, When I drag the drop down to a form, the wizard appears. But, when I drag it where I want it to be (on a tab), the wizard doesn't show. I take it's turned on. TIA Regards,

June 7, thanks! can you please guide me on how this is done i.e manually set properties? TIA Regards,