Search results

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?

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

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.

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

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

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?

I have 11 tables, and each record in each table has lots and lots of fields...over 20 memo fields alone for each. I need to build a report that combines one record from each table, but includes all fields associated with each record. Any suggestions on how to start building a report that...

Simple question...I have a table that has a field called "Control_num" that is defined as a number. There's another field in the same table that has a field called "tr_num". Upon entering the "tr_num" field, I simply want the highest number that appears in any of the records in the...

I realize you can position a MsgBox, but is there anyway to control its size?

Where can I obtain information on how to access/choose functions in Outlook and incorporate them in Access? In a previous message reference was made to the Outlook Object Model...where that might be found?

I'm using Access97. You know those application icons that are part of Access? I know how to make other icons flash using the timer, but is there any way to address the icons/bitmaps which are part of Access to include those in my code?

If you're in a form, and have a button to open up another form, how do you close the current form and open up the new form at the same time?