Search results

Hello, I have a combo box on a form which displays records on a form based on the value I selected from the combo box (first and last name). My issue is, the combo box will not allow me to select the next last name within that same alphabet selection. My table is indexed on the last name...

Hello, I have a table called providers with the following 3 fields: Provider ID Cancellation Reason Visit ID Date It is possible to have multiple instances of the same provider ID, cancellation reason and visit ID on the same date. I'm trying to count just 1 instance based on visit ID if...

Hello, I need to create a macro to import a file daily, but the name changes on a daily basis with a new date. The file name is Providers_mm/dd/yyyy. Is there a way I can write a macro or VBA to import the file daily using a parameter or something? Any assistance is greatly appreciated...

I have a file structured as listed below. I need to pivot Patient Id, Patient Name, Send Reason, Provider Name and Visit Number into columns and then insert the values into the corresponding columns. My data set contains about 1,000 rows, so I cannot simply paste special in Excel. Patient ID...