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]<>"", "\\" &...

Would I keep the current tables I have and just create an attribute and value table for the extra data to capture? Watched a video on YouTube called EAV Zero to EAV Hero, very informative.

DBGuy...At the moment 23, but I think I will remove some fields since we some are no longer needed. I attached a couple of screen shots as well. Currently the module fields are in tblPractices which I am working on moving. I actually created a table for each module with the fields, but it just...

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

Thank you Micron. The form was opening to her laptop screen which was closed. Issue resolved.

I will try this.

She does have two screens but I didn't see it on either one. I may check to see if she has her laptop as a third screen.

it works fine if she logs into a different computer. unfortunately, the company we work for has a computer assigned to us.

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.

Ranman256...Removed the string quotes and still getting the #type

PracticeID_PK is an autonumber.

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

Thanks Minty. That works.

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 figured out what i was doing wrong. I was doing it completely wrong. So wrong it is too long to explain. Went back to the youtube video and found my mistake.

SELECT tblPractices.PracticeID_PK, tblPractices.PCPorSCPID_FK, tblPractices.eCWContractName, tblPractices.Mnemonic, tblPractices.DBA, tblPCPorSCP.PCPorSCP FROM tblPCPorSCP RIGHT JOIN tblPractices ON tblPCPorSCP.PCPorSCPID_PK = tblPractices.PCPorSCPID_FK;

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