Recent content by isaidi

Yes i think it will be pretty sohpisticated, but it is doable. these word documents actually represent test exhibits for equipment, there are many kinds of tests hence alot of documents, and they change frequently. I have managed to design the tables such that they can handle these dynamic...

Not sure if this is the right place to post this, but here goes. What i have: A database with about 50 different forms for ENtering and printing varoius data. This is currently implemented by overlaying fields ontop of an embedded OLE WOrd Document which acts as the template for the form. I...

This is what worked for me. The Key was to ensure that the control names in the forms match the FIeldNames of your elements that you would like to fill. Then you can use a simple loop like shown below. It is just rough code to demonstrate the idea. Hope this will help someone.. Sub...

I agree Bob, I have made the association between an Element and an EquipmentExhibit in a seperate Junction table, since there are about 50 elemnts or so to a given EquipmentExhibitID thanks for confirming that for me. It seems like this Table Design is going to work smooth for me. I am just...

Addition: what would be the fastest code to do that step ? filter or find record where "Element Name" = control.name

I think you are Right Remou. There are several way to loop through. I can narrow down the recordset to a single equipID. user selects the equipID he wants to view and opens the form for data/entry and view i was thinking somthing like (psuedo) (I still learning the how to use DAO ) Onform...

Thanks TheAceMan1, but that doesn't not help me. I am not looking to requery/Synchronize a Subform. Infact if if did this, i would have 50 Subforms for my main form. Like i said above, I have elements and their values associated with one Equipment# as follows.. Equip# | Element Name | Element...

But this still doesn't show all the information for equipment# at the same time. The users must be able to see all of the information for that equipment at once, and be able to modified. This would have been easy in Continous Forms. maybe the only way i can do it is using DLookUp(..) i would...

I have data that looks like this.. EquipmentID | Element Name | ELement Value -------------------------------------- 321 TEMP 25 321 Voltage 300V Element Name is a name of a field on a form, and Element Value is its Value. I want to map...

no one replied to your post. Have you managed to find a Solution. If so would you share it. I have a similar situation to some extent. I just want to be able to find a way to edit a CrossTag or another way around it...

Baisically anytime i have to lookup information in these tables, i would use my lookup table to get the table name and pass that name as an argument to the query. it's not alot of code, but i can't predict what else might come up... i am just starting with the table design right now, i feel...

This looks like it might work for me. I might do this little change to allow adding common fields to EquipmentExhibits that are independent of Exhibit Type and avoid repeating the common Info for every ElementID/Value... tblEquipmentExhibitElements (Junction Table to tblElements)...

essentially this database is just supposed to store the exhibit documents. an Exhibit is just a document that is filled out and completed for each equipment after it is installed. So each Exhibit is directly related to an Equipment. It is a Quality Asurance/Control Check, but it will have...

Thanks Leslie! I have read several of your SOlutions in other threads, I also downladed and read that document from your other threads, very well summarized. I guess when it comes to coming up with the design I seem to get stuck at resolving my multiple tables problem :(. my database is...

Thanks dhookom! Would this really work better with my forms and queries though? I expect to make forms to enter information about the Tumors, and I may have attributes that are CHeck-Boxes (Boolean), Numbers, string... What data type would I make the AttributeValue field. Text? I would have...