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!

Register Log in
  • Congratulations Rhinorhino 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 petroffp

  1. petroffp

    SBS2003 Backup Behavior Changing After SP1

    Just a few logs: E00.log, E00TMP.Log, E0001647.log. It appears to be backing up the store twice. 1st time when it backs up drive D: 2nd time when it backs up "First Storage Group" Ok. So I looked at the command line argument used by the backup scheduler. Here is the command line ntbackup.exe...
  2. petroffp

    SBS2003 Backup Behavior Changing After SP1

    We applied SP1 to our SBS2003 server on 8/1. Since then the SBS default Full Backups have increased in size over 50%. Our information store is on Drive D: A review of the backup logs shows: Pre -SP1, Backup = C:, D:, System State = 13Gig Post-SP1, Backup = C:, D:, \Microsoft Information...
  3. petroffp

    too many transaction logs

    Nope, I think this is a story of doing too many things at once. We upgraded to SP1 and at the same time tripled our CALs and user count from 15 user to 45 user. (We added a new company with 30 OWA users). I keep reading here that a complete backup should clear the logs so I am just running...
  4. petroffp

    too many transaction logs

    Jumping in here w/a similar problem. We upgraded SBS2003 to Service Pack 1 on Tuesday 8/2. We do a full SBS backup (using NTBackup) every night, however the log files are accumulating and not being deleted. I've been trying to find a resource to diagnose the problem. At this rate we will be out...
  5. petroffp

    Fastest way to splat data into excel?

    1. Repeatedly calling rs.fiekds.Count slows things down 2. Try loading results in an array and then popping the array into Excel cells. Try this Dim Results() as Variant Dim FieldCount as Integer Dim R as objExcel.Range FieldCount = rs.fields.Count ReDim Results(1 To FieldCount) Do Until...
  6. petroffp

    In Cell Formating via VBA. Is it possible?

    Thanks... You're right that was a rambling thread, but the conclusion was pretty simple...Turn on the macro-recorder and try it manually, and it will all become clear. I keep forgetting how instructive the macro-recorder is.
  7. petroffp

    VBA Excel Statusbar...Change Colors?

    Usually I launch my macros with an application specific dialogue box. On the dialogue are two controls 1. frmProgress (a frame ) 2. lblProgress (a text lable inside the frame) At design time or load set lblprogress.backcolor= Some contrasting color lblprogress.width = 0 During the processing...
  8. petroffp

    In Cell Formating via VBA. Is it possible?

    Individual words within a text label can be bolded, underlined and otherwise formatted when entering a label from the keyboard. Can this kind of formatting be performed via VB?
  9. petroffp

    Word mailmerge not filling var in footers.

    I'm kind of in a hurry so I just pasted some code I used related to headers and footers. I had to use .SeekView=wdSeekCurrentPageHeader to switch to header and footer view. Not exactly a mailmerge but a search and replace... hope this helps ====================== ' Now Tweak the Date and Name...
  10. petroffp

    Remote Access to BCM (admin, VOIP) not working

    IT is a BCM 1000 with a 1000E expansion unit. Upgraded to ver 3.5.
  11. petroffp

    Remote Access to BCM (admin, VOIP) not working

    Basic connectivity over a VPN to our ver 3.5 BCM isn't working. The BCM has a static IP on LAN behind firewall. 1. I cannot ping the BCM over the VPN, though I can ping every other server on the LAN over the VPN. (The BCM can be pinged on the LAN) 2. I cannot run Unified Manager over VPN Is...
  12. petroffp

    Set datasource of Sub Report of a Sub Report

    To FVTrainer Is it possible to enter a correlated subquery in Crystal? I am an oracle user and am used to creating correlated subqueris in SQL+, but I did not think this was possible in Crystal. BTW I do not have DBA or developer accesss to the database so setting up temporary tables (although...
  13. petroffp

    Delphi app on Citrix server :Directory is controlled by other.NET file

    The problem is most probably happening on the citrix server side from your description. Citrix is just another flavor of a "terminal server". The only program users are running localluy is the citrix-terminal software. The terminal software is like a super robust version of...
  14. petroffp

    Excel lookup and reference question

    Try the Match() function. Set 3rd parameter = 0 for exact match returns relative position (starting from 1) of the "match"
  15. petroffp

    Passing Array to Delphi DLL from Excel?

    Several years ago I had to write a delphi DLL COM object that accepted Excel "Ranges" in the function calls. Here is an excerpt that I tried to trim down (haven't checked that this snippet compiles). Can't remember exactly how to make this work in a non-COM DLL, but I think the key is...
See more

Part and Inventory Search

Back
Top