Im confused! Can anyone "un"-confuse me?

Im sorry this post is so long. I'm trying to  include as much info as
possible so you can tell whats going on.  
Here's the scenario:
I have a workbook with two tabs (Main & Data). The main sheet is where
the user will enter data and the data sheet is where the code will
dump the data. There is a combo box on the Main sheet from which the
user will select the current date. Now when the user the selects the
date and then enters the data on the page, the user will then click a
button (called Save Data) on the main page at which point the data
will be transfered to the Data sheet. Then when a new date is selected
from the combo box the sheet is reset to blank cells. Here is the
question. If you look at the code below the top section was written by
someone else and it all works fine. about 2/3 down you will notice a
comment section where I state that I added the rest of the lines. The
lines I added to the code will work to a point. When you click the
Save Data button the data is transfered to the Data page. BUT...
When you select a new date from the combo box the data referenced by
the code I wrote does not reset. It carries over to any date you
select. I am totally confused why my code (which I simply copied and
pasted from the previous code and changed cell references) does not
work correctly. Again, I apologize fro the length of the post.

BTW OfficeXP XL2002 WinXP pro

Thank you for reading all this.
Dave



Worksheets("Data").Range("B" & FoundOnRow) = Range("N3").Value    '
Store
    Worksheets("Data").Range("C" & FoundOnRow) = Range("K3").Value
' Preparer
    Worksheets("Data").Range("D" & FoundOnRow) = Range("H9").Value
' GSFR
    Worksheets("Data").Range("E" & FoundOnRow) = Range("H10").Value
' GSDTR
    Worksheets("Data").Range("F" & FoundOnRow) = Range("H12").Value
' ST
    Worksheets("Data").Range("G" & FoundOnRow) = Range("M10").Value
' OSBLC
    Worksheets("Data").Range("H" & FoundOnRow) = Range("M11").Value
' OSBC
    Worksheets("Data").Range("I" & FoundOnRow) = Range("M12").Value
' OSB1
    Worksheets("Data").Range("J" & FoundOnRow) = Range("M13").Value
' OSB5
    Worksheets("Data").Range("K" & FoundOnRow) = Range("M14").Value
' OSBOB
    Worksheets("Data").Range("L" & FoundOnRow) = Range("M15").Value
' OSBQ
    Worksheets("Data").Range("M" & FoundOnRow) = Range("M16").Value
' OSBD
    Worksheets("Data").Range("N" & FoundOnRow) = Range("M17").Value
' OSBN
    Worksheets("Data").Range("O" & FoundOnRow) = Range("M18").Value
' OSBP
    Worksheets("Data").Range("P" & FoundOnRow) = Range("M19").Value
' OSBOC
    Worksheets("Data").Range("Q" & FoundOnRow) = Range("M23").Value
' CSBLC
    Worksheets("Data").Range("R" & FoundOnRow) = Range("M24").Value
' CSBC
    Worksheets("Data").Range("S" & FoundOnRow) = Range("M25").Value
' CSB1
    Worksheets("Data").Range("T" & FoundOnRow) = Range("M26").Value
' CSB5
    Worksheets("Data").Range("U" & FoundOnRow) = Range("M27").Value
' CSBOB
    Worksheets("Data").Range("V" & FoundOnRow) = Range("M28").Value
' CSBQ
    Worksheets("Data").Range("W" & FoundOnRow) = Range("M29").Value
' CSBD
    Worksheets("Data").Range("X" & FoundOnRow) = Range("M30").Value
' CSBN
    Worksheets("Data").Range("Y" & FoundOnRow) = Range("M31").Value
' CSBP
    Worksheets("Data").Range("Z" & FoundOnRow) = Range("M32").Value
' CSBOC
    ' I added these lines of code but when i save data
    ' and go to a different date the numbers remain on
    ' the new page
    Worksheets("Data").Range("AA" & FoundOnRow) = Range("D20").Value
' BDBAG1
    Worksheets("Data").Range("AB" & FoundOnRow) = Range("D21").Value
' BDBAG2
    Worksheets("Data").Range("AC" & FoundOnRow) = Range("D22").Value
' BDBAG3
    Worksheets("Data").Range("AD" & FoundOnRow) = Range("D23").Value
' CREDIT
    Worksheets("Data").Range("AE" & FoundOnRow) = Range("E20").Value
' BDINI1
    Worksheets("Data").Range("AF" & FoundOnRow) = Range("E21").Value
