Search results

sneuberg, thanks for the input. I tried your code with the same error. I don't know much about the reference builder. Is there anything you can help me with there? I do know how to create a query (outside vba), but I'm not sure how that is useful. This code does seem to work fine, but...

Thanks for your input Ranman. The name of MY subform is Subform1 and Subform2. Maybe this wan't clear.

I am trying to change a nested subforms recordsource in vba from the main form. Many online sources give me this solution, but when I run this I get an error: Me.Subform1.Form.Subform2.Form.RecordSource = "SourceTable" I get the error: You entered an expression that has an invalid reference...

I found my solution at this link: http://www.informedcorp.com/Access-Development-developers-page.html The Data Mover sample database was exactly what I needed! Huge help!

Sorry, I didn't mean looping. I meant that it uses the "INSERT INTO" command which I have already tried. Thanks for the suggestion tho pbaldy. Much appreciated!

pbaldy, thanks so much for the input, but unfortunately this method won't work because it loops through the record to copy. I have a set of code that does this effectively for almost all records. Unfortunately, when I have an attachment field, this method seems to fall apart. For example, this...

No problem jdraw. Many records in my recordset don't differ by much, so having a "duplicate" button is valuable for quick entry. With that said, I also want this "duplicate" button to duplicate the child records in another few tables also. In it's simplest form, you can think of me needing a...

I need to duplicate a record in a table. I have been successful in duplicating the parent record with this code: DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdCopy DoCmd.RunCommand acCmdRecordsGoToNew DoCmd.RunCommand acCmdSelectRecord DoEvents...

JHB, thank you so much for your response. You obviously spent some time to make it easy for me, and I truly appreciate that. Unfortunately, that doesn't answer my question. Let me rephrase: When I am moving a textboxt WITHOUT a layout NEAR a set of textboxes inside a layout, Access tends to...

When trying to move textboxes around the form, many times, particularly if I have overlapping elements, the textbox wants to enter a Layout (red line or box inside a Layout table). Is there a way to prevent this from happening? For example, I am trying to move a set of option buttons over top...

One last question and I think I will have everything I need. If I try to update the HTML code with the .Document.Write strHTML command, I get a duplicate of the code (i.e. it will say Hello World twice). What command can I use to clear out the code so I don't get a repeat? :banghead: Phil

I got it to work with a few tweaks! Still not sure the exact reasoning, but we are all good now! Thanks again Static. You were a HUGE HELP! :D Private Sub Form_Load() Set webControl = Me.Wb.Object With webControl .Navigate "about:blank" End With Me.TimerInterval =...

I changed the code so I don't need the Set Web = Wb.Object. With that said, I get the same error. I am able to find Navigate under F2->ShDocVw->webbrowser under classes. Can you tell me how to "delete" a control. I can unclick the checkbox and reclick it, which I have done a few times with no...

Static, thank you so much for the reply. I am getting the error "Method or Data Member Not Found" on the .Navigate. I have tried to fix this issue, but all of the resources I have read indicate that I must turn on Microsoft Internet Controls in the references. I have confirmed Microsoft...

I am trying to display HTML code inside a Access Web Browser Control. I have been successful in making an html document and setting the control source to the file in the Web Browser Control. This isn't an ideal solution. I have been searching how to solve this for a while. Someone said this...

Thanks. I'm also puzzled by the "on activate" event not firing. I have two forms. The first form has a table subform. When the user double clicks on a record in the subform, another second form containing much more information pops up. Sometimes the user will change information on the pop-up...

All, Thanks for the response. I truly appreciate it. Regardless of the Me.Refresh or Me.Requery, I can't get the trigger to flag. I put Debug.Print "WORKED" inside the trigger events, but it was never flagged. Me.Refresh works great for me, because I have a manual button on the form that...

I have a pretty simple question.... I need to trigger a refresh on a form when I move the "focus" (i.e. click on one from and then another) from one form to another. I have tried putting Me.Refresh in the: 1. On Activate 2. On Got Focus 3. On Current .....but these don't seem to work. I...

I finally got to try these suggestions out with no luck. Your example links are very close, but I still can't seem to get anything I do to remove the overwrite warning. I'm no expert in this area. Thanks so much for your help. Still unresolved. Phil

Ah... I understand. I've been looking for one, with not luck. Anyone else know of anything else I might be able to try? Phil