• MS Query – Client Access DSN error

    I'm receiving SQL0901 error when I establish a connection through MS Query to the 400. The job log failure is QQQISVSU (level 40) stating "Attributes of value number 2 in field HVR0002 not valid" I've disabled query wizard in hopes that the SQL request would not be made and it gives the same error....

    Jsimmons0 pointsBadges:
  • Email Notification If Scheduled Task In Windows Fails

    Hi All, I have scheduled an archiving process using the Scheduled Tasks in windows (2000 server). The task is running fine as per the schedule. But everyday I have to manually check whether it went fine or not. Is there any way by which I can send an email notification if the scheduled task fails...

    Bakash0 pointsBadges:
  • Problem with Access 2010 and Adobe PDF creating a file.

    I am trying to create a PDF file from within Access 2010. I just converted from Windows XP running Access 2003. Now I am on Windows 7 with Access 2010. The following work on 2003 but the PDF creations doesn’t on 2010. Private Sub PrintInvoiceWithForm_Click() On Error GoTo...

    DPaxton235 pointsBadges:
  • Viewing errors on a Windows 7 desktop

    Where can I view errors on a Windows 7 desktop from a failed Microsoft office 2010 installation? What security group would i need to be in to view it?

    Troubleshooter24755 pointsBadges:
  • Unlocking VBA project using VBA code

    Can i use vba code to unlock my x-cel vba project protected by password? I need to unprotect my project to add some code and then reprotect it.

    Yves69520 pointsBadges:
  • Message Alert Box in Excel 2003

    I have a two files, one is the consolidated time monitoring and the other file is the individual time monitoring. The individual time monitoring file has 30 sheets which is the name of each agent and in shared mode. On that file, agents are responsible to provide/indicate the things that they've...

    Eron09135 pointsBadges:
  • Change fonts in drop down box created with autofilter in Excel 2003

    1. Is there a way to change the font size of the an auto filter drop down box?

    Mmppmm10 pointsBadges:
  • generating a custom database from an existing database

    from a excel database with say 300 names, I would like to click a button to choose the names and quantities to generate a custom vdp database.

    LVNEONCOWBOY211215 pointsBadges:
  • Lotus Notes 8.5 documents to Excel worksheet

    Exporting documents to Excel worksheet.  Going well, but need to have the Excel sheet open in landscape.  What would be the commands for that?  This works fine so far: currentprocess = "formatting the spreadsheet" wsheet.Name = viewname wsheet.Cells.Font.Size = 10 wsheet.Rows("1:1").RowHeight =...

    TrinidadM5 pointsBadges:
  • Spool File Report to Excel/Data File

    I need to take a report from my Spool File and get the data into Excel. I try it the iSeries way with the PrinterOutput but it's dirty. no headers. is there another way to dump it into a temp file whil in the AS400 and then export that out to Excel and have a cleaner report that is in cells?

    Jaymz69765 pointsBadges:
  • Crystal Reports exporting to PDF font error

    Hi, I export a report on pdf format. The problem is the barcode is not generated properly from the Crystal Server. We don't know what the causes are.. please help This is the Crystal Server generated: http://www.pugs-es.info/karen/EtiquetasAlmacenar.pdf This is the locally generated:...

    Kcastillo15 pointsBadges:
  • Issue in PDF Converter in As400 for Czech Language

    I am using CVT2CMD command which I have downloaded from internet and this is for conversion of as400 spool to PDF. I am facing an issue for czech language. Please find the below font and encoding details, /Type /Font             /Subtype /Type1         /Name...

    Gambhir75 pointsBadges:
  • Reading pdf docs in Windows 7

    I cannot open pdf files and use windows 7 oe, since downloading the latest adobe reader X can any give me basic way I can overcpme this. Please could you give me full instructions as I am a tad plebish! regards Denis

    Dge7133555 pointsBadges:
  • Date Range in Excel Macro

    Hi, I just want to know if its possible to do a macro wherein I can select the dates to be read in my report. For instance, I have a Table (below) where column A is the Date, column B is the name of Agents, Column C is the Section and the Column D is the Error Category. A window will pop-up where...

    Eron09135 pointsBadges:
  • VBA to separate overlapping times

    I am stuck trying to seperate overlapping times. The situation is that I have 5 devices requiring x amount of material at the differing durations. What I need to do is seperate the durations and add the demands together for the new duration, but there can be as many as 5 overlapping demands; here...

    Jace75 pointsBadges:
  • reformatting a multi-tab spreadsheet and access 2003

    Hi,    I have an instance where I have an Excl 2003 spreadsheet and need to reformat it into a single record format using the data from each of the tabs but I also need to put additional data into the new record. Here is another twist I want to be able to trigger this from my access 2003...

    Cwv19495 pointsBadges:
  • Existing macros attached to custom toolbar buttons

    I have an Excel spreadsheet that contains several macros that are attached to custom buttons on a custom toolbar. When I open this spreadsheet in Excel 2007 none of the macros are attached to the buttons, how can I attach these macros to the correct buttons. Can I have this toolbar showing at the...

    Tad9575 pointsBadges:
  • Refresh Excel file on a different server with SSIS package

    I am trying to refresh an excel file that is on different server. is there any script that can be creatted with SSIS pacage that can do this. any help will be appriciated. Thank you in advance.

    Tocken10 pointsBadges:
  • VB for Excel

    I have an Excel Workbook (Template) inkl VB Modules and Forms. I want to export the Modules & Forms so that it can be stored at one place, but accessible from several Workbooks (different Periods etc) of the same type. How do I do this?

    OWE9995 pointsBadges:
  • Excel VBA Count # of Cells within Max and Min in a Table

    How do you write a VBA macro that count the numbers cell within a selected table that falls between a maximum and minimum number?

    Haxel5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following