' BDINI2
    Worksheets("Data").Range("AG" & FoundOnRow) = Range("E22").Value
' BDINI3
    Worksheets("Data").Range("AH" & FoundOnRow) = Range("E23").Value
' CREDITINI
    Worksheets("Data").Range("AI" & FoundOnRow) = Range("F20").Value
' BDAMT1
    Worksheets("Data").Range("AJ" & FoundOnRow) = Range("F21").Value
' BDAMT2
    Worksheets("Data").Range("AK" & FoundOnRow) = Range("F22").Value
' BDAMT3
    Worksheets("Data").Range("AL" & FoundOnRow) = Range("F23").Value
' CREDITAMT
End Sub
0
dpotter41 (25)
8/8/2003 3:15:48 AM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
368 Views

Similar Articles

[PageSpeed] 44

Sorry to do this, but unless you are able to figure out the answer
from the code i posted (in which case  I believe you are clairvouant)
I think Idetermined that the problem is not in the code i wrote, but
in a different macro in the module.  SO, I am including the entire
module. If this is inappropriate to do in a newsgroup, please let me
know since i am kinda new around here.

Dave

the module (GetSaveData):

Option Explicit
Public FoundOnRow As Long
'******************************************************************
' Purpose of the following is simply to replace the values on the
' Main worksheet with those found in the Data table for the
' date that was entered in the Drop Down
'******************************************************************
Sub GetData()
' Insure that the Main worksheet is active
    Worksheets("Main").Activate
    ' Call the sub to get the Row number associated with the selected
date
    GetTheRowNumber    ' FoundOnRow
    ' Perform a series of VLookups to populate the sheet with the
results
    Range("K3").Value = Worksheets("Data").Range("C" & FoundOnRow)
    Range("H9").Value = Worksheets("Data").Range("D" & FoundOnRow)
' GSFR
    Range("H10").Value = Worksheets("Data").Range("E" & FoundOnRow)
' GSDTR
    Range("H12").Value = Worksheets("Data").Range("F" & FoundOnRow)
