Search results for query: *

Thank you. I formatted dates in strFilter using the format function: strFilter = "[f3] Between #" & Format(Me.Combo11, "m/d/yyyy") _ & "# and #" & Format(Me.Combo13, "m/d/yyyy") & "#" and it worked correctly.

I am having problem in passing WhereCondition in Docmd.OpenReport: DoCmd.OpenReport stDocName, acPreview, , strFilter The issue is with the DateFormat. I created a sample database to explain my issue. Selection Form of report has a variable strFilter and is assigned the following: strFilter =...

I ended up installing Firefox version 3.0.3 where the drop down list is showing as usual. So, I created the new album using Firefox.

When I double clicked the error, I got the following details: Line: 272 Char: 1 Error: ‘this.exclude_ids’ is null or not an object Code: 0 URL: http://www.facebook.com/editalbum.php?new Previous button was enabled and Next button was disabled in the error message window. I clicked Previous...

I am using Internet Explorer 7. I am facing an issue in Internet Explorer while using Facebook. When I use Photos application and click Create a Photo Album, several options are shown under Privacy field. In the Customize option, I get the option of Some Friends. Here I can choose specific...

hi, i checked the links and couldn't find the key,any other why to solve the problem? thanks,

Hi All, i have a small network with isa server 2000,opearting systems are winxp 2000 and windows vista Ms outlook is not working in windows vista.i updated isa client and sp2 for isa server, but still same problem,if i use a wireless router then its working.would you help me to solve the...

We have a LAN network with ISA server 2000 all operating systems with Microsoft outlook are working. Except ms outlook is not working in windows vista. If I use a wireless router then ms outlook is working in windows vista.why it is not working with isa Client??

Thanks a lot. It worked perfectly in my scenario. Slightly modified the formula to display results in columns A, B and C: Entered the following in A2: =PMT(0.1,3,-$D2,0)/1.1^(4-COLUMN()) and copied to B2 and C2

I have an amount that I have to distribute over 3 years. Distribution needs to be such that there is an amount for Year 1, Year 2 amount will be 10% of Year 1 amount and Year 3 amount will be 10% of Year 2 amount. An example is: Cell D2 contains 3,310 I need to display the following in cells...

Thanks. There is no other criteria that could separate employees between ratings other than appraisal score. I consulted with senior management and it was agreed not to exceed the threshold value for A and C rating in any case. So, it was finalized to include two employees having rank number...

In an Excel Sheet, I have a list of employees and their final scores out of 100 in annual performance evaluation. There are twenty employees in the list and data values are as follows: Column A: A3 = Appraised A4 = Emp1 A5 = Emp2 A6 = Emp3 A7 = Emp4 ... ... A23 = Emp20 Column B: B3 = Total...

We are using a financial software application in our organization. For print output, we are using a Dot Matrix Epson Printer. We have installed Epson Printer Driver on computers that are using this application. Recently, we purchased a new computer for an accounts officer. Motherboard of this...

Thanks for all your help and support. Below is the final code listing in my scenario: Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ErrorHandler If Target.Cells.Count > 1 Then If Evaluate("=COUNTA(" & Target.Address & ")") = 0 Then 'This is a delete operation...

Thanks PHV. The following code worked: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Then MsgBox "Multiple Selection not allowed" Application.EnableEvents = False Target.ClearContents Application.EnableEvents = True End If End Sub Clearing the...

Thanks Skip and combo. I did not state that columns E, F & G are for ratings A, B & C respectively. I said ratings are entered on a letter scale of A, B or C for three headings/columns. These three headings/columns are Behavior, Occupation-Specific and Work Ethics respectively. For each of the...

I have made a performance evaluation system in an Excel Sheet. I am facing one problem in it. In this system, ratings are entered on a letter scale of A, B or C for three headings/columns. Each employee gives rating to each other employee. User can enter A or B for any employee. Blank entries...

In our organization, earlier we were using Exchange Server, but now we are connecting to a POP3 e-mail server to download our emails. We are using Outlook 2003 as email client. We created accounts by selecting POP3 as server type. In Internet E-mail Settings (POP3), we filled name, e-mail...

I used ParameterFields as a work-around to this problem. The following code executed successfully: Dim Application As New CRAXDRT.Application Dim Report As New CRAXDRT.Report Private Sub Form_Load() Screen.MousePointer = vbHourglass Set Report = Application.OpenReport("C:\test\myrpt.rpt")...

I figured out the problem. But still I am unable to solve the problem and the report is being run with Report1.RecordSelectionFormula. For testing, I created a sample database db1.mdb having 1 table t1 with fields f1,f2 and f3. I created a sample report myrpt.rpt. In Database Expert, I shifted...