Search results

Thank you Moke123. I am trying to accomplish exactly as you mentioned in your post. I created a combo box by selecting the 3rd option and I was expecting it to display the details for the person I selected. There are a lot of records with the same last name, with the NPI being the unique...

I've tried your suggestion and listed this code on the on click event: DoCmd.GoToRecord , , acNext I am getting an error saying "GoToRecord isn't available now". I get the same when I try GoToNext or First. Any suggestions?

The row source is the first and last name. Could you please explain how I would make it use a unique identifier? I have a unique field in my DB (NPI) that I can use as the control source, but I need the first and last name to display. How do I tell if the form or the combo box is locked? I'm...

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 created a form with a button to call the module and it does work, but the workflow is not appropriate for my process. I don't need the module until the very end of my process. Could you or anyone please explain how I can make this into a function and call it through a macro if possible...

You're a hero! I had ID typed incorrectly. Fixed it and now it works. Thank you for the links and insight about learning VBA. I'll definately look at uTube. Thanks again!

Thank you again. I was heading down the path of a macro, but couldn't quite figure it out. I am getting an error that states 'unrecognized record type'. My table setup is as you outlined in your .jpgs 'text and auto number'. If I click on the 'ok' button in the error message, the code...

JDRAW - thank you! This is brilliant. I've added your code into a Module and created the tables as you have outlined above. Could you please tell me how I would call the Module or run it? I loaded data into the table, but nothing is in the output table. Thank you.

Yes, all 5 fields make a record. I have about 100+ repeating records in the file consisting of the same fields. They are consistent as well.

The data looks like this: Field 1 Field 2 Patient Id 111111 Patient Name Doe, Jane Send Reason Cannot resolve provider Provider Name Doe, John Visit Number...

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...