Search results

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,

Greetings, I'm supporting an a 2016 access db that was designed by someone else. The requirement is for me to add a new drop down field with in a tab in the form. The name of the tab is pgeFinancial and the drop down field I attempted to create is called disposition with items like guilty...

Hi, I tried =[ComboboxName].[Column](#) but it wasn’t doing anything. After watching the video link provided by Uncle Gizmo ‘Get Info From a Combo-box” http://www.niftyaccess.com/combo-box/, I changed the column count and the column width of my combo box, and it’s working nicely. Thanks a...

Greetings, I’d like to auto populate a textbox (txtDAUEmail) based on selection made in a combo box (cboDAUNM): If John Doe1 is selected from the combo box, then the textbox should auto fill the analyst’s e-mail address. e.g. John.Doe1@emiladdress.com I changed the row source of the combo...

Hi, After reading the 'Query Join Types' link provided in this forum, I revised my query to get the expected result. Following is what I did: 1. deleted the default join 2. dragged SUSPSTAT from left table to the ID field in the right table 3. edited the join property and selected the...

Colin, Thank you. I can ask for permission from my supervisor and try to put something together for you to take a look. Is there instruction and/or sample db to show how to post a sample db? Regards,

I changed it to list box and nothing showing for row source. And, row Source Type: Table/Query. TIA Regards,