Reply:

Cannot log in using WindowsID (was able to before)
I just bought MS Money 2007 Deluxe yesterday. The install went smooth, without any issues. I registered a new WindowsID and was able to successfully log into MS Money. However, today when I tried to log into MS Money, the messge apeared that the "Money was not able to recognize your WindowsID" or something like it and that "You will still have access to some functions but will not be able to make online updates". Now I'm not able to make updates. Any idea what this could be? Is the authentication server for WindowsID down or something? See the post under Mon...

Can't use Merge feature
If I have a postcard file I've already made on the screen, when I try to pull up the "Merge" feature under Tools, it is shaded grey and I can't open it. It insists that I either form a new database list of addresses or edit the one that I want to merge. I don't want to edit the one I want to merge. I just want to MERGE it. If, however, I have just a postcard template on the screen (without it having been made into anything), I CAN pull up the "merge" feature under Tools. It is not shaded out. How do I un-shade the "merge" feature? To merg...

Restore Exchange 5.5 on 2000 using ArcServe
I've got - Windows NT 4 Server SP6 - Exchange 5.5 SP3 - ArcServeIT 6.61 with Exchange Agent I'm trying to restore the Exchange information (database, mailbox... everything) on another computer. That computer has - Windows 2000 Server SP4 - Exchange 2000 - Brighstore ArcServe 9 (build 2020) with Exchange Agent ------------------- Now the situation: I need to verify that the backup was made correctly (entirely) in order to confirm the total validity of the backup (to validate my disaster recovery plan) and to update to SP4. I tried to find documentation with both Microsoft (for Ex...

Computer Check Printing
Computer Checks Edit List is for a check run for one country (all the vendors in that countrY), but the vendors from another country show up as zero dollars. Any idea how to prevent this? It does not appear to be related to KB# 874437, as electronic payments are not used. Thanks in advance. ...

How to use structured reference (ListColumns) in VBA
I want to do something simple...loop through a range retrieving values one at time and taking action on that value. This range is an Excel 2007 table column. Easy enough...BUT I want to use structured references to a table column by NAME, not numbers. I don't want to define new names, just use the table column headings. I've found ways of doing it with quotes, but that's not structured....the names in quotes do not change if the table heading is changed by the user. The formulas change if the table column heading is changed, but I want it to change in VBA to...

Error- Project is used by another user -Please select another proj
Please see the subject line, when im trying to open a particular project. it gives me following error. I checked the current users, there are no users. Apart from me. There are some non PA users,i tried to remove them from activity. inspite of me removing them from activity, im geting the same error. Help !!! Ramakrishnan Hello Ram, There is a stranded user in PA000001 table. You need to clear this User/Project combination. Ajay "Ram" wrote: > Please see the subject line, when im trying to open a particular project. > it gives me following error. > > I che...

Save As using contents of Cell in Name
Can someone help with code that changes the "save As" file name to combination of the original File Name + the contents of a cell, an saves file in same folder as the original. E.G. Original File Name= Timesheet Cells B1= Location Cell C1 = Date in format 3-5-2004 Cell A1 = concatenate(B1,C1) Fle Name will therefore be "Timesheet Location 3-5-2004" The other problem is with the date. When concatenating, how do I forma the date to avoid it looking like "Location 38051" Any help much appreciated Nic -- Message posted from http://www.ExcelForum.com Hi for c...

Hot Dates
Hi, I have a Year-at-a-Glance worksheet into which users enter important dates and associated actions to be taken. I now want to use Conditional Formatting to highlight specific entries in the worksheet when their date matches today's date. The problem I have is that I need to convert data from three independent cells into a date to compare it with 'TODAY()'. The first cell (formatted as a number) carries the day, e.g. 2, 17, 23, etc. The second cell (formatted as General) carries the month, e.g. January, March, September, etc. The third cell (formatted as a num...

Using Excel in Mac office 2004 with Microsoft/Mac 2008:Analysis toolpack
Although I am disappointed with Office 2008 for Mac because of the absent of Analysis toolpack, I figured things out quite recently that I can still install my Mac office 2004 and use the excel package that contains the Analysis tool pack. How? ...... let me show you: 1. Insert your CD for Mac office 2004 2. When it open on your desk top, two options will be given to you to download the software (a) Office set-up assistant, and (b) Microsoft office 2004. 3. CHOOSE MICROSOFT OFFICE 2004 (Drag the icon onto your desk top) and it will start to run/download. 4. When done, this will appear as ...

How to obtain enumerated attribute declarations from a DTD using MSXML & VB?
I have a VB (VB6, not .NET) application that reads an XML file (using MSXML v3.2 parser); the XML file contains a reference to an external DTD. The DTD has numerous enumerated attribute declarations like so: <!ATTLIST MyElement MyAttribute (One | Two | Three) "One" > The VB code needs to generate dynamic pick-list for all the attributes that appear in the DTD as part of a data-entry application; each dynamically created pick list should contain all the allowable values for the attribute as defined by the DTD (and presented in some kind of multiple choice control like a comb...

Using Excel spreadsheet as input to Access
Hello, I posted this in the New Users forum but only got one answer, so thought I'd try here as well. Like so many others, I am an Excel newbie. I was a mainframe COBO programmer in another life, but that was a few years back My manager would like me to write an app that will take tracking dat from an existing Excel spreadsheet (generated by our system) but onl use a select handful of columns as input to a new Access database tha I will create. I'm guessing that I can either a) create a new edited spreadsheet to b used as input to the Access database or b) use the Import wiza...

