Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Sweetworks
  • Content: Threads
  • Order by date
  1. Sweetworks

    Excel 2010: Multiple Pivot Tables Grouping, change grouping other Pivot Tables.

    Hello, I've created some reports in Excel. I have one sheet that has all the raw data, and then a separate sheet for like 6 different reports. Each report is a simple pivot table. I am able to group it by Month for some reports and by day (7 days with a Sunday starting date) for other...
  2. Sweetworks

    Network Projector - Issues with Wireless

    I have a WLC4136 wireless controller with AP1020 access points. The wireless network runs fine. I have recently purchased an NEC P350W projector. It has network projecting capabilities. I have the projector wired into our network as it has a LAN port One can connect to the projector (Win 7 -...
  3. Sweetworks

    Current Year in a View

    We have a select statement on a View. It is "SELECT (Form = "Phone Call Log") & @Year(SUS_MeetingDate) = 2013". We would like to change that to Current Year. Something like. "SELECT (Form = "Phone Call Log") & @Year(SUS_MeetingDate) = @CY".
  4. Sweetworks

    Help with Agent to Delete Records

    I am trying to create an Agent. If it was in SQL I would write Delete * from Contact where CompanyUnique = “XXXX”. Do you know how one would write that in Notes? Furhtermore Based on above. IF say the syntax was what I had for the SQL example, how would I separate them to say put 1000+...
  5. Sweetworks

    Cisco Call Manager - Screen Pops?

    I have Cisco Call Manager ver 6.0.1.2000-3 We want to have Screen Pops with Caller ID information look ups to a database as calls come in. I spoke to my local Cisco Rep and they keep pushing UCCX. I do not need UCCX as we have a small Call Center with no queues. We have a 15 person Hunt...
  6. Sweetworks

    Merge Worksheets in Excel 2010

    I have two worksheets I want to Combine. Sheet 1 has two columns, and 141 Rows Row 1 is a Header Row, so there are 140 Lines of Data. Sheet 2 has one column, and 255 Rows. Row 1 is a Header Row, so there are 254 Lines of Data. Examples Sheet 1 Business_Unit Line_Of_Business InterCompany...
  7. Sweetworks

    Lotus Notes 8.52 Local Databases Connecting to Server

    Running Lotus Notes 8.52 User are using a Database (a CRM Program) on their machines. The Remote users are set up to use a Local Copy. The system is then set to replicate the changes to the server. After a while when they save a record, you can see it is trying to save it directly to the...
  8. Sweetworks

    Adding a Network Printer in VB for Access

    I have an old Access Database that my staff uses to Print Labels. It is run off a Citrix Server as Published Application on a Thin Client. User that access it can not add printers. In the past I was able to add a desktop session, add the Printer and then the Printer would be available for...
  9. Sweetworks

    WSHNetwork.RemoveWindowsPrinterConnection with WildCard

    I've looked around and did not see an answer. I have a script that creates Printers. But I want to remove everyone first. To remove a printer I see this WSHNetwork.RemoveWindowsPrinterConnection "\\ServerOld\HP5si" Is there a wild card for this? Will this work...
  10. Sweetworks

    Re-Open the Application List in Designer

    I Have Lotus Notes 8.5.2 I was in designer making some changes to some views. I accidentally closed the List of Applications. I can not get it back, and I do not know what it was called to bring it back. Any help would be appreciated?
  11. Sweetworks

    Continuous label not prinitng correct Size

    I have a new Zebra Printer and Labelview 9 and I am trying to print on a Continuous Roll. Printer: Zebra Zm400 Software: Labelview 9 I have a continuous roll that is 3" wide I want to print a label that is 3"x.5" I sent the page and label size to that, but when I print it it comes out 2.5"...
  12. Sweetworks

    Intermec PX6i cutter not cutting

    I have an Intermec PX6i. I am printing from MS Word and I have made the paper size match the media. It is a simple 1" print job that prints a part number and a date. It is going on a Fabric Label media that get's cut by the built in cutter. The cutter works. In the options of the printer...
  13. Sweetworks

    Mobile Connect ON, but can not transfer to Cell

    Working in CUCM 6.0.1 I just set up a user with Mobility to their Cell Phone. I copied the settings from my profile exactly with the exception of the CSS as he is in another office, but it matches what is on his phone. His Cell Phone rings out simultaneously as expected. If he has a call on...
  14. Sweetworks

    Notes Developer Question: Remove Spaces from a field

    I am trying to create an Agent in my CRM in Lotus Notes, and I am not finding any answers on my Google searches. It is a simple thing that I can conceptualize in Excel, but can't figure out in Notes. I just want to remove any spaces in a particular field In excel you would just do a...
  15. Sweetworks

    Select statement in views (or)

    I an creating a view in my Asset database. I want to show just Desktops and Laptops that are in the category field. I can put a statement that says Select Category = "Laptop" and the view will show all the Laptops I can put a statement that says Select Category = "Desktop" and the view will...
  16. Sweetworks

    Windows 95 Program on XP and above.

    I have a 32 bit program made for Windows 95. It is called QuickXpense Enterprise version 2.4. It was running on my Windows XP and 2003 Server OS's in the past with no problems. Now I have issues when one hits print it just closes down the application with no errors. I searched the Event log...
  17. Sweetworks

    ASA 5505 conning to VPN 3000 Concentraitor in Network extension Mode

    Ok, I've set up a group and a user on my concentraitor to allow access to my network. I originally set the ASA in a remore site in just client mode. It connected and could use any resource at the home network, but I could not see the network on the insdie of the ASA. I swithced to Network...
  18. Sweetworks

    Open a wk4 file in Excel 2007

    We recently upgraded to Office 2007. A user needed to open an old file they use from time to time from Lotus 1-2-3. It was in a wk4 format. I tried to open it, but it wouldn't. I looked on Microsofts site and could not find an add-in that would allow you to open the file in 2007. I...
  19. Sweetworks

    Most Recent code for the 515e

    I have a Pix 515e that has been sitting around in storage since we shut down an office 2 years ago. We are switching things around network wise and want to rebuild the new config on the 515 in storage so we are not messing around with a production firewall. It has been awhile since I messed...
  20. Sweetworks

    Set Program Access and Defaults (SPAD)

    I am having some issues on my 2003 Server with my CITRIX clients. We have E-Safe for Anto-Spam and it creates a quarenteen e-mail form my users. It is a HTML page taht allows one to select actions to do to the various messages. When done one clicks submit (a Mailto link) that creates a new...

Part and Inventory Search

Back
Top