Recent content by zp162002

Has anyone experienced performance issues when using Information Worker as an add-in in MS Outlook 2010? The users in my organization are experiencing delays from approximately 5 seconds to 30 seconds when attempting to open an email or send an email. It seems Info Worker will query the Epicor...

Hi Everyone, My team has developed a few customizations to allow users to search for call logs and to send emails via the CRM module. Unfortunately, unless you're logged in under a full license, you cannot see these customizations. Epicor said users must login using a shortcut which contains...

The reference window opens right up. I put the module in a new database on it worked fine.

I can open the References window without any difficulty. Do you suggest reinstalling Access?

Hello All, I am having trouble using Access 97. When compiling a module containing the following line of code, strFirstName = Right(strFullName, intFullNameLength - intCommaPosition) I receive the following error message: Compile Error Can't Find Project Or Library. When I click ok, the...

Thanks guys. I'll give it a shot.

That's what my problem is - I have apostrophes in the string. I'm using Access 97 (I know - my company is way behind the times) and it doesn't recognize Replace. Isn't there a way to replace the apostrophes using some Ascii code?

AuctionNum is a text field. It can contain either text or numbers. Is there a more efficient way to code this?

Thanks Trevil. The code works great.

Hello All, I'm trying to find a record in a table based upon two fields from a form using the code below. rs.FindFirst "[SellerNameID] = '" & strSellerName & "' And [AuctionNum] = '" & strAuctionNum & "'" Each time this line of code executes, I receive an error message stating: "Run-time...

Hi All, I would like to populate a combo box using a recordset. This is the code I have so far: Private Sub Form_Current() Dim strList As String Dim db As Database Dim rs As Recordset DoCmd.Maximize Set db = CurrentDb Set rs = db.OpenRecordset("tblAuctionNum", dbOpenDynaset) rs.MoveFirst Do...

Is there a function in Access 97 that is similar to the round function in Excel?

Thanks guys. I appreciate your help.

What's the best way to loop through the list of items in the list box? I'm assuming I have to do this to pick the correct index number of the value chosen by the user.

I would like to populate a text box using a value that was selected from a list box. Both the text box and list box are on the same form. Does anyone have any suggestions on how to code this? I'm assuming I have to loop through each item in the list box until I find the value that the user...