Insert Static Date as part of Macro
I've built a nice macro, but I want it to insert the date it is run in an empty cell within the macro's range. When working within a spreadsheet, Ctrl +; returns the system date, but I can't figure out how to put that command into a macro. The macro recorder editor shows that the system recognizes the entry as the current date, not a function that returns the current date. The now() or today() functions are both dynamic ... they change with the system date. That's not acceptable in this situation. I need to seen when the macro was run. Thanks for any help, Ralph di...

Using subtotals as single data entries
Sorry about the subject--I couldn't figure out how to describe it simply. I have a large file (16,000 records) of amounts billed by roughly 10,000 service providers. A number of these providers have multiple office locations, so each record is unique to a specific office location. In other words, a provider who billed from 3 different office locations will have 3 entries. Each provider has a unique provider ID number, which stays the same regardless of which office location he is billing from. I want to be able to subtotal the amount billed by each provider for all their office locations...

Using Risk+ with MSP 2007
We use Risk+ as a risk simulation tool. We have discovered that it works approximately 20 times SLOWER in MSP 2007 than MSP 2003. Has anyone else run into this problem. If so, is there a remedy? My hunch this not a generic issue, but surely best that you consult with the Risk+ people on this. --rms www.rmschneider.com On 02/03/10 18:08, Tom Mc wrote: > We use Risk+ as a risk simulation tool. We have discovered that it works > approximately 20 times SLOWER in MSP 2007 than MSP 2003. Has anyone else run > into this problem. If so, is there a remedy? W...

How can I keep track of when (date and time) data is entered into.
I am trying to create a spreadsheet for a high school class. I need to be able to track when a student has entered data into specific cells of the spreadsheet. Any ideas? In the code behind the worksheet, enter (eg) Private Sub Worksheet_Change(ByVal Target As Range) Cells(1, 1).Value = Now() End Sub This will enter in Cell A1 the date and time at which any entry is made in that worksheet. If you need the location of the time-stamp to vary according to which cell is changed then you can test the value of Target and vary the destination cell accordingly. -- Return email address is n...

zz report date truncation
We run only z reports at end of day. We will be running cashier shifts soon and would like to run z and zz reports the way they were intended. Is there any way to truncate the zz report date for each register without it running since the beginning of time and using a truckload of paper? Thanks in advance! This may not be the most graceful solution, but you could simply turn off your printer before 'printing' the zz report. Then manually delete all print tasks for that printer before turning it back on. The report won't print, but RMS will think it did. "TV hardwa...

Historical IV Trial Balance
When running this report in Summary, I am receiving an error when trying to run with a date range. Has anyone seen this before? are you getting a duplicate error? If you are, then what you are experiencing is a bug. To fix, you will have to apply the latest service pack. Hope this helps. Rheiner "DavidInterDyn" wrote: > When running this report in Summary, I am receiving an error when trying to > run with a date range. Has anyone seen this before? I think so. I'll try that by applying SP 4 for 10.0 "Rheiner" wrote: > are you gettin...

how to use roundup
how to roundup the number to hundreds example 1250101 to 1250200 , 1250901 to 1251000 , 1250750 to 1250800 thank alot =ROUNDUP(A1,-2) -- Kind regards, Niek Otten "r4319hb" <r4319hb@discussions.microsoft.com> wrote in message news:A8D5EA24-858C-49D3-A5ED-481FEBEA36CB@microsoft.com... > how to roundup the number to hundreds example 1250101 to 1250200 , 1250901 > to > 1251000 , 1250750 to 1250800 > thank alot =CEILING(A1,100) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "r4319hb" <r4319hb@discussions.microsoft...

Excel
Hi, I would like to know if there is a way to set up when I enter the data each cells on first row, it will default the date and time stamp on first row. 2nd row should have the different date and time stamp than 1st row. I put "=now()" but it create the same date and time for 80 rows. I don't want that. I want to enter each rows and each rows should be different by one minute apart but same date - June 22. Your help would be much appreciated. Thanks Format A1:A79 as Custom dd-mmm-yy h:mm Select A1 Hold down CTRL Key and hit semi-colon key then <space> bar. Sti...

Using 'like' on a user prompt
I want to prompt the user for a value to use to filter a form. Here is my command with the WhereCondition: docmd.OpenForm "test", acNormal, , "LastName=[Enter a Last Name]" I want to use the WhereCondition as a "LIKE" criteria. Variations on the WhereCondition itself that I've tried include various combinations of LastName LIKE %...% LastName LIKE *...* LastName LIKE [%...%] LastName LIKE [*...*] You get the idea... No luck so far. Any thoughts? On Thu, 27 May 2010 21:52:50 GMT, "RicDon" <u60397@uwe> wrote: >I wan...

Using online services from Europe
I'm going to be temporarily stationed in Europe for a couple of months. Are there any problems with my using M2002 to access my accounts, pay bills, etc, from there just as I do from the US? TIA You should be fine, so long as you have a 128 bit encryption version of IE. If you do have problems, please feel free to post here :-) -- Glyn Simpson, Microsoft MVP - Money Check http://support.microsoft.com/default.aspx?scid=fh;EN-GB;mny for UK tips and fixes for MS Money. To send Microsoft your wishes or suggestions, use http://register.microsoft.com/mswish/suggestion.asp or email mnyukwsh...

Date changing 2028....2029......1930???????
Hello! I have a slight problem, in my form i have a date section which is automated as 00/00/00. I use these for part of a report as a from this date to this date, if you put 010125 it will automatically change it to 01/01/2025. The thing I have found is that it is fine until you get to 010130 and then it saves it as 01/01/1930 :-/ any ideas? Thank You Jay -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200703/1 Assuming you're using XP, go to Regional Settings in the Control Panel, and click on the Customize button. Look on the...

Leave Balance As of Date
Urgent response requested for this query. This inquiry is pertaining to ‘Annual Leave Inquiry’ screen in GP 8.0. The “Leave Balance As of Date” values are displayed incorrectly for new employees joined in 2006. Incorrect values are appearing in the Employees Leave Balance List Report as well. The Year End Leave process for the year 2006 was conducted on January 4th. The leave calculation for all the new employees is starting from this day i.e. 4th January. However, the leave entitlement value is correct. If an employee joins in May and his annual leave entitlement is 30 then it sho...

Change Opportunity Date to Quarter info
Hello, could you help me to convert MS CRM 4 Opportunity Estimate Close Date to Quarter info (and set quarter info to new field) I'll do it on field onchange function. sample : 2010.01.03 change to 2010Q1 2010.04.23 change to 2010Q2 So I need code for onchange funktion :) B.I. On 17 Gru, 15:40, "B.I." <aid...@jdjdjd.lt> wrote: > Hello, > > could you help me to convert MS CRM 4 > Opportunity Estimate Close Date to Quarter info (and set quarter info to new > field) > I'll do it on field onchange function. > sample : > > 2010.01.03 change...

Any way to change the transaction date?
I had a wierd issue recently when the server was restarted it went back to 1/1/2003 I replaced board battery to fix the pblm but for reporting porposes is there any way to move the sales data for what the system thinks is 1/1/2003 to 1/28/2007? you can do so by using following query: take the backup before performing the operation: update [Transaction] set Time='2007-1-28' where year(time)=2003 and month(time)=1 and day(time)=1 update Journal set Time='2007-1-28' where year(time)=2003 and month(time)=1 and day(time)=1 update TransactionHold set TransactionTime='...