Search results

For the tblBasLink table it has 6 records with three web pages on a single tab control form (one record could be same for 20 plus buildings). I also have a web address in the graphic table to bring up web pages for each specific graphic. I took your advice on the pictures table just made it...

I adjusted the things you suggested but got to thinking that a picture could be the same for more then one piece of equipment if I had a picture of a group of fans. I did a junction just in case I need multiple pictures as well for a piece of equip. I've also added three more tables that I...

How does this look now? My thinking was to make the tables a little smaller but I rather make things more efficient and correct. My thinking is that pictures should almost be in the equipment table as well. The software points are the same as the equipment points so I can use one search form...

So thanks again for all this, basically to answer some of your questions. Answer 1 and 2....Each building has a PropertyID number and each building has many graphics. I used the building abbreviation as the PK as none are ever the same and it is easier to use the abbreviation. Answer 3 and...

Thanks a million that's awesome... You saved me a ton of work with the dlookups. How everything is set up is great and such a time saver.. So I adjusted the table in the relationship like the diagram below. Would this be good or do you still see some issues with it? I made sure to have all the...

I just threw it together quick but thanks for all the input. Thanks for explaining things in detail much appreciated. I posted a cleaned up version hopefully this looks ok (missed _FK on PointID). I don't know if you have any ideas about changing how I get the note flag to appear instead of...

Sorry but won't let me save as a previous version. Thanks for trying

Not zipped.. still trying to get a solution for using the dlookups or any other ideas. I checked it and it seems to work fine when downloading it. Thanks

I've have attached a stripped down version of the db so you can see what I am talking about. Thanks

So originally how I had everything was a bound form with dlookups. I had 20 text boxes on the form with the dlookups for each pump. That means 20 lookups each looking at the Notes field in the query for a single record for each pump and bringing the note into that small textbox on the form...

I would post a copy of the db but it has confidential information in it besides this part of it. I have a bound form (which I bound to a query)……. Field names for query...I am working with on my form are PointID and Notes PointID - records are 1 to 20 Notes - have a note or no note for...

Hi Micron, Hopefully this will be enough to give you an overview of what is going on.

The form is bound to a query like I said above but how would I approach the code? (If there are numerous note flags each tied to a different specific record). I'm probably missing something really easy but if someone could help it would be much appreciated.

What should I do instead of the Dlookups suggestions?

Thanks for the code. The text box is positioned behind the note flag button so the note can’t be changed without going to the other form. I placed it in the picture attached with the text box showing but it is usually behind the note flag. With the Dlookups yes there is a lot of them how would...

Hi Micron, Is this acceptable because It was backwards or should I write the code a different way...Thanks this will save me a ton of time. Me.Controls("cmd" & i & "n").Visible = false = Nz(Me.Controls("txt" & i),0) = 0

Both forms are bound to a query that contains the note. Some images have 20 or more pieces of equipment so just trying to sort this out before I really get into this. Thanks

Thanks for the help! I also have a couple other questions if someone could please help. I use a Dlookup for txt1 to txt5 in the control source on the text boxes to get values on the form (the little text box by the black note flag in picture below)……. =DLookUp("[Notes]","qrysearchAfc","[PointID]...

Does this code look correct or should I be doing something different. It seems to work ok but is there a way to shorten the code. Thanks in advance... Option Compare Database Option Explicit Dim db As Database Dim rs As Recordset Dim URL As String...