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: shavon
  • Content: Threads
  • Order by date
  1. shavon

    vbscript/html code for button

    Good day: I created the following code for my Grade 4 computer students: I am using Chrome. I simply wrote the code in a text file and changed the filename to "filename.html" Why doesn't it work please? Thank you. <HTML> <HEAD> <SCRIPT LANGUAGE="vbscript"> Sub cmdButton1_OnClick...
  2. shavon

    Multiple Default Save Locations

    Good day: Is it possible to have multiple default save locations based on the template that I am using? I have a bunch of templates that I use for my job as a teacher. Each document needs to be saved at a different location on the drive which can sometimes be multiple folders deep. I just...
  3. shavon

    default location for explorer

    Hello: How do I change the default location for windows explorer to a specific drive. Whenever I start explorer, I want it to go to the g:\ drive instead of "C:\Users\user\AppData\Roaming\Microsoft\Windows\Start Menu" Thank you,
  4. shavon

    Dataset in class help

    Hello: The following function is in a class. I want to return the data to the form through this function. What is the proper way to do this please? Public Class Database Public cn As OleDbConnection Public cmd As OleDbCommand Public dr As OleDbDataReader Public da As...
  5. shavon

    Use custom procedure in Access 2000

    Hello: How do I use a custom procedure in A2K please? I created a procedure and I want when a new record is added to the database that this procedure runs and updates a particular field with a particular default value. I created a public procedure in a module. I am trying to use it from the...
  6. shavon

    Who has file open--User and computer name???

    Hello: I would like to find out who has a file open on our Active Directory network. How do I go about this please? Thank you...
  7. shavon

    Change Background Color in Excel selected Row

    Hello: I would like to change the Background color for a selected area in Excel. For example: Select Cells A5 to G5 and change the background color to Red. Any tips please? Thank you
  8. shavon

    fill ado recordset using stored procedure with 3 parameters

    Good day: I am having the most difficult time with what should be a simple task. I want to fill a recordset using a stored procedure. Dim rs as new adodb.recordset rs.open "SP_GetTriplicate '10/30/2006 09:00:01', '10/31/2006 09:00:00', 3",cnn, adOpenKeyset, adLockOptimistic...
  9. shavon

    Excel formula help

    Hello: I would like to write an excel formula that does the following. =IF(A1="Admin","11099","") or(A1="Accounting","11025","") or (A1="Sales","11035","") The OR condition doesn't work. Any help would be greatly appreciated. Thank you,
  10. shavon

    Average time between events

    Hello: I would like a query to determine the average time between events. For example, given the following records: TimeColumn 8/5/2006 12:15:35 AM 8/5/2006 12:15:44 AM 8/5/2006 12:15:49 AM 8/5/2006 12:15:55 AM 8/5/2006 12:16:01 AM 8/5/2006 12:16:06 AM 8/5/2006 12:16:12 AM 8/5/2006 12:16:19...
  11. shavon

    Silent Install

    Hello everyone: I need to perform a silent install for my application. How do I do this with the PDW? Is it at all possible? Thank you,
  12. shavon

    update using a subquery

    Hello everyone: Please help with the following: I want to update the following table: Dnum Rev Final 111 a 111 b 111 c y 222 a 222 b 222 c y 333 a 333 b y 444 c y I am updating the highest revision to TRUE. I have been playing with...
  13. shavon

    Encrypt/Decrypt Tiff files

    Hello: Does someone have a solution for the following scenario? I want to encrypt some Tiff files. I have a viewer created in vb6 that has the right "key" that allows the user to view the files. If someone else tries to view the files, they shouldn't be able to. What control or technique...
  14. shavon

    Use Windows API to send email

    Good afternoon: I would like to send SMTP email from a simple command line program. I would like to use the windows api as I am restricted from installing any ocx/axctivex on this server. Please point me in the right direction. Thank you.
  15. shavon

    Comparing two database tables

    Good day: I would like to compare two database tables and update one with records from the other if the record does not exist there. DB1 DB2 Table 1 Table 2 sss sss sds sds fgh --> fgf (added because it does not exist) I have a clue already but it does not...
  16. shavon

    Query to group data by shifts

    Hello: I would like to make a query that groups data by shifts. We collect production stats. The shifts are as follows: 23:00 to 07:00, 07:00 to 15:00, 15:00 to 23:00. As you can see, the night shift overlaps. How can I write a query to group so that the night employees do not get two...
  17. shavon

    Install Msde 2000 with vb PDW

    Hello: How do I use the PDW to install MSDE 2000 please. Any samples out there. Thank you.
  18. shavon

    Iterate through ALL subfolders

    Hello: I am using the following code to iterate through subfolders.The problem is that the depth of folders may change and this code only processes to the first level. How do i change it to process the folders regardless of the depth of folders? Thank you...
  19. shavon

    Automate Word(Insert text in a specific place)

    Good day: I have a Word template that I would like to customize based certain criteria. There are several places where a name needs to be changed and also a logo needs to be inserted. Is there a way to put markers in the template in the place where the name and date need to be changed and...
  20. shavon

    Open Excel document in VB application MDI form

    Hello: I would like to open an Excel document in a VB MDI form. I can open the document with automation, but, I want to have it open on a form that will be part of my vb app. Thanks for your suggestions.

Part and Inventory Search

Back
Top