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 Chriss Miller 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: *

  • Users: PRUSA
  • Order by date
  1. PRUSA

    Outlook VBA Macro to Delete Email from Sent and Delete Folder

    Hi Everyone, I've been trying to find a solution for the following example, I send an email to "abc@gmail.com" once sent take the email from the sent folder move to delete folder and permanently delete the item. And this is for email only going to "abc@gmail.com" I've looked around and the...
  2. PRUSA

    Creating a YTD record count column

    Sorry I wasnt detailed MTD = Month to date I am calculating the number of records that come back for each month. For example from the query above this is what my output looks like: Month MTD January 671 February 664 March 604 April 599 May 559 and yes I want to keep a running...
  3. PRUSA

    Creating a YTD record count column

    Hi Everyone, I am working on a request here and I cant seem to get handle on it. I am create a query that shows both MTD figures but also a YTD column. Here is my query. select case when Month(a.event_date)=1 then 'January' when Month(a.event_date)=2 then 'February'...
  4. PRUSA

    Conditonal Logic for proc sql??

    Hi Everyone, I'm very new to SAS and i'm running into a problem. I'm doing a proc sql and in it i'm doing a left join. It turns out once quarter my driver table will contain less rows than the right table causing rows to be chopped off I was wondering if this was possible, and what the...
  5. PRUSA

    Case Statement Issues

    The code worked!! SubString(Right('00000000' + RTrim(acc.custom_data_91), 8), 1, 3) + SubString(Right('00000000' + RTrim(acc.custom_data_91), 8), 6, 3) As ColumnA It wasn't working before because it didnt realize my existing field already had a blank spaces in it, so basically I put the...
  6. PRUSA

    Case Statement Issues

    Actually this is not working, all its adding is leading 0'z to my columns for for example a column that has 1234567 now becomes, 000000001234567, and when i do a substring a position one for 3 spaces I'm not getting the information I would need? Any suggestions let me know if I need to clarify...
  7. PRUSA

    Case Statement Issues

    thanks gmmastros for getting back to me i really appreciate, I'm going to test this out on Monday, due to the heavy snow everyone is getting out early :-) I'll let you know monday thanks again,
  8. PRUSA

    Case Statement Issues

    Hi Everyone, I have the following case statement in my query, and I am looking to see if anyone could give me an idea of how to rework this so I dont get multiple rows in my output Basically I have a field which should ideally be 8 characters in length, then its not I add leading zero's so i...
  9. PRUSA

    How to Migrate Calandar from one server to another

    Hi, I am new to the exchange arena. We just came across a office that used exchange only for sharing their calendars. They want to migrate to a new server and nto lose the ability to share calendars. How difficult is thsi task. The office has around 6-8 clients. can anyone point me to some...
  10. PRUSA

    Reading file lne by line

    Hi TipGiver, thanks for getting back to me, i used your code and i get teh following: Index was outside the bounds of the array at the following line: r(1).Substring(0,r(1).length-1) please let me know what you think.
  11. PRUSA

    Reading file lne by line

    Hello Everyone, I trying to get myself familiarized with vb.net. I've done some vba for excel, acess, and some vbscript. I have a file with on the 5th line have to parse out a piece of information. How would i got about this this in vb.net for example file: Line1: Line2: abc Line3: Line4...
  12. PRUSA

    Generating Random Alphanumber Number

    VBakias, I really appreicate all your help. I did not get a chance to test this last night, but I'll definitely be testing this tonight. Thanks Again.. Serge
  13. PRUSA

    Generating Random Alphanumber Number

    VBakias, Thanks for the hints. I'll give it a try. I hope you don't mind If I have additional questions. Thanks you for the advice. Regards, Serge
  14. PRUSA

    Generating Random Alphanumber Number

    Hello Everyone. I am trying to develop an application in either vb.net, vba, vbscript that will basically generate a random alphanumber in the following format xxx-xxxx Letters could be: A-Z (in caps) Numbers coulb be: 0-9 If anyone could please provide some insight, I would really...
  15. PRUSA

    Backing up Database(s) From Command Line

    Bingo!! Thanks Vongrunt. I appreciate the tip
  16. PRUSA

    Backing up Database(s) From Command Line

    Hi, I am new to SQL Server, and I know of maintenance plans beign able to backup databases. I currently have some maintenance plans on some of my servers and on others we just rely on the network team beign able to backup all SQL Databases via ArchServe. Well we've been having some problems...
  17. PRUSA

    Exporting Outlook Email Subjects including date and time

    Oh nice!! Less coding for that one ;-) Thanks Again
  18. PRUSA

    Exporting Outlook Email Subjects including date and time

    TomCologne, I was able to find out the answer to this. One has to create a couple for variables but it works fine. One can use the Folders method. The trick with this is that you have to go down the line from Highest hierachy to down to the folder you want to open. I put the code i'm using...
  19. PRUSA

    Exporting Outlook Email Subjects including date and time

    TomCologne, This works perfectly!!! Thanks so much for your help. I really appreciate it. One question. Since I have so many email in my inbox, lets say i made a new folder how would I point to that? This is going to save me so much time. Thanks Again, Sergio
  20. PRUSA

    Exporting Outlook Email Subjects including date and time

    Hello Everyone, I've done some VBA in excel, and access, but this outlook thing is completely new to me. I have a particular folder where I have i woudl say 20-40 emails. All i want to od is export the Mail Subjects, and the Time and Date they were sent, and i guess save to an excel sheet or...

Part and Inventory Search

Back
Top