Search results for query: *

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

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

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?

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

Can anyone please give me a quick example of how I would go about populating a list box on a form using data from a table with two fields - SellerID and OtherID? I want to look for every record that contains a particular SellerID (this will be on an underlying form) and to have all the...

Hello everyone. Is there an easy way to copy a cell's formatting properties (ex. align text in center of cell, change the fill color from white to green) down a column in Excel 97? I have some code that checks to see if there is a formula in the first cell in a range. If there is a formula...

Does anyone have an idea on how to select a range in a particular row (Ex. U9:DA9) and to loop through the range testing if there is a formula in each cell. If there is a formula, I would like to copy the formula to each cell in the column.

I have a field that contains an input mask for a short date which seems to work fine when first entering the date. The problem is when a user goes back to edit the field and tries to edit a single digit. For example, there is a date of 9/09/02 and the user wants to change the date to 9/16/02...

I need to create a filter that will accept double quotes inside a string. My current line of code is: strFilter = "[SpecificMatter] = """ & Me.SpecificMatter & """" This will accept single quotes but not double quotes. Can anyone help me? Thanks in advance.

I need to create a filter that will accept double quotes inside a string. My current line of code is: strFilter = "[SpecificMatter] = """ & Me.SpecificMatter & """" This will accept single quotes but not double quotes. Can anyone help me? Thanks in advance.

Hello everyone. I was wondering if someone could show me the most efficient way to loop through a character string. I'm going to take the data from a notes field and put it in a variable. I then need to look for characters ascii(30) and ascii(31). When I find 31, I will need to tab. When I...

Hello everyone. I would like to test a field to see if it contains a valid date. The format at this time does not matter - I only want to make sure it is a valid date. Any ideas how I can code this? Thanks in advance.

I need to change the sort order of a query so letters sort after numbers. Any suggestions on how to do this? Thank you.

I would like to create a form (similar to a pop up form) to allow a user to run some reports. Currently when the user clicks on a command button to run a particular report in preview mode, the pop up form keeps the focus and floats on top of the report. How can I code this form to allow the...

I would like to use a form to allow a user to specify the criteria to be used to print a report. This report is based on a query. I would like to use text boxes on the form. The text boxes will not always be populated depending on the information the user chooses to enter. Does anyone have...

I would like to run a report which is based on a form that allows the user to enter certain criteria into textboxes. There are 2 text boxes for the user to enter a project number and a bulk number. The report I am running is based on a query that prompts for the project number. How can I...