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 Mike Lewis 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. JohnnyProd

    Outlook Fails to Delete Message After it is Moved

    I have written a .VBS script which opens An Outlook application, searches for specific messages, imports the body of the message into an Access database, and then moves the message into another folder. The problem I am having is that when I move the emaail message from one Public Folder to...
  2. JohnnyProd

    Get and Post Response Times

    Thanks for the tip, I will definately look into that.
  3. JohnnyProd

    Get and Post Response Times

    I'm trying to write a small app which will measure the resposen time of our application. To do this I have created a serries of Get() and Post() methods which grab the time in two places, take the difference, and write the info out to a file. What I am now wondering is if there is a better way...
  4. JohnnyProd

    Referencing Reports in VBA

    Nevermind. It figures that after working on this for such a long time it wan't until minutes after making the post till I realized that I needed to Set myReport = Reports![myReport] in order to reference it.
  5. JohnnyProd

    Referencing Reports in VBA

    My mistake. The line : Report myReport = Reports![Open Cursors] Should read Report myReport = Reports![myReport] to keep consistant.
  6. JohnnyProd

    Referencing Reports in VBA

    How can I reference a label in a report without hardcoding the name? ex: 'Reports![myReport]!lblDate.Caption = strHeader' I've tried creating a <b>Report</b> object named myReportObject and then referencing it like 'myReportObject!lblDate.Caption = strHeader'. Unfortuantely, I am having...
  7. JohnnyProd

    How Many Cursors are Really Open?

    In determining the number of open cursors at any given time I have come accross two methods that yeild different resluts. 1) Select value from SYS.V_$SYSSTAT where Name='opened cursors current' - yields 451 2) Select count(*) from sys.v_$open_cursor - yeilds 397 What is the difference...
  8. JohnnyProd

    Query by date you enter

    I am in the same boat, trying to enter a date as a parameter for a report. However, using the brackets in my SQL statement doesn't seem to work. Every time I try it I receive &quot;The Microsoft Jet database does not recognize '[Enter begin Date]' as a valid field name or expression.&quot; Any...
  9. JohnnyProd

    Report and Query Parameters

    I appreciate the help, but [The_date] is treated no differently than [mm/dd/yyyy]. Is there a simpler way to change the SQL statement inthe report than giving it parameters? I am currently looking into setting the RowSource of the report as I can easily create an SQL String that will work before...
  10. JohnnyProd

    Keep route table on reboot

    I recently noticed that the route statements I add to my route table are lost when I reboot. How can I save a specific route table so that it will always remain the same?
  11. JohnnyProd

    LInux and IP Masquerading

    ifincham, it looks like you really know your stuff here. I'm new to the linux world and wondering what you might recommend for a firewall solution. IPChains or IPTables might become more robust as I learn more, but are they really powerful enough to NAT individual IP addresses and allow/disallow...
  12. JohnnyProd

    Report and Query Parameters

    I'm trying to create a report which accepts a paremeter which narrows the scope of my data. More specifically, when a user runs this report it prompts them for 'mm/dd/yyyy' and uses this info to only display the day he/she is interested in. I have done this in the past by placing a query between...

Part and Inventory Search

Back
Top