Search results

I'm not sure what I'm doing wrong, but I'm trying to implement the code above and I'm having no luck. I'm getting an error "Method or data member not found" and Workbooks is highlighted. I thought maybe it was the references, but I tried adding Microsoft Excel 8.0 Object Library to no avail...

Yes. I would use a for statement. The following example will search the first 500 cells in column 1 for "Test" and if found place the word "Test" in column 3 of the same row: For r = 1 to 500 If cells(r, 1) = "Test" Then cells(r,3) = cells(r,1) End If Next

There are a few things you can do. The simplest would probably be to catch the error in an error handler. I believe you would place this in the before upadate event of the form: On Error GoTo ErrHandle 'Additional Code can go here GetOut: Exit Sub ErrHandle: If Err.Number = put error number...

You don't need to thank me, just the forum. How do you think I learned how to write code?:D

Since I'm not a hundred percent positive what you are trying to do, I'm not sure if this suggestion will be helpful to you. One possible solution is to make the Word Document a mailmerge document. You can insert fields in it directly from access. When you open it the text in the field you...

Give an example of what would constitute a violation.

I'm assuming you want the history table to contain a history of all changes (not just the most recent one). If you copy and paste the following in the beforeUpdate event of the form it will detect if a change has been made and ask the user if he wishes to save it. If he answers yes, it will...

I had Lotus Notes open at the time I tried it, so that shouldn't be the problem. But what is a MAPI client?

Before explaining what I would do with the OnChange event, I need to know whether your table is storing the entire record when changed or certain fields when changed. The OnChange (or the on enter) event will not work if you are wishing to save the whole record.

I don't currently have the time to research automation, though I hopefully will later this week. The code you provided gave me the exact same error "ActiveX component can't create object" at approximately the same line "Set objNotesWS = CreateObject("Notes.NotesUIWorkspace")". Could I be...

I ran into a situation where the wizard setup my combo box improperly. What I had done was made the form a data entry form. The wizard then did not code the AfterUpdate event of the combo box properly (it assumed since it was data entry that it did not need to). To bypass this, I just turned...

You can use the INSTR function to look for a string criteria in the middle of an expression. This will return the position of @ in the email field. If @ is missing the position will be 0. If InStr(1, email, "@") = 0 Then MsgBox "You must enter the @ sign." End If You could also use the...

In your query, click your totals button and in the total field of Action# select Group By.

I'm not sure what you were trying to say about the relationships in your last post, but if your not worried about having multiple addresses for the same company, I can share with you how I have done something similar in the past. After update of the company field, do the following: Private...

To copy you use DoCmd.RunCommand acCmdCopy. However, you probably won't want to copy exactly. The solution you choose will partly depend on what the table looks like where you are moving the data. Does it contain all the fields from your record or is it just storing the FieldName and...

In this scenario changing the sourceobject is your best move. I have written one application where my whole interface is done through subforms. I have twenty+ subforms swapping out with each other, simply by changing the SourceObject.

The following example was found in the Access help files. For more detailed information search for destination in access help: INSERT INTO Clients IN 'C:\Data\Clients.mdb' SELECT Customer.[CompanyName], Customer.Phone FROM Customer;

I have looked at several threads that turned up through the search feature, but I have never been able to figure out how to interface Access with Lotus. We use Access 97 and Lotus 4.51. I tried using a bit of code that seemed promising, but I keep getting an error message "ActiveX component...

To add the code, go into the design view of your form and click view/code. Just copy and paste it there at the form level. Depending on which version of Access you are using the first two lines may already be there. As for the list boxes. Let me try to rephrase it a little clearer. This...

RichMorrison is more than likely better qualified to address your table/query structure, so I will exit that end of the conversation. Throwing in my two cents would likely just result in more confusion. As for dragging between two lists, I will attempt to detail what is involved. In your...