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 SkipVought 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: *

  1. tman138

    Date Picker coding

    I've tried every event. Nothing triggers on the selection itself. You can change the date as many times as you wnat and never record an event. I have decided to disable the date picker and force the use to manual enter which will then hits the after update event. It's a nice feature ...unless...
  2. tman138

    Date Picker coding

    I have an Access 2010 database which uses a form that has a date picker enabled. What I want to do is requery some other fields on the form when that date changes. What I have found though is the fields 'After Update' event does not fire when the user enters a date using the date picker. I can...
  3. tman138

    Need to query Windows Update Status XP Pro

    I have a XP Pro SP3 box that I use to automate several internal office reports via e-mail. My IT admin has it set to use automatic Windows updates which causes me greif when the machine reboots and halts my apps. I want to disable the automated restart in group policy (not a problem) but then...
  4. tman138

    Outlook 2010 Signature overwritten by body in vba call

    I have an Access app that feeds a semi-automated e-mail. My problem is that I can touch the e-mail to get the signature to display using .display but as soon as I write the body, the signature is overwritten. Here is trunacted code depicting problem: Sub Test() Dim objOutlook As...
  5. tman138

    VSS Writer Error / Event Viewer 34113 error

    I am running BE 10D Version 10.1 Rev 5629 on a Win2K3 SP2 Server. I backup incrementally daily with full backups weekly and monthly. My source selections include selected volumes plus all Shadow Copy Components. It is the Shadow Copy Components that is causing the VSS Writers Error. I ran...
  6. tman138

    Excel called from Access doesn't save

    Skip; The save ThisWorkbook.Save executed fine wihtin Excel when run manually. The problem was the workbook name changes when called programatically from Access, so while my saves were being executed, they were only running against the temporary or phantom workbook that is created behind the...
  7. tman138

    How to speed vba PageSetup - found by accident

    thread707-1434802 I have a workbook that has a dynamic number of worksheets and I needed to set the page to landsscape and fit to 1 page hig & wide etc. and found it ran extremely slow. I stumbled on the Excel 4 macro solution but was uncertain of how to employ the macro so I decided to first...
  8. tman138

    Excel called from Access doesn't save

    I have resolved this. Once I realized that the worksheet name was actually different, I decided to add an intermediate workbook tmp.xls where I allow the macros to do their formatting work and then I have a naming function in the macro which contains the path and file naming. I set those in a...
  9. tman138

    Create and run an Excel macro from within Access

    Hey db. Here's what I did that works well. Create a template which contains your macros. Run a prep function similar to this: Function fnPrepSheet1() Dim templateXLS As String Dim Msg1 As String Dim pathout As String Dim fileout As String Dim strExcelPath As String...
  10. tman138

    Excel called from Access doesn't save

    I have an Excel sheet that originates from an Access database. Since there are numerous sheets and I have multiple users who need to access it, I want to format it once and not have worries about users needing to do so or have them enable macros. Toward that end, I first create the workbook from...
  11. tman138

    Redundant ISP setup

    OK - I have established redundancy, but not failover. I can change the gateway and enable use of the satelite instead of the cable modem. The failover solution I am leaning toward is installing a Cisco router with Reliable Static Routing Backup Using Object Tracking and setting this new router...
  12. tman138

    Redundant ISP setup

    I have a pair of AdTran NetVanta 1224R's on each end of the T-1 but they both just configured as bridges and because they also contain the QOS port mapping for my VOIP phones at my remote location I really don't want to change any of the configurations on them. I have a NetGear FVS318 firewall /...
  13. tman138

    Redundant ISP setup

    I have a small business with 2 locations connected via a dedicated T-1. At the main location I have a cable modem connection to an ISP which I share to both locations via the T-1. At my remote location I have an Internet satellite dish connection which is not currently networked. Since my cable...
  14. tman138

    Disaster recovery disaster

    Original install was WIN2K3 in c:\windows after restore all files restored sucesfully, but installed programs were not registered. My plan now is to reinstall O/S and patches first, then reinstall apps. I'll backup that config and then try restore for directory structure. Again backup and then...
  15. tman138

    Disaster recovery disaster

    Restore job was run by first re-installing Backup Exec, copying the catalog from a network resource back to the server, restarting in Active directory or directory restore mode ( whatever it's called) and running the restore from tape. No redirection was employed
  16. tman138

    Disaster recovery disaster

    I am running WIN2K3 Standard on a Dell Poweredge 2950 with Perc5/i RAID and Veritas Backup Exec 10. After applying a Microsoft security patch (I'm not sure which one) and rebooting I was confronted with a NTLDR not found error. I have both a daily incremental and full backup on LTO tape from...
  17. tman138

    GPO / Terminal Server Question

    Using group policy modeling in the group policy management console I was able to determine my policy was totally being ignored. I had created an organizational unit whose members had been created as members of other OUs. I'm still unsure as to why this is happening, but I was able to sucessfully...
  18. tman138

    GPO / Terminal Server Question

    That's exactly how I granted access to my ERPusers group - which is a domain global security group and part of a custom oraganizational unit ERPUsersOU and the only member of the Remote Users Group. ERPUsersOU was linked to my GPO and enforced. The problem is that the group policy that I...
  19. tman138

    GPO / Terminal Server Question

    Yes. If I uncheck 'Enable Remote Desktop on this computer' I don't even get a login screen. I get an error message 'The client could not connect to the remote computer' ...
  20. tman138

    GPO / Terminal Server Question

    I am in the process of replacing a legacy system running in DOS from WIN98 clients and need to keep the 98 clients active until the transistion. My new ERP system runs only on WIN2K or XP clients so I plan to use terminal server and RDP from the 98 clients until fully implemented. I have a...

Part and Inventory Search

Back
Top