Search results

I have a report based on query that finds all of customers that are in a "Pending Status" to end their current contract. On the report if they click the link (customers Name) it will take you to the customer's details form. Is there a way when they click on the link it opens to a specific page...

Awww...that worked. Thanks

I have a form where the Record source is a query. One of the records is a checkbox for PrimaryFac. When we export this form to excel this field shows as true or false. We would like it to show Primary or blank. I was thinking maybe we had to show this on the form before exporting to excel. So I...

The overall objective is to count the number of active providers from tblProviders so the number is automatically adjusted and shown on the form Practice List which is based on tblPractices. I have the two tables linked by a third table tblProvPrac so we can associate each provider with their...

Ok I created a subform, sfPracProvCnt, and added it to the footer of frmPracticeList. 2. changed the visible property of the subform to No. 3.Changed the control source for the Number Provider field on the frmPracticeList to: =[sfPracProvCnt].[Form]![NumOfProv] When I open the...

pbaldy...Now i understand, "it has to be". I was reading it as the reason it was not working. I will look for a different way to get the information

Well I tried adding the unbound and reentering the expression. Same result

pbaldy...no. the only form open is the one where i entered the expression. Should I add an unbound text box? the one i had in there belonged to another field that i removed from the table.

what do you mean by open?

I am trying to pull the the control source value from one form to another. According to my research it should be as easy as =[Forms]![frmProvCountPerPractice]![NumOfProv] Unfortunately it gives me the value of #Name on the form view. Any idea why? I found this on a google search Microsoft...

Yes. That is what I am looking for. When i get into work within the next hour I will test it in my MasterTestCopy db. Thanks.:)

YPMA...no I have not thought about using Inactive as a default. Usually if we get a new practice that means we get a new active doctor. However we can't actually mark them active until the practice go live, meaning we have trained them on how to use the application. PLOG...the term practice...

it's just one table.

I have been trying to figure this out for months. :banghead: I have a table, tblProviders. It has Mnemonic, Providers Name, and Active/Inactive. I am trying to create a query to Providers, group by mnemonic where providers active. It works to give me the correct count, but if a practice has 0...

We made it with little damage. No major flooding, just water that found cracks in the roof and came in between the walls.

Hello, Who I am? And what is my skill level? Let's see. I am just an average person who loves to watch and play sports, mostly baseball. I work in Customer Service for a hospital supporting an EMR application for clinical practices. I have been working and trying to understand access for...