Search results for query: *

Hello all, I'm currently using Lebans RTF tool on a form and report. The control source of the RTF is the same table field (named "Analysis") for both the form and report. For the RTF control on the form, I set the default font size to 14. For the RTF control on the report, I set the default...

Hi dRahme, Thanks for your response. I have a question about your suggestion though: Does MoveSize resize only the form? - or does it resize all the controls and subforms also?

Hello all, I apologize in advance for the long question, but I wanted to make it clear..... This is a problem I've had for quite some time now and it seems to be erratic. Sometimes my forms enlarge automatically for an unknown reason. Meaning that, I have forms that are originally sized at...

Thanks a lot! It works great now!

Hi Hymn, Thanks for the suggestion. Yes, I've tried that and receive this error message: "Object doesn't support this property or method" Anything else I can try? I'd really love to get this feature to work.

Hello all, I'm currently using Leban's RTF2 ActiveX control on my forms, which works great (it allows text formatting). Now I need to "tweak" my reports to accommodate the formatted field. My old reports are designed so that the field in question has: Can Grow = Yes Can Shrink = Yes How...

I *finally* figured it out! Thanks so much for your help Gary. At first I didn't know what you were referring to when you asked for the name of the control for the subform on the main form. Yes - you were right, the name of the subform control and the name of the subform itself were different...

Hi Gary, I get this error message when using your code: "...can't find the field 'subform name' referred to in your expression." I can't figure out what's wrong!

Thanks for the response Gary. I just realized what part of my problem is.... Usually, if I'm working on a main form and type "Me." a list of possible objects displays for me to choose from. I just noticed that my subform is not part of that list, but it should be. Any suggestions for why the...

Hi Mac, I tried your suggestion, but that's not working for me either. Do you know of anything else I can try? Thanks! A.

Hello, I have a very general question about memo fields on forms. Is formatting only certain text in memo fields allowed? For example, I want to bold only one word in a sentence in the memo field. Whenever I highlight and bold the word, all words in the field are made bold also. I don't want...

Can anyone please help me with this vba code? I'm trying to set a label caption on a subform, depending on the "IndxType" value on the main form. This code is on the subform's OnLoad event: Dim indextype As String indextype = Forms!FrmSearchIndexMain.IndxType If (indextype = "Mkt") Then...

sorry -- just realized i posted in the wrong section of the site.

Can anyone please help me with this vba code? I'm trying to set a label caption on a subform, depending on the "IndxType" value on the main form. This code is on the subform's OnLoad event: Dim indextype As String indextype = Forms!FrmSearchIndexMain.IndxType If (indextype = "Mkt") Then...

cmmrfrds posted a reply that i didn't see when i posted mine. i should clarify. what worked for me was PHV's suggestion.

that worked!!! thanks a lot! just curious now, WHY that worked? what does Nz mean?

Hello all, I'm having a bit of trouble trying to understand why the following two queries return empty sets: ---------------------------------------------------------- SELECT * FROM A, B WHERE A.ActualRelease <> B.ActualRelease; ---------------------------------------------------------- SELECT...

Thanks for all the help. The "DELETE DISTINCTROW" did the trick!

Hi John, Based on the thread you recommended, I went back and doubld-checked my tables. Both tables are already indexed using "Autonumber - No duplicates". But I'm still unable to run the delete query.

Hello all, I'm having some problems with the following DELETE query: DELETE TblHistory.* FROM TblHistory, TblHistoryTemp WHERE TblHistory.Name = TblHistoryTemp.Name AND TblHistory.Release = TblHistoryTemp.Release AND TblHistory.Period = TblHistoryTemp.Period; When running it, I receive this...