Recent content by Randix

Pat...back in August you posted the suggestion to put double quotes rather than single quotes around a text field if it can contain single quotes (apostrophes)... Here's my current line of code: Set rst = db.OpenRecordset("select * from old where Left(field3, Len(field3) - 1) + Right(field2...

I have the following line in my code... Set rst = db.OpenRecordset("select * from old where trim([field3])+trim([field2]) = '" & Trim(Me.Field3) + Trim(Me.Field2) & "';") It works fine EXCEPT when it gets to a name that has a "'" in it, such as O'Dell, etc. Can anyone suggest a solution?

Rich...your solution was right on the mark. By using an unbound text box, it works fine. Naturally I have one more related question...not sure if this is obvious or not, but if I have 4 unbound text boxes, with about 1/2" space between each one, one after the other, vertically, and there's...

I have a report that has multiple memo fields. In one of the memo fields called "lic", my "goal" is to not have it print if it's empty. No matter what I do, Access reports an error which seems non-existent to me...for example, this is what i put in the report... IIF(IsNull([lic]),"","Update")...

For some reason, every time I go and try and use an "IIF" statement in a control source on a report, where it involves a memo field, I get an error message that I have a comma in the wrong place, eg: IIF([srm_memo] Is Null, " ", "Update") Is there something about memo fields that makes this...

I want to use the OpenReport command in conjunction with a wherecondition that contains multiple variables. I realize you don't use the word "WHERE", but I can't come up with the right expression. For example, if i want to include records where x=12 and x=35, how would i include it? svar2 =...

Rich--use the DoCmd.RunCommand in conjunction with what? Sendkeys "+{F2}"?

I have a form with one text field and multiple memo fields. I want the memo fields to expand whenever user enters them. I've tried Sendkeys "+{F2}" and it works when user first enters. However, why when you leave the field, and then return to that same field, it doesn't work again?

If a particular form is open, I want to do certain things. How do I determine if a particular form is open or not using code?

I have a custom toolbar that I want to use in conjunction with a form. How do I use code to designate that it should be on the top of the page?

I have a custom toolbar and menubar for a particular form. Question is, how can I position it on the top of the form? I've tried simply putting in the property for the form, and also using code to insert it, but msoBarTop, etc. are not being recognized.

Thank you Chris.

If I have a form and want certain fields to be invisible in the event certain fields meet certain criteria, where do I place the criteria?

I have a combo box on a form. When the form opens, I want the combo box to automatically open up and drop down the list...suggestions how to accomplish??????

Thanks! As usual, about the same time you posted, I finally figured it out...must be therapeutic posting here Thanks again for your assistance! Love this place.