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!

Search results for query: *

  1. T3leTech

    Conditional text formatting?

    Thanks for the response vbkris, However, I'm not sure I know where to put the code. Should the <% ... %> section be in the common.js file, or on the HTML page? If in the common.js file, how do I "call" it from the HTML page? --Telephony Tech
  2. T3leTech

    Conditional text formatting?

    Thanks for the tip. Believe it or not, users have asked for this functionality. If you can't recommend the blinking portion, do you have any recommendations to make the text appear or not, depending on the database value? --Telephony Tech
  3. T3leTech

    Conditional text formatting?

    I am trying to find out if there is a way to do two things: make text in an HTML page visible or not (depending on db values) and also if the text is visible, how to make it "blink". Here's the background: From a database, there is a field that can be one of three values (R, S or N). If the...
  4. T3leTech

    executing store procedure from a form in a ADP project

    Thanks! That works! --Telephony Tech
  5. T3leTech

    executing store procedure from a form in a ADP project

    That is it...pretty much. I want the user to be able to enter the same date for the @BeginDate and @EndDate (to capture a single day's data) and also to be able to enter multiple dates (like from the 1st to the 15th). I don't want them to enter a time value, but I always want the data to be...
  6. T3leTech

    executing store procedure from a form in a ADP project

    Using: Access 2000 ADP, SQL Server 2000. I have a similar problem, but I have been trying to solve it using a stored procedure with the InputParameters passed in from a form. In other words, I don't have any VBA code running that fires the sproc. I use the sproc to populate a report (the...
  7. T3leTech

    Identity field reset after deleting test data

    Wow!!! Thank you Terry! That is exactly what I was looking for. Thanks also to "donutman" and "pkailas" for helping me realize I needed to change the relationship to "on delete cascade". Thanks again!!! --Telephony Tech
  8. T3leTech

    Identity field reset after deleting test data

    I haven't tried either command yet (delete or truncate). No, there is no data that needs to be saved, but the constraints need to be kept. Can I just change the referential integrity so that the delete will cascade to the FK? --Telephony Tech
  9. T3leTech

    Identity field reset after deleting test data

    What if there are constraints on the table? Do they have to be removed and then reapplied after the data is truncated? --Telephony Tech
  10. T3leTech

    Identity field reset after deleting test data

    And that resets the auto-number to zero? So...you delete all of the data, then change the identity definition (to false) and then change it back (to true)? Is that correct? --Telephony Tech
  11. T3leTech

    Identity field reset after deleting test data

    Products being used: Access 2000, .adp file for front end forms and reports; SQL Server 2000 for all the "backend" stuff, like tables stored procedures, etc. I have completed building and testing a database that will be used in production Oct 1st (next Friday). I need to delete all of the...
  12. T3leTech

    Access .mdb and .adp bypass security key(s)

    Thank you! --Telephony Tech
  13. T3leTech

    Access .mdb and .adp bypass security key(s)

    I want to change the key from shift to another key or keys. --Telephony Tech
  14. T3leTech

    Access .mdb and .adp bypass security key(s)

    I am using Access 2000, with Office SP3. I am wondering if it is possible to change the "bypass" key that is default in Access? In other words, if an mdb or adp is setup to be locked down (don't show db window, no tool bars, etc) there is a key that can be pressed while opening the file that...
  15. T3leTech

    Destination link not accessible

    Srinath, Thank you for your help. I spoke to three separate people at Business Objects, and each time they assured me that the free version would allow emailing and saving .rpt files (and .pdf files) to network locations was permissible. I will be contacting them tomorrow. Thanks again...
  16. T3leTech

    Destination link not accessible

    Srinath, So, with the free version, I can't email reports, or save reports to network locations? --Telephony Tech
  17. T3leTech

    Destination link not accessible

    Yep, I'm doing that. And, I made sure that the Administrator account has full control of everything. --Telephony Tech
  18. T3leTech

    Destination link not accessible

    Thank you Turkbear for your quick response. I followed your directions, but when I open the either the Program Job Server or the Report Job Server, the Destination tab is greyed out as well. ???? --Telephony Tech
  19. T3leTech

    Destination link not accessible

    I am using Crystal Enterprise 10 (with CR10). I upgraded from CR 8 and Seagate Info 7 last week. Most things in CE10 work well, and are easy to manage. However, when I try to change the destination of a report instance, I cannot, because the Destination link on the Schedule tab is greyed out...
  20. T3leTech

    Joins on multiple (similar) tables

    Synapsevampire, You were absolutely correct! I figured out how to use a Union query to create a view of the three tables, and the reports have never been so easy. Thanks for your help! --Telephony Tech

Part and Inventory Search

Back
Top