Recent content by lamarw

How's it going MajP! Thank you for the snippet. It's exactly what I was looking for. It never occurred to me to declare a form variable and set it equal to the other form. Brilliant! Lamar

Hi everyone, I'm trying to find the screen location coordinates of one popup form from another popup form. I will be using these coordinates to ensure the two popup forms stay together and move together. I know there's no event to fire this action, with the exception of the timer event, but I...

Okay, after I submitted it occurred to me the use of 'dates' would be confusing. I'm trying to standardize the results by defining WHERE clauses in constants due to their complexity thereby avoiding inconsistent results by being consistent in the 'WHERE'. What if the WHERE clause looked like...

Thanks MajP. So, then I can't include in the constant all the fields and their values thereby creating the entire clause without the 'WHERE'? Lamar

Hi Everyone, I've looked all over the POSTS for something on the subject of using CONSTANTS in a WHERE clause of an SQL Select statement. I can't find anything. This is a sample: The constant might look like this in the Module: Public Const FromThisDateToThatDate = "FromDate>=3/1/2015...

It turns out that ribbons can be created with relative ease and with multi-functioning objects utilizing XML. So far the best place I've found is accessribbon.de. This is a site that specializes in ribbon creation. It will solve all my menu questions such as changing the name of ADD-INS. It...

Hi everyone, Does anyone know how to show an image in a custom menu along with the text? I'm not referring to a button bar but a menu bar or more precisely a ribbon. When I add a custom menu it shows only text. I would like to include an image to the left of the text. The custom menu...

Are you trying to disassemble/analyze a web page?

I was going to suggest creating a new blank database and importing everything from the old one into a new one. A lot of hidden data can be corrected doing this. However, I agree with all the comment's above pointing to the 'unsplit' database. Even if you recreated the database you would...

Okay, excellent comment MajP, I will look into that. I liked the multivalued field because it automatically generates a form too, in this case a list with checkboxes for multiple selection. Thanks again.

Hi MajP, Many thanks. This is what solved my problem. Would you have done things differently? I'm looking for input. Dim db As database Dim rsParent1 As dao.Recordset Dim rsParent2 As dao.Recordset Dim childRSread As dao.Recordset Dim childRSwrite As dao.Recordset Dim strSQLread As String Dim...

Thank you MajP! This is exactly what I was looking for. How did you find it? You deserve this star! Lamar

Thanks again MajP. Actually, that's what I'm doing. I am at this point because of the MV field. However, I still don't see a way of accessing the 'recordset' for the field. Could you point me in the right direction? (A snip of code would be very much appreciated.) Lamar

Thanks MajP. I will look at that. ============================================================= You said: The value property of a multivalue field returns a recordset. Then you have to loop the MV field recordset and write those to a fourth recordset which is the MV field recordset...

Well, in retrospect, I agree. Any other suggestions?