I believe the reason why no additional cloned forms show up in the navigation pane is because there are no additional forms in the situation you describe. I believe I've simulated the situation you describe in the attached database. In this database Form1 contains f_someformname in the...
You need to concatenate Me.UserName into the string otherwise it will be literally Me.UserName instead of its valued. Assuming User is a text field this would be something like:
strMyLast = "Status <> 'Completed' And User = '" & Me.UserName & "'"
Maybe not so odd. On my Office 2013 system if I double click on an mdb file it uses an access 2010 runtime rather than my Access 2013. I think which version it uses on a double click depends on how the file associations are set up.
You can pass the Word.Document object to the subroutine like:
Sub msReplaceCellData(WordDoc As Word.Document, OrigText As String, ReplaceText As String, r As Integer, c As Integer)
With WordDoc.Tables(1).Cell(r, c).Range.Find
.Text = OrigText
.Replacement.Text = ReplaceText...
While this not a complete answer to your question you might be able to use the shell command to do this. This would open the new database. You would have to copy an autoexexec and a module to it that would do whatever you want done before doing this. Below is some code that I used to open...
I've attached a zip file with the Word Document and Access DB I used the to test this. Maybe seeing how I tested it will help you incorporate it into your code. The test code is in a the module Word Table Cell Test.
I just notice that the code I posted had Tables(1).Cell(1, 1) rather than...
I think it has something to do with the theme. I noticed that if you go to the properties of the tab control (TabCtl7), Format tab and change Use Theme to No the appearance of the tabs go back to more like what one would expect.
I think your answer lies in the way they are doing it in this thread https://stackoverflow.com/questions/18609963/to-find-and-replace-a-text-in-the-whole-document-in-ms-word-2010-including-tabl.
In your case something like:
With WordDoc.Tables(1).Cell(1, 1).Range.Find
I'd bet the DISTINCT part of the record source query is your problem. Access typically doesn't like to update records that are part of an aggregate although I don't know why it would complain about just this one field.
Could this have anything to do with which record is the current record? If you scroll through the records does this occur on certain records?
Also I think I'd try to isolate whether this is a form problem or a problem with the form's record set. One way to do this would be to make...
I believe this would be very difficult to implement at the table level. Access has data macros (kind of like table triggers) but I find them hard to work with. At the form level you could use the DCount function in some event to determine if the item is a duplicate.