Search results

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.

I've a form that has two tables joined. When I go to add a combo box, i see that the third option to look up a record based on the selection is not available. Why do I feel I missing somethin'...? How can i use a combo box in this situation to bring up a record?

I'm using Access 97, have several reports that include logo's (jpg images). They look great. Am I correct that if one tries to email those reports, either using RTF or HTML, Access 97 does not support inclusion of those images in the report when emailed, along with rectangles, lines, etc.? I...

Thanks for the reply! After searching other posts here, I see some believe it's more efficient to not use an OLE object field, but just a text field, and shell to access the file reference in the text field, rather than linking to it...any opinions?

I have a report written to a file using rtf. In VB, I want to insert a link to that file in my table which has a field for OLE objects. Can anyone give me help on the code for that task? I'm looking at the help topic for the Action Property, but it's not "clicking" for me...I'll be using Word...

I've a button on an Access (97 version) form that starts Word and pulls up a particular Word document...how do i first check to see if the file exists before running the event?