' ST
    ' Range M10 to M19 is the Opening store bank.
    ' The values here should be pre-populated from the Closing store
    ' bank from the previous day.
    'Need to check first that we're not on the first day of the year
    ' as we'll get an error (since there isn't a line above)
    If FoundOnRow = 7 Then
        ' In this case only, we'd have to open up the worksheet for
the
        ' previous year and extract the values from the last day.
        ' For the time being, we'll just use this annoying message box
        MsgBox "First day of the year"
    Else
        Range("M10").Value = Worksheets("Data").Range("Q" & FoundOnRow
- 1)  ' CSBLC (yesterday)
        Range("M11").Value = Worksheets("Data").Range("R" & FoundOnRow
- 1)  ' CSBC
        Range("M12").Value = Worksheets("Data").Range("S" & FoundOnRow
- 1)  ' CSB1
        Range("M13").Value = Worksheets("Data").Range("T" & FoundOnRow
- 1)  ' CSB5
        Range("M14").Value = Worksheets("Data").Range("U" & FoundOnRow
- 1)  ' CSOB
        Range("M15").Value = Worksheets("Data").Range("V" & FoundOnRow
- 1)  ' CSBQ
        Range("M16").Value = Worksheets("Data").Range("W" & FoundOnRow
- 1)  ' CSBD
        Range("M17").Value = Worksheets("Data").Range("X" & FoundOnRow
- 1)  ' CSBN
        Range("M18").Value = Worksheets("Data").Range("Y" & FoundOnRow
- 1)  ' CSBP
        Range("M19").Value = Worksheets("Data").Range("Z" & FoundOnRow
- 1)  ' CSBOC
    End If
    Range("M23").Value = Worksheets("Data").Range("Q" & FoundOnRow)
' CSBLC
    Range("M24").Value = Worksheets("Data").Range("R" & FoundOnRow)
' CSBC
    Range("M25").Value = Worksheets("Data").Range("S" & FoundOnRow)
' CSB1
    Range("M26").Value = Worksheets("Data").Range("T" & FoundOnRow)
' CSB5
    Range("M27").Value = Worksheets("Data").Range("U" & FoundOnRow)
' CSBOB
    Range("M28").Value = Worksheets("Data").Range("V" & FoundOnRow)
' CSBQ
    Range("M29").Value = Worksheets("Data").Range("W" & FoundOnRow)
' CSBD
    Range("M30").Value = Worksheets("Data").Range("X" & FoundOnRow)
' CSBN
    Range("M31").Value = Worksheets("Data").Range("Y" & FoundOnRow)
' CSBP
    Range("M32").Value = Worksheets("Data").Range("Z" & FoundOnRow)
' CSBOC
End Sub
'******************************************************************
' Purpose of the following is simply to replace the values on the
' data worksheet with those entered in the Main table for the
' date that was entered in the Drop Down
'******************************************************************
Sub SaveData()
' Insure that the Main worksheet is active
    Worksheets("Main").Activate
    ' Call the sub to get the Row number associated with the selected
date
    GetTheRowNumber
    ' Before allowing the user to save data, this is where we would
put
    ' in some data validation. For the time being, let's just make
sure
    ' that PreparedBy is filled in.
    If Range("K3").Value = "" Then
        MsgBox "Please fill-in your name as the Preparer"
        Exit Sub
    End If
    ' Replace the values in the selected row with the values entered
    ' in the main worksheet.
    ' Note that although we're storing the Opening Store bank, the
data isn't
    ' used to populate the sheets. It's probably unnecessary to keep
it if
    ' the Opening Store Bank will *always* the previous days Closing
Store Bank
    ' Actually, it may not be a bad idea to keep is since if the user
changes a
    ' value on the OSB you can check it against the previous days CSB
for
    ' any discrepancies. We'll get back to this later.
    Worksheets("Data").Range("B" & FoundOnRow) = Range("N3").Value
' Store
    Worksheets("Data").Range("C" & FoundOnRow) = Range("K3").Value
' Preparer
    Worksheets("Data").Range("D" & FoundOnRow) = Range("H9").Value
' GSFR
    Worksheets("Data").Range("E" & FoundOnRow) = Range("H10").Value
' GSDTR
    Worksheets("Data").Range("F" & FoundOnRow) = Range("H12").Value
' ST
    Worksheets("Data").Range("G" & FoundOnRow) = Range("M10").Value
' OSBLC
    Worksheets("Data").Range("H" & FoundOnRow) = Range("M11").Value
' OSBC
    Worksheets("Data").Range("I" & FoundOnRow) = Range("M12").Value
' OSB1
    Worksheets("Data").Range("J" & FoundOnRow) = Range("M13").Value
' OSB5
    Worksheets("Data").Range("K" & FoundOnRow) = Range("M14").Value
' OSBOB
    Worksheets("Data").Range("L" & FoundOnRow) = Range("M15").Value
' OSBQ
    Worksheets("Data").Range("M" & FoundOnRow) = Range("M16").Value
' OSBD
    Worksheets("Data").Range("N" & FoundOnRow) = Range("M17").Value
' OSBN
    Worksheets("Data").Range("O" & FoundOnRow) = Range("M18").Value
' OSBP
    Worksheets("Data").Range("P" & FoundOnRow) = Range("M19").Value
' OSBOC
    Worksheets("Data").Range("Q" & FoundOnRow) = Range("M23").Value
' CSBLC
    Worksheets("Data").Range("R" & FoundOnRow) = Range("M24").Value
' CSBC
    Worksheets("Data").Range("S" & FoundOnRow) = Range("M25").Value
' CSB1
    Worksheets("Data").Range("T" & FoundOnRow) = Range("M26").Value
' CSB5
    Worksheets("Data").Range("U" & FoundOnRow) = Range("M27").Value
' CSBOB
    Worksheets("Data").Range("V" & FoundOnRow) = Range("M28").Value
' CSBQ
    Worksheets("Data").Range("W" & FoundOnRow) = Range("M29").Value
' CSBD
    Worksheets("Data").Range("X" & FoundOnRow) = Range("M30").Value
' CSBN
    Worksheets("Data").Range("Y" & FoundOnRow) = Range("M31").Value
' CSBP
    Worksheets("Data").Range("Z" & FoundOnRow) = Range("M32").Value
' CSBOC
    ' I added these lines of code but when i save data
    ' and go to a different date the numbers remain on
    ' the new page
    Worksheets("Data").Range("AA" & FoundOnRow) = Range("D20").Value
' BDBAG1
    Worksheets("Data").Range("AB" & FoundOnRow) = Range("D21").Value
' BDBAG2
    Worksheets("Data").Range("AC" & FoundOnRow) = Range("D22").Value
' BDBAG3
    Worksheets("Data").Range("AD" & FoundOnRow) = Range("D23").Value
' CREDIT
    Worksheets("Data").Range("AE" & FoundOnRow) = Range("E20").Value
' BDINI1
    Worksheets("Data").Range("AF" & FoundOnRow) = Range("E21").Value
' BDINI2
    Worksheets("Data").Range("AG" & FoundOnRow) = Range("E22").Value
' BDINI3
    Worksheets("Data").Range("AH" & FoundOnRow) = Range("E23").Value
' CREDITINI
    Worksheets("Data").Range("AI" & FoundOnRow) = Range("F20").Value
' BDAMT1
    Worksheets("Data").Range("AJ" & FoundOnRow) = Range("F21").Value
' BDAMT2
    Worksheets("Data").Range("AK" & FoundOnRow) = Range("F22").Value
' BDAMT3
    Worksheets("Data").Range("AL" & FoundOnRow) = Range("F23").Value
' CREDITAMT
End Sub
Sub GetTheRowNumber()
' Find out the row for this entry.
' This is going to involve working with dates
' Dates in Excel suck and they hate me as much as I hate them.
' There's a better way to do this. I'll fix it later but this works
for now
' Make sure the Main sheet is active
    Worksheets("Main").Activate
    ' Set some variables for Year, Month and Day
    Dim SelYear As Integer
    Dim SelMonth As Integer
    Dim Selday As Integer
    ' Set the Year, Month and Day variables to the derived Year, Month
and Day
    ' taken from Main!N4.
    ' Note that the drop down on the Main sheet is linked to N4 so
that
    ' whenever the drop down changes, N4 will reflect the selected
date
    SelYear = Year(Range("N4"))
    SelMonth = Month(Range("N4"))
    Selday = Day(Range("N4"))
    ' Do a match to find the position of the date selected in the Data
table
    FoundOnRow = Application.Match(CLng(DateSerial(SelYear, SelMonth,
Selday)), _
                                   Sheets("Data").Columns("A:A"), 0)
End Sub


On Thu, 07 Aug 2003 23:15:48 -0400, Dave Potter
<dpotter41@chartertn.net> wrote:

>Im sorry this post is so long. I'm trying to  include as much info as
>possible so you can tell whats going on.  
>Here's the scenario:
>I have a workbook with two tabs (Main & Data). The main sheet is where
>the user will enter data and the data sheet is where the code will
>dump the data. There is a combo box on the Main sheet from which the
>user will select the current date. Now when the user the selects the
>date and then enters the data on the page, the user will then click a
>button (called Save Data) on the main page at which point the data
>will be transfered to the Data sheet. Then when a new date is selected
>from the combo box the sheet is reset to blank cells. Here is the
>question. If you look at the code below the top section was written by
>someone else and it all works fine. about 2/3 down you will notice a
>comment section where I state that I added the rest of the lines. The
>lines I added to the code will work to a point. When you click the
>Save Data button the data is transfered to the Data page. BUT...
>When you select a new date from the combo box the data referenced by
>the code I wrote does not reset. It carries over to any date you
>select. I am totally confused why my code (which I simply copied and
>pasted from the previous code and changed cell references) does not
>work correctly. Again, I apologize fro the length of the post.
>
>BTW OfficeXP XL2002 WinXP pro
>
>Thank you for reading all this.
>Dave
snip


0
dpotter41 (25)
8/8/2003 3:58:49 AM
Reply:

Similar Artilces:

Can I stop rounding in excel?
I am doing come calculations and end up with 139.7 for example. If I format the cell as a number with no decmial points it automatically rounds up to 140. Normally this is ok, but in this case I don't wnat it to round. Can I turn the rounding feature off? Jmadden wrote: > I am doing come calculations and end up with 139.7 for example. If I format > the cell as a number with no decmial points it automatically rounds up to > 140. Normally this is ok, but in this case I don't wnat it to round. Can I > turn the rounding feature off? If you format the cell as "gener...

I can't send-receive e-mails. Can i uninstall this and use outlook
If 2 days works perfectly, next day gives me errors.. I can't rely on this. I use it for business e-mail. Someone help please asap. This is the error: Account: 'mail.skyboston.com', Server: 'mail.skyboston.com', Protocol: POP3, Server Response: '.', Port: 110, Secure(SSL): No, Error Number: 0x800CCC18 Go to Tools, Accounts, select that mail account, Properties, Servers. Make sure that "Log on using Secure Password Authentication" is not = enabled.=20 --=20 Gary VanderMolen, Microsoft MVP (Mail) Microsoft MVP program: http://mvp.suppo...

can't launch newly installed GP
Hi, I've just installed a new instance of GP 10.0 (which already exists on our network) on a new workstation. However, when I try to launch, it pops up a dialogue box, telling me that I need to run GP Utilities before I can run GP, and asking if I want to launch Utilities now. If I say no, GP just closes (never having actually launched). If I say yes, Utilities launches and pops up another dialogue box, saying: "Select the task you want to complete and then choose Process. When you have completed all the tasks, choose Exit to close Microsoft Dynamics GP Utilities, or choose ...

jobvermittlung , jobboerse schweiz , jahr im ausland arbeiten , jobboerse karriere , arbeitsagentur jobs im ausland , jobs im ausland spanien , jobs in ausland ,
jobvermittlung , jobboerse schweiz , jahr im ausland arbeiten , jobboerse karriere , arbeitsagentur jobs im ausland , jobs im ausland spanien , jobs in ausland , + + + +++ TOPJOB AUSLAND +++ IM AUSLAND ARBEITEN +++ + + http://www.STELLENANGEBOTE-AUSLAND.NL http://www.STELLENANGEBOTE-AUSLAND.NL http://www.STELLENANGEBOTE-AUSLAND.NL http://www.STELLENANGEBOTE-AUSLAND.NL http://www.STELLENANGEBOTE-AUSLAND.NL + + + + + + + + Richter Richterin stellensuche arbeitsvermittlung jobboerse halbes jahr im ausland arbeiten job im ausland finden stellenanzeigen ausland stellena...

arbeiten im ausland australien , job boerse , Maler Malerin , SAP-Berater SAP-Beraterin , Heilpraktiker Heilpraktikerin , Versicherungsmakler Versicherungsmaklerin , arbeiten im ausland daenemark ,
arbeiten im ausland australien , job boerse , Maler Malerin , SAP- Berater SAP-Beraterin , Heilpraktiker Heilpraktikerin , Versicherungsmakler Versicherungsmaklerin , arbeiten im ausland daenemark , + + + +++ TOPJOB AUSLAND +++ IM AUSLAND ARBEITEN +++ + + http://www.STELLENANGEBOTE-AUSLAND.NL http://www.STELLENANGEBOTE-AUSLAND.NL http://www.STELLENANGEBOTE-AUSLAND.NL http://www.STELLENANGEBOTE-AUSLAND.NL http://www.STELLENANGEBOTE-AUSLAND.NL + + + + + + + + arbeiten im ausland fuer deutsche jobangebote ausland stellenangebote fuer ausland arbeiten im ausland afrika...

Chart of Accounts IM upload error
I get this error when i try to use IM for upload of the chart of accounts "DOC 1 ERROR: Account number 1103-001-00-000 contains undefined segment information." I have checked the account format but could not figure out why, could you guys help !! To stop this message do the following: Go to cards, financial, account and start entering an account number. When the message comes up about segments, choose the option that stops the message from appearing. You should be able to import the chart after that. "DIGI" <DIGI@discussions.microsoft.com> wrote in message new...

Can't import OE6 account information into Outlook
I've got a whole load of mail in my OE6 box and am trying to migrate it to Outlook 2002. All the messages etc have come through, but the account information for all the email addresses I have is not being done. If I manually try to Import via Import -> Internet Mail & Account Settings, I get "No Internet Accounts were found to Import". Help appreciated. do you have more than one identity in OE? -- Diane Poremsky [MVP - Outlook] http://www.poremsky.com - http://www.cdolive.com Outlook Tips: http://www.outlook-tips.net/ Expert Zone http://www.microsoft.com/windowsxp/ex...

can you use outlook with an aol account?
I was about to change ISPs to AOL, but wonder if you would be able to use Outlook instead of the AOL bespoke email software. I would be grateful if someone could advise. Yes, you will find some links to AOL help pages here: http://members.aol.com/adamkb/aol/mailfaq/imap/ "eric_bristow" <eric_bristow@discussions.microsoft.com> wrote in message news:84E6353B-0941-4216-872B-0DFF061E8DDB@microsoft.com... >I was about to change ISPs to AOL, but wonder if you would be able to use > Outlook instead of the AOL bespoke email software. I would be grateful if > someone coul...

How can I make my text in an email wrap around automatically?
I am a new user to Outlook 2007 and when I type an email message, it is not automatically wrapping to the next line. How can I fix this? Any assistance would be greatly appreciated. Thank you! Tools, Options, Mail format, Internet format trainer07 wrote: > I am a new user to Outlook 2007 and when I type an email message, it is not > automatically wrapping to the next line. How can I fix this? Any assistance > would be greatly appreciated. Thank you! ...

Formula that can exclude Sat and Sun
Hi, Is there any formula that can help to exclude Sat and Sun in a month? Thank you --- Message posted from http://www.ExcelForum.com/ Here is the help details on the NETWORKDAYS function Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term. If this function is not available, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enabl...

how can I add a yahoo account to outlook
hi everyone, Is it possible to add a yahoo account to outlook? You can pay Yahoo for POP access to your account - it's a small annual fee. Alireza Amini wrote: > hi everyone, > Is it possible to add a yahoo account to outlook? unless you have the paid account that offers pop3 access, you can't. Outlook uses webdav and yahoo doesn't. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Author, Google and Other Search Engines (Visual QuickStart Guide) Outlook Tips: http://ww...

Can't get third outlook account to show up
MS Outlook 2k3 This is frustrating me, I did the typical add email stuff and all went well, but now the email isnt showing up in my arranged list (arranging by accounts so I can view all my emails at the same time) When I try to send an email, however, I can choose this account from the accounts drop down menu, and it will send an email. any ideas? i've been searching forever. So you're using the Arrange By | E-mail Account view on your Inbox and you don't see this 3rd e-mail account as one of the groups? First, do you have any e-mails actually FROM that account to show? I...

Can't add new accounts
Whenever I try to add a new account to my money file I get a message saying: "A file needed to run the Planner is either missing or corrupted. To resolve this problem, reinstall Money and then reopen your Money file." I have tried reinstalling as suggested and same thing happens. I get the same error message. I am using Money 2004 Standard V12.0. If I create a new Money file and add an account it works fine. I also tried starting from the backup and did a a repair only to get the same message. You can get a registry fix from http://www.mvps.org/money/faq.htm for this -- Glyn...

Can I run proprietary Windows Software on Remote Desktop?
Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC I am using a PowerPC G5 Mac Mini. I am taking a course that requires a minimum of Windows XP or Vista. Can I install the course software on Remote Desktop so that I can use it to take this class, or is this just for using MS Office programs? Also, what is the cost of this service? On 3/24/08 12:03 PM, in article ee95dbc.-1@webcrossing.caR9absDaxw, "boyerml@officeformac.com" <boyerml@officeformac.com> wrote: > Operating System: Mac OS X 10.4 (Tiger) > Processor: Power PC > > I am using a PowerPC G5 Mac ...

Unloading NDIS IM Filter driver
I am using NDIS Intermidiate filter driver in my application. My application is successfully installing and uninstalling the driver Can anyone tell me How to unload NDIS IM filter Driver? Thanks for any guidance. Mark Smith dev.mark.smith@gmail.com > Can anyone tell me How to unload NDIS IM filter Driver? Via INetCfg API? --=20 Maxim S. Shatskih Windows DDK MVP maxim@storagecraft.com http://www.storagecraft.com On Aug 6, 11:44=A0am, "Maxim S. Shatskih" <ma...@storagecraft.com.no.spam> wrote: > > Can anyone tell me How to unload NDIS IM filt...

Can't get SUM function to work in Excel 2000
I don't know what I'm doing wrong. All I'm trying to do is add a column of numbers. In cell L13, my formula is =SUM(L2:L12). All I get back is 0. I've checked the formatting of the cells and they are all numeric. I have also tried adding cells manually, e.g., =L2+L3 -- and I get the correct result. I'm pretty sure I've used this function before without any problems. What am I doing wrong? I was having a little problem with setting the formatting. Most of my spreadsheet contains wrappable text, and I had set the style for that. Then when I tried to adjust my num...

How can I create a folder under user's Inbox for all domain users #2
Dear all, Is there any approach to create a folder under Outlook 2k's Inbox for all my domain users in Exchange server-end (Exchange 2k3)? or any tools/scripts to do this? And how can I set a Server-end rules for all the uses to deliver some specific email to this folder? Thans for your inputs. Redd I would hazard a guess that you can do this by merging .pst file with Inbox and folder in it with EXMERGE util. Redd wrote: > Dear all, > > Is there any approach to create a folder under Outlook 2k's Inbox for all my > domain users in Exchange server-end (Exchange 2k3)? ...

Can I run the Dbcc Shrinkdatabase command on a company database
We have a client who is near the 2 Gbyte MSDE limit but the database shows 400 mb unallocated. Can we run the shrink database command to buy them some time. They will need a newer server to support SQL express 2005. Also what is the trunc.sql command Cannot seem to find any info on it. The DBCC SHRINKDATABASE command worked like a charm. Found the info in MSDN. Good thing I did not run truncate as that would have deleted data. "Ger" wrote: > We have a client who is near the 2 Gbyte MSDE limit but the database shows > 400 mb unallocated. Can we run the shrink database co...

CRM Mobile Un-install
hi, We have a client who we have installed CRM Mobile for. We have had a couple issues, in which we have worked though with Microsoft. The end result of this was an un-install and re-install of the CA service and CRM Mobile. I was curious of a couple things if someone could help, Do all users have to be logged out? or just CRM Mobile? Could we just detatch and delete (mobile) databases and then un-install CRM Mobile? Is there any specific processes in which we should follow for the un-install? CA and then CRM Mobile or vice versa? Any help at all appreciated! Thanks, Nathan Warner -...

Can't send mail (undeliverable) from POP3 in Outlook
I have configured a POP3 account in Outlook (XP) and can receive messages on it but can not send. All messages come back from "System Administrator" saying: Your message did not reach some or all of the intended recipients. Subject: RE: Sent: 10/28/2004 2:33 PM The following recipient(s) could not be reached: 'xxxxxx xxxxxs' on 10/28/2004 2:33 PM 550 5.7.1 <xxxxxr@xxxxxxxxx.com>... Relaying denied I have checked to make sure that the account was entered accurately and tried sending with the firewall off, all to no avail. I have h...

How can i import my messages from a hotmailaccount to microsoft ou
How can i import my messages from a hotmail account to microsoft outlook or from a yahoo account. Not sure if they allow for exporting to external clients but you might want to check the online help for each system. "chappychain" <chappychain@discussions.microsoft.com> wrote in message news:C361DAFF-AB80-4F8D-B7E3-F8F4C972577E@microsoft.com... > How can i import my messages from a hotmail account to microsoft outlook > or > from a yahoo account. chappychain <chappychain@discussions.microsoft.com> wrote: > How can i import my messages from a hotmail...

Can I be aware of the point of launching any applications?
Hi, there. Actually, what I want to do is making the transition effects between the desktop screen and the screen of launching applications which can be any windows applications. So I need two captured buffers, one is for the current screen and the other is for intial screen of launching applications. But I have to get the intial screen buffer of launching application before it is displayed on the screen. Also, I have to prevent the intial screen buffer from displaying on the screen until the finishing of transition effects. The questions, 1. Can I be aware of the point of launching a...

IMS Redundancy
Hi All, I have an Exchange 5.5 environment with sites located worlwide. In the London sit I have three servers, with one server hosting the IMS. I need to make this more redundant. How can I? I tried installing a second IMS on another server but it prompts saying that one is already installed. Any suggestions Thanks, Mohammed ...

Can't undo a scheduled bill in the budget
In Money 2004, I have a category that used to have a scheduled bill. I've since changed the bill amount and category using the "bills" section. But the bill still shows up in the budget: old amount, old category. So my budget is skewed by exactly the amount of this old bill. Trouble is, I can't find the old bill anywhere else to delete it. If I edit the category in the budget, money doesn't show the monthly charge. If I go to bills, this old bill doesn't show up, so there's nothing to delete. Puzzled and frustrated. Anyone see this before and have ...

Can't get rid of sounds
XP Pro SP3 IE8 I have just installed IE8 and have a small but annoying problem. The only sound I use is 'new mail notification' Since IE8 I have four sounds under 'windows explorer' that I cannot get rid of. The googled answers don't work They just say change the sound to 'none' and it will stop. This does not happen. Doesn't matter what I try the sounds come back! How to get rid of them. They are :-Feed discovered,Information Bar,start Navigation and Blocked PoP up window. Any help please. Hi Joe, Tools>Popup Blocker>Popup ...