Search results for query: *

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

...This is a sample: The constant might look like this in the Module: Public Const FromThisDateToThatDate = "FromDate>=3/1/2015 AND ToDate<=4/1/2015 AND Status=1 AND ...etc." SELECT * FROM tblTable WHERE FromThisDateToThatDate ORDER BY ID Is it possible to use a Public Constant in this way...

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?

Hi Everyone, MSAccess 2010 db with linked tables. I am trying to resolve an issue with a table. I don't know if it's a table issue or a code issue but I thought I would start here. I recently had a wiz build a macro that would duplicate a record, seemed simple enough. All the columns...

thread702-634700 docmd.sendobject allows the use of a 'templatefile' for html output. Does anyone have an example of what a 'templatefile' looks like (actual syntax) and how to interact programmatically with it? Lamar

Hi everyone, I am using Office Pro 2013 and trying to use Access and the OVC with outlook.application object created in code. So... First, According to much documentation the control should show a .folder and .view method which can be set to the desired folder (in particular the...

Hi Andrzejek, Thanks for your response. The 'first form' that your referring to is actually MSAccess with no form showing. All the forms are popup but not modal. What I would like to do is programmatically completely cover the empty MDI with whatever form is showing not by moving the popup...

Hello Everyone! I have a little problem I cannot find any information on. I have popup forms in msaccess. I would like to 'move' the parent(MDI) when I reposition the popup window with the mouse so that the MDI never becomes visible and follows the shape and position of the popup form. Is...