Reply:

Time Calculation 03-26-10
I am kind of beating my head over this problem. I am trying to create a rule by where the user cannot enter data if todays date is greater than a function date - max time given in a query So lets say the user has 72 hrs to respond before an event date lets say Jan 1, 2010. I tried this so far but its not working : EventDatePlusMaxTime: DateDiff("n",[functiondate]+[maxtime],[functiondate]) On Fri, 26 Mar 2010 14:57:01 -0700, smartcookie <smartcookie@discussions.microsoft.com> wrote: >I am kind of beating my head over this problem. > >I am t...

Can't remove MS Office Test Drive
I can't seem to remove test drive. I have seen some previous posts, so I tried to Repair disk Permissions first, then ran Remove Office from the folder called Office 2004 for Mac Test Drive. It searches for files to remove, but the results are blank, and all it will do is Quit. The folder is in my Applications, and has size of 330 MB. I am running OS 10.4.8 on MacBook. Problems started when I mistakenly dragged my app's from my old eMac onto my new MacBook, instead of installing them from CD. I was able to remove the main MS Office 2004 folder (by running Remove Office from its ...

GP10 Service pack rollback
What do I need to do if for example the Service pack install on the server fails (power failure), what are the rollback steps? I know I need to perform a restore of Dynamics and company databases, but what about the application? what files are modified within the GP folder? There are no rollbacks that I'm aware of. After restoring Dynamics and the company databases, I would uninstall GP10 and reinstall GP10 and the service pack you were at before starting your upgrade. I would also contact MS, if possible. -- Dick White MCP, MCTS "nelazuela" wrote: > What do I ne...

installing SafePay 10.0
Hello: If a client has over thirty companies in GP 10.0 and will only use Safe Pay in say two of those companies, is it OK to just install the module in just those two companies? Or, do you absolutely have to install it in all thirty companies? childofthe1980s Installation of the software is installation wide. You install the chunk files needed on all pcs. Once the software is active, it will require its files, on all companies. You do not have to configure it for use on any other companies but it it requests the files to be created, the message will recur until the files are crea...

does office 97 produce Genograms
hi can any tell me if 97 has templates for genograms Genograms aren't too tough to construct. Time and patience is basically all you need. A nice example is here: http://www.genopro.com/genogram/ -- Mary Sauer http://msauer.mvps.org/ "Gordon" <gordon.alsopp@ntlworld.com[gandalf]> wrote in message news:C213D7E3-432B-48E4-97AF-0947A7482C4E@microsoft.com... > hi can any tell me if 97 has templates for genograms ...

filepath excel 2007
Hi, I would like to know if there is a better way to do this. I have 4 worksheets (WH1, WH2 etc) that linked the value of 1 workbook to another WH1 cell X34 i have a formula ='O:\path\path\path\[filename July 2009.xlsx]Rpt'!$K$84 WH2 cell X34 i have a formula ='O:\path\path\path\[filename July 2009.xlsx]Rpt'!$H$83 The thing that changes is month in the filename & the cell that it links to eg. K84. Currently i import a text file so i only have to change those 2 values. -- HT Just do it with Find-Replace. You could even put the target and replacement values in c...

Conditional formating #12
how can i apply the same format to all the pages in the document without having to do it on every page? (change a word green?) <w-o-t2442squadron@live.co.uk> wrote in message news:3712bda8-5d64-43d4-a9c1-aafb32ac1beb@z25g2000vbs.googlegroups.com... > how can i apply the same format to all the pages in the document > without having to do it on every page? (change a word green?) Select and copy the entire worksheet with the right formatting. Then go to a worksheet you want to format in the same way - select cell A1, edit, paste special, Formats and hey presto. V On Dec 17, 5...

Excel 2007 display wrong "document in use by ... "message
When person A creates an Excel file and saves it, Person B opens it and C tries to open it concurrently to person B, C receives the wrong message "<doc-name> is locked for editing by person A". This should be person B. People lose time finding the real editor on the document! ...

Project Server 2007 VSTS Connector
Hi The connector is installed ok. The browse web site connector messaje: service unavailable? What do I? Thanks You Eleonora Hi, Maybe this will assist: http://pstfsconnector.codeplex.com/Thread/View.aspx?ThreadId=28200 "Eleonora Peña Rodriguez" wrote: > Hi > > The connector is installed ok. > The browse web site connector messaje: service unavailable? > > What do I? > > Thanks You > > Eleonora > > ...

Issue with While loop and Access 2007 datasheet
Hello Guys, I have modified the order details form in Northwind 2007 and I am having an issue I hope you can help me with. It is a form with a dataaheet that you use to enter line items into a transaction. Each row contains the fields ITEMNAME, QUANTITY PRICE, DISCOUNT, SUBTOTAL, BENEFIT TYPE. Each line item in a transaction should be assigned to a particular benefit type. I have a piece of code that goes through the data sheet and checks to make sure that the benefit type field is not empty. The problem I am having is that if I enter 3 items and dont put a benefit type for any ...

SQL Server 2008 R2 Native Client backward-compatible to SQL 2005/2008??
We have several different SQL Server versions in our datacenter, with SQL Native Client 9.00.1399.06 on our Citrix servers. The above SQL Native Client goes with our Great Plains app client, it's possible we will have a new, higher-level SQL Native Client installed by another application client... Can different Native Clients exist on the same server, can newer Native Clients accommodate older SQL Server versions and applications??? Issues or 'gotchas' I should know about?? Thank you, Tom tom12010 (tlyczko@gmail.com) writes: > We have several different SQL Se...

Add new Data Series in Excel 2007
Back in the old days in Excel 2003 when I had a graph and I wanted to add a new data series all I had to do was click on Chart-->Add Data and it was easy to do. How do I add a new data series, and more importantly tell it whether I want the first column to be the x-values etc. Like in the old days when I added in data series to a previously established chart? Hi, Select the chart then use the ribbon, Chart Tools > Design > Data > Select Data > Add. Or right click chart, Select Data > Add. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info &...

Connector for MS Dynamics CRM 3.0 and MS Office Accounting 2007
Hi all, It seems that MS Dynamics CRM integration with other ERPs has been quite a talk here! We are also doing integration works for MS Dynamics CRM and MS OA2007. As we bridge the gap between the two solutions, we need CRM users, small business specialists and interested professionals who are willing to be advisors for this endeavor. Advisors will have the chance to influence the features of the software we are building and will get to evaluate pre-release versions of our application. If you are interested, you could visit our site for the advisor program: http://gurangosoft.com/advisor.as...

Outlook 2007 freezing uppon clicking 'To...'
Hi all, I have 2 installations with a strange behavior. When I click 'To...' in a new message Address Book is opening but after that Outlook is freezing and became a nonclickable one :( The same situation can repeat 25 time, and only 26th is good enough to choose from the address book. Any workaround? Thanks in advance This is a very common problem which Microsoft claims they cannot reproduce and therefore cannot solve. Anecdotal reports claim the following may help: 1. Look for and correct a corrupt address in the Contacts displayed in the Outlook Address Book (especially i...

2000 versions compatible with Office 2007
We have a few access databases that when opened say they are the "Access 2000 file format". Most of the users are using Office 2003 and maybe 1 or 2 with Office XP. I would like to install Office 2007 on my system. I am the one that goes in and makes changes to the databases when needed. My question is after I install Office 2007 will I still be able to do this and everyone else will still be able to use the databases after I have opened and made changes to them with Office 2007? Thanks, Chad Yes: they are backwards compatible. Access 2007 can natively work with mdb file...

Access 2007 cant open an immediate window with a 2000 mdb
The local 2007 access machine i have can open the mdb modules and immediate window. However on a client site the same mdb will not open with their version of access 2007. Its not a user name issue we checked that and i installed all the vb6 stuff on the client site and still nothing. the odd thing is if you have the 2000 mde on the client site you can open an immediate window. So its just the mdb. Any help would be greatly appreciated. On Wed, 13 Jan 2010 14:04:11 -0800 (PST), Tenrosei <tjmaxwelliv@gmail.com> wrote: >The local 2007 access machine i have can open the mdb mo...

Deployment Manager 10-31-03
Until you enter your first license key, you must be logged into the OS under the same login that you designated as the Admin login for CRM. ...

Outlook 2007 & Messenger...
.... how do I integrate those two on a Vista-system? -- Kind regards �yvind Granberg tresfjording@live.no www.tresfjording.com "�yvind Granberg" <tresfjording@live.no> wrote in message news:96D6543C-9214-4128-B84E-C2ABE769E388@microsoft.com... > ... how do I integrate those two on a Vista-system? Integrate them in what way? -- Brian Tillman [MVP-Outlook] Well I have figured it out, but I am not impressed. Is there any way that I can see if a sender of a certain email residing in the inbox list up, is presently online? -- Kind regard...

Integration Manager 10.0 Import Invoice Entry
Hi there, I am trying to import invoice entries from an external application (MYOB) into the invoice entry section of GP 10.0. IM seems to have GP destinations for Sales Order Transactions but not invoice entries. I thought I might get around this by using the direct to table adapter but this destination adapter appears to have been removed from IM 10.0. Does anyone know how to import data into invoice entries (Transactions-Sales-Invoice Entry) into GP 10.0? alternatively is there some way to use a direct to table adapter with IM 10.0? Thanks I've never used Direct to table, so I...

GP 10 Modified Payroll Check
With the new and improved security for GP 10 I seem to be having a little difficulty with getting the proper payroll check layout to print correctly. I need to get the Employee Checks Other - L to print. I have reviewed all security settings and still no luck with getting this to print properly. Any assistance on this would be greatly appreciated. Thanks Hank On Jan 11, 11:41=A0am, kgarro...@gmail.com wrote: > With the new and improved security for GP 10 I seem to be having a > little difficulty with getting the proper payroll check layout to > print correctly. =A0I need to get ...

Outlook Out-Of-Office is Missing
I am using Outlook with a POP3 account, not Exchange. On the Tools menu, there is no option for Out-Of-Office. How do I create an out-of-office response just for new messages received (not going to all the old messages in the Inbox)? Thank you. See if the information on the following page helps: http://www.slipstick.com/rules/autoreply.htm -- Jocelyn Fiorello MVP - Outlook *** Replies sent to my e-mail address will probably not be answered -- please reply only to the newsgroup to preserve the message thread. *** "Arthur" <priver2@comcast.net> wrote in message new...

Line charts with missing data points in Excel 2007
The data points will not connect in a line chart due to missing data in between. I see a thread where you can solve this problem by selecting the interpolation option in Tools menu > Options > Chart tab. But I can not find this Chart tab options under Excel option in Excel 2007. Could someone please tell me how to deal with this problem in Excel 2007? Thank you very much. turen turen - Right-click a point of the data series, choose Select Data from the shortcut menu, on the Select Data Source dialog box click Hidden and Empty Cells, click (Show empty cells as:) Connect da...

Microsoft CRM 3.0 web service and InfoPath 2007
I have been trying to use InfoPath 2007 to call the CRM web service to create a record. It appears that you can't do this. Is there a .NET compatibility issue between these two products or some other reason this wouldn't work? The idea is to create a form that populates data into CRM and then starts a CRM workflow. Any comments from the experts? Thanks...Russ Hi, It's very well possible, however some coding involved. Use the Microsoft CRM 3.0 SDK which you can download from Microsoft. Next use Visual Studio to create a webservice which will be needed by the InfoPath form ...

Visual Report Project 2007
How do I create a new report. When I choose New Template and choose the options in the New Temaplte Dialog box, I hit Ok. It immediately generates the view and I can't figure out how to save the template. All of those templates are in a specific directory. You need to find that directory and save the template file to that. Hit Manage Templates to open the folder. On my machine, it looks like: C:\Users\username\AppData\Roaming\Microsoft\Templates - Andrew Lavinsky Blog: http://blogs.catapultsystems.com/epm > How do I create a new report. When I choose New Templ...

Outlook 2007 Issue
Windows XP Pro SP3, Microsoft Office Professional 2007. Sometimes when replying to different emails in Outlook 2007, after I click the SEND button, the following error message appears: "An error occurred in the underlying security system. The supplied handle was invalid." This does not happen all the time, just once in a while and with different people. Can someone point to a cause for this and how I might be able to fix this issue? Thanks ...