Search:

Type: Posts; User: gdrezek; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Hi Joe, Yes I did try, and have switched to,...

    Hi Joe,

    Yes I did try, and have switched to, using the powershell command (instead of calling powershell from a batch file). I mentioned it (it was hiding between a couple of quotes -- sorry I...
  2. Hi Joe, I did find an answer to the "conundrum"...

    Hi Joe,
    I did find an answer to the "conundrum" I had with the following:



    The trick was to release each object in turn....as in the code below:


    $xl = New-Object -ComObject...
  3. Hi Joe, No I hadn't. I've been trying it...

    Hi Joe,

    No I hadn't. I've been trying it out...I've gotten rid of the batch file and setup a powershell only task in Task Scheduler, with no change in results.


    powershell.exe -noprofile...
  4. Hi Joe, For this I set the execution policy to...

    Hi Joe,
    For this I set the execution policy to unrestricted.
    Thanks.
  5. Hi Peter, Thank you. I do format, highlight,...

    Hi Peter,

    Thank you.
    I do format, highlight, etc. during the excel workbook creation, but a csv file is not totally out of the question....it's just not as pretty and harder to find the failures...
  6. Hi All, I've got a batch file which used to...

    Hi All,
    I've got a batch file which used to execute a Powershell script.

    powershell -command "& 'C:\JobsScripts\ScriptFiles\AgentJobStatusEmail.ps1' "
    The PoSh script queries multiple instances...
  7. Replies
    4
    Views
    420

    Thanks Hans, I knew it had to something rather...

    Thanks Hans,
    I knew it had to something rather simple I'd overlooked. I didn't even look at how I called the form. I have been out of touch for a while....
  8. Replies
    4
    Views
    420

    Hi Hans, The popform in question is popfrmViews,...

    Hi Hans,
    The popform in question is popfrmViews, command button <VIEWS>. The popform that works is popfrmTables, command button <Tables>. both are on the sbfrmServerDatabases.
    The original db is...
  9. Replies
    4
    Views
    420

    Hi All, I've got a listbox on a popform (the...

    Hi All,
    I've got a listbox on a popform (the listbox is located in the FormHeader), which, when opened by itself, will allow me to select a row and in the AfterUpdate event, will go to the record it...
  10. Thread: Melon

    by gdrezek
    Replies
    4
    Views
    581

    Re: Melon

    Here's a bunch more carved melons! <img src=/S/munch.gif border=0 alt=munch width=19 height=17>
  11. Thread: Eerie

    by gdrezek
    Replies
    4
    Views
    535

    Re: Eerie

    They were seen here first: New Zealand <img src=/S/anigrin.gif border=0 alt=anigrin width=19 height=19>
  12. Re: Doing a filter on a SQL linked table (Access 2003 SP3)

    Hi Pat,
    Sorry for the misunderstanding.
    I've just now been able to test this on a virtual computer using SQL Server 2005 Express (from previous posts I am assuming this is what you are using) and...
  13. Re: Doing a filter on a SQL linked table (Access 2003 SP3)

    Hi Pat,
    On further thought, right clicking on a field I am dimly remembering it does not require delimiters; i.e. quotation marks, #, *, etc. I think the odbc connector should handle the correct...
  14. Re: Doing a filter on a SQL linked table (Access 2003 SP3)

    Hi Pat,
    It has been some time since I've used Acc03 but "I think" what you are doing requires the same delimiters/symbols as does SQL Server. Dates are delimited by single quotes......'7/8/08'...
  15. Re: SQL Configure Report Server error (Access 2003 SP3)

    Hi Pat,
    Open Internet Information Services Manager through Administrative Tools (there is either a short cut to Administrative Tools via the Start Menu or through the Control Panel). Open the tree...
  16. Re: SQL Server 2005 Update problem (Windows SQL Server 2005 (SP2))

    Glad to hear you've got a handle on the problem. What was the permissions issue, if I may ask?
  17. Re: SQL Configure Report Server error (Access 2003 SP3)

    Hi Pat,
    I apologize, I've been at the busy state as well and haven't been able to make the time to answer your previous reply.
    If you open the SQL Server Configuration Manager (<Start><All...
  18. Re: SQL Configure Report Server error (Access 2003 SP3)

    Hi Pat,
    After looking at a number of articles and blogs (and actually a few of my notes) try this:

    Copy and paste this into the Run Command from the Start Menu....
  19. Re: SQL Configure Report Server error (Access 2003 SP3)

    HI Pat,
    A reasonable guess in looking at other forums it sounds like you have conflicting versions of ASP.NET. Since you are using SQL 2005, ensure your websites for Reports and ReportServer both...
  20. Re: SQL Configure Report Server error (Access 2003 SP3)

    Hi Pat,
    I believe it is because that virtual directory is already being used in IIS. If you open Internet Information Services, then open the tree of your Default Web Site I think you'll find...
  21. Replies
    12
    Views
    812

    Re: sql install problem (Access 2003 SP3)

    Resolving this in Firefox can be found here .
  22. Replies
    12
    Views
    812

    Re: sql install problem (Access 2003 SP3)

    Hi Pat,
    This is for Internet Explorer. I am checking to see how this might be accomplished using FF or Opera.
    Open a browser window. Click on Tools, the Security tab, then on Local intranet (under...
  23. Replies
    12
    Views
    812

    Re: sql install problem (Access 2003 SP3)

    As an addemdum:
    The Report Manager is a web page, hence the need for an installation of IIS and not the MMC snap-in.
    Initially let the SQL Server installation program configure Reporting Services....
  24. Replies
    12
    Views
    812

    Re: sql install problem (Access 2003 SP3)

    IIS needs to be fully installed for Reporting Services. The default settings will suffice after selecting the checkbox (Internet Information Services) in the Control Panel <Add Remove Programs><Add...
  25. Replies
    13
    Views
    1,855

    Re: How To Use FileSystemObject (Access 2000)

    Hi Bill,
    Does this reply by Hans give you a start? <post:=736,870>post 736,870</post:>
    There is also Access Archon 185 on this page in Helen Feddema's web site.
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4