Search results for query: *

I am using a VB macro to save my document with the filename I provide. I want to use the current date and time in the file name. I use the following code: Option Explicit Private Sub CommandButton1_Click() dtdate = Format(Now, "yyyy-mm-dd_hh_nn") ActiveDocument.SaveAs filename:="C:\temp\" &...

I am using MS Word and VB 6.3. I need to save my document at the close of the document. I would like to code the path and filename of the document. My current code is below, this code works so far, however, Words save dialogue box opens after I exit the save dialogue box I created. Can I...

I am using Crystal 10 on Win Xp machine. I use OBDC connection to Intersystems Cashe driver to Cashe database. I need to display services provided to clients that were active during the date range provided. Tables utilized tx_history_all , Movement_history. I create a parameter (?date) using...

Hi, I am using MS SQL 8.0. I have created a view using two tables both fields are date fields. One of the fields is start date ( always the same) the other field is changedate ( used when staff change position). I need to filter out all changedates except for the most recent. Then I need to...

Hi, I am using Crytal 10 pulling data using OLE connection to SQL database on Windows XP workstation. I have a report the produces two shared datevars startdate and startplusgrace. Is it possible to drive my main report using these two shared datevars. I need to run these dates against my...

I am pulling data from a cashe database on Win XP machine using Crystal 10. How do I Add days to a date. I want to use DateAdd("d",+7,startdate) is this good syntax and if I want to get the date 37 days ago can I use DateAdd("d",-37,startdate)?

Hi, I am pulling data from a cashe database on Windows XP workstation using Crystal 10. I am modifying a productivity report ran by my company on a monthly basis. I am tasked with granting new staff and staff moving to new positions a grace period. The grace period for new staff is 2 weeks...

Hi, I am pulling data from a cashe database on Win PX workstation. I am using Crystal 10. My question is can I pass variable values from my main report to my subreport?

Hi All, I am pulling data from a Cache database using Crystal 10 on a Window Xp workstation. I data in a text field that I need to brake out into seperate variable to be displayed and manipulated. Here is an example of the data ".60&7.83&1.45&3". This is the formula I want to use to pull the...

Hi, I am running Window Xp machines in a Windows Server 2003 environment. I need to set all my user as "Power user" on their local workstations. I would like to accomplish this using GPO unless there is another optin that does not involve me physically touching each machine. Can anyone help...

Hi, I'm using VB macros in microsoft Word Templates to pull client ID and name and place on the document. I have begun today to modify my macro to open "SaveAs" dialogue window. That part is working correctly. However, in my SaveAs window i am coding the file name to pull the Name , document...

Hi, i am running Crystal 10 pulling data from cashe database on WinXp workstation. How do Group my report on the Month of the year (Jan) when I am using a date field for my parameter I using a date range to run the report. The date range would be, for example 1/01/2004 - 12/31/2004. The...

Hi, I working in a Window Server 2003 environment and all workstations are Win XP. I am attempting to install Winzip 9.0 using a logon script. The script listed below works well, with the one exception. It does not disconnect the mapped drive created during the logon and install. Please...

I am using Crystal 10 on Win XP machine. I pulling data from a Cashe database. I have converted a Crystal 8.5 report to Crystal 10. The report and the formula will work in Crystal 8.5 but the same formula will not run in Crystal 10. When I open the report I immediately get the message that...

Hi All, I am working on a WinXp workstation pulling data from a Cache Database. I am using Crystal 10. I have created mailing labels for our Business Office. I used the template wizard and labels look great. There is only one problem. Different client for each label. I need a different...

Hi, I am running Windows 2003 Servers with Win XP Workstations. I need to install on all of my workstations the Winzip application. Winzip has provided a login script which will work but only if my users are administrators. We have a domain policy in effect which prohibit basic users from...

I'm running Cisco's CallManager 3.3. I have a group of 4 extensions and users that work as a call center for our facility. All calls come in on extension 7000 and then rollover to a backup extension 7001. We have a call pick group 70, which my four users are in and utilized answer all calls...

Hi, I am running Microsoft Office Xp on Xp machines. I have several macros that I wrote several years ago. There all working fine until recently. My documents I save as .DOT and then my headers are not visible. They will print and I get them in the print preveiw. But my Macro will not run...

Hi, I running Call Manager 3.3 and Unity Voice system. I am reorganizing the call routing within our Mental Health Facility. When a client call he will have a choice of 4 options. Press 1 If you are not an active client. Press 2 If you are an active client. Press 3 For other options. If you...

Hi, I am using Crystal 8.5 on Windows Xp PC. I need a formula that will check for puncuations in client names. Thank you