Recent content by T3leTech

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

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

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...

Thanks! That works! --Telephony Tech

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...

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...

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

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

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

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

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...

Thank you! --Telephony Tech

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

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...

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...