Search results

Trying to write an expression that will give me the text value instead of the ID field on my form in a text box. The form Record Source is based on a query of two tables: tblPractices and tblTechnical. what I am trying to get from the expression is the following =IIf([Jobserver]<>"", "\\" &...

Hello again. I would like to pick our brilliant minds regarding how to set up a few tables. Currently, I have three tables (tblPractices, tblModules, tblModuleDetails). I have attached a picture of the relationship to the post. I need to show each practice and the modules they have activated...

I have a user that on her computer when she clicks to open a specific form, it does not open. All the other forms open without any issues. I have tested on other computers and the form opens fine. Any ideas to why it doesn't work on her computer?

I was wondering if there is a way to export a table to a RSS feed. I've searched online but couldn't find anything regarding exporting.

Trying to use dlookup for the first time to see if I can pull the contract name from the table. =DLookUp("[eCWContractName]","tblPractices","[PracticeID_PK]='" & [Forms]![frmPracticeList]![PracticeID_PK] & "'") Found this link,http://www.theaccessweb.com/general/gen0018.htm, in an old post...

Is it possible to caption a Modal form with a field from the tables? For example, when they click to open the form they enter which practice they're looking for (mnemonic) and it will pull the information for that specific practice. I would like the mnemonic to appear where the caption of the...

When we install our application on our clients computers we have to create a configuration file that points it to their server. Currently the information we use to create the file is stored in our access db and we have one generic file that we update each time. I was hoping i can build a...

Is there a way to make my combo box multi selection if my row source is a query based on the table? tblCredentials CredentialID-Autonumber Credentials-Text (Combo Box, Value List, Allow Multiple Values) Form My combo box is set as Control Source-CredentialID Row Source-SELECT...

I cannot figure out what I am doing wrong but I am assuming it is how I have set up my query. I have two tables tblPractices - practice information ID | ContractName | Mnemonic | PCPorSCPID_FK tblPCPorSCP - describes if the practice is primary or a specialty practice ID | PCPorSCP...

I created a data entry form to add a new provider. the form's record source is tblProviders. 1. Under the Data tab for form properties I changed Data Entry to Yes. 2. The On Load event I set the macro to open frmAddNewProvider with the gotorecord set to New 3. I added the fields for...

I was wondering... In my database i have a table of providers, tblproviders, which captures their name, credentials, join date, end date, and any products they have activated (such as emobile, emessenger, eHx, etc.). Each provider is part of an incentive based program and we need to capture...

Is there a way to open the report the user selected in the combo box? I created a form with a combo box (cboCannedReports) and listed three reports: 1. Completed Closures 2. Pending Closures 3. All Closures I came up with something like this DoCmd.OpenReport...

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

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

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

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

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