Recent content by philbullock1223

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...