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!

Recent content by Sweetworks

  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

    Awesome.. It's alot easier to know how to do something when you know what it is called. I followed your steps but i did not see the System Tables. Googled it and found this.. http://www.contextures.com/excelmsquerycartesian.html Took 10 seconds, what would have take me a hour or so.. Thanks.
  7. 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...
  8. 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...
  9. Sweetworks

    Adding a Network Printer in VB for Access

    It is not via permission. It is they do not have their full desktop. It is a published app, running on a thin client and all they see is Access. Their user account has full access to add the printer. I was hoping their might be a way to create a button that will map a specific printer.
  10. 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...
  11. 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...
  12. 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?
  13. Sweetworks

    Continuous label not prinitng correct Size

    Thanks, I called Zebra this morning. The length was set to 406 (on a 203 DPI head that is 2") I created a txt file and FTPed it to the Printer. It had the following in it ^xa^ll102^jus^xz It was from the Zebra Programming guidebook. The 102 in there is .5". Works like a charm now.
  14. 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"...
  15. 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...

Part and Inventory Search

Back
Top