Recent content by deedar

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