Recent content by WorkingVBA

Thank you all for putting me back on the right path. All the replies were really helpful and I enjoyed reading all of the additional information. I was so used to my sloppy technique that I hadn't even considered using ByVal. Thanks to the The_Doc_Man for the gentle ribbing about not pressing...

Hi All, It has been about 4 years since I have done any programming and I am working on a project to parse a long description string, "~" delimeted, in a query. I am making progress and have thusfar been able to capture the substrings using the GetStr() function (all code is below) I am now...

Hi, I am in the process of building a MS Access application that constructs a word document based on predetermined choices. It has been a while so I feel like I am stumbling a bit in the dark. Depending on particular user choices the application builds a document consisting of predetermined...

Ok, I think I found it: The problem was in that the textbox On_Exit and On_Lost_Focus events were somehow messing with the results of the .SelStart property. I solved it by capturing the cursor position (.SelStart) in the Mouse_Up event (after the user clicks in the textbox - when the user...

Thanks sxschech, I played around with the suggested code, which I had not seen before. However it deals solely with inserting the text in the textbox and not with retrieving the contents from the clipboard. Using it brings a host of additional problems, for example, you have to call the code...

Hi, I am trying to add a "paste plain text" button in a textbox with rich text enabled to prevent formatted text from being entered. (there may be a better way to do this and if you know it I am all ears) The idea is that I paste the content of the clip board in the cursor's location which is...

OK, Just a quick update. This seems to have taken care of the problem and it works like a charm. If I need to explain what is going on, drop me a response but I've got to go now. Have a great weekend. Private Sub btnExit_Click() ' Exit button will reset the button and close the form...

Adam, thanks to you as well for joining in. I figured out part of the problem: First I was using a DoCmd.quit on the form's Exit button. Cancel = True does not stop that. Second, CloseCurrentDatabase (when you click no to close the form and leave the database open) acted strange. I did...

Thanks for checking Spike, And yes I am sure, other wise I would not have posted this :D I think, based on your findings, that there is something else going on. I will check and see if I can figure it out. I will post any updates.

Spike thanks for joining the conversation. The first time you close MS Access by clicking the MS Access window X (Close) you get the right response: varResp = MsgBox("If you want to EXIT Access completely, press YES. " & vbCrLf & _ "If you want to CLOSE the program...

No I don't want to go that drastic, just a message confirming if you really want to exit (VS accidentally hitting a close button) I find it hard to believe that this is not some default setting in the database options.

Thanks, It is not the form's close button that is causing the problem, it is the MS Access window's close button that users inadvertently click to close a form, which when they do closes the data base instead. It is this I would like to prevent. So if you are exiting the application...

Hi, I found this code in the forum to confirm closing the database. For some reason it works fine the first time around if you close MS Access by clicking the X (i.e. the quit is canceled), but if you do it again it goes ahead and closes anyways. Anyone know what is happening? Thanks for...

I kind of solved this one already, but was wondering if I had missed something before. If I did not, someone else might be able to use this. I have a simple continuous report, and I was using the alternating row color feature. Then I decided that I wanted one group separated by a thin line...

Dave, How would you go about doing this? I get "A form with a subform object can't have it's DefaultView property set to Continuous Forms" error.