Recent content by mpaulbattle

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