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

...(A or B) are to be entered for 20 employees. Suppose I enter A in cell E4, copy E4 and paste in from E5 to E10. Now rating A has become 35% ((7/20)*100), which is not allowed. So, in case of multiple selection, since the Worksheet_Change event is fired after the Paste operation, so I need to...

...for heading 3 (Work Ethics). Formulas in these cells are as follows: F27: ROUND((COUNTIF($F$4:$F$23,"A")/(COUNTIF($D$4:$D$23,"Administration")))*100,0) F28: ROUND((COUNTIF($F$4:$F$23,"B")/(COUNTIF($D$4:$D$23,"Administration")))*100,0) F29: IF(OR(F27>0,F28>0),100-F28-F27,0) (Administration...

...are calculated in cells E27, E28 and E29 for heading 1 as follows: E27 (For Rating A): ROUND((COUNTIF($E$4:$E$23,"A")/(COUNTA($D$4:$D$23)))*100,0) E28 (For Rating B): ROUND((COUNTIF($E$4:$E$23,"B")/(COUNTA($D$4:$D$23)))*100,0) E29 (For Rating C): IF(OR(E27>0,E28>0),100-E28-E27,0) To...

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

...Private Sub Form_Load() Screen.MousePointer = vbHourglass Set Report = Application.OpenReport("C:\test\myrpt.rpt") Report.SQLQueryString = "Select * From t1 where f1 between '1' and '3'" CRViewer1.ReportSource = Report CRViewer1.ViewReport Screen.MousePointer = vbDefault End Sub I have 5...