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

    Get record # for record just witten or being written?

    @identity should work. Just Google it to see how it's used.
  3. shavon

    How to Query Lowercase or Uppercase Characters

    A regular expression might be useful here?
  4. shavon

    Multiple Default Save Locations

    Thank you PHV: I made a mistake. I meant to put "App_DocumentBeforeSave". My real question is how do I get the code to run when I save? The code does not fire at all. I have not done this vb stuff in years. I have to somehow instantiate the class1 module, but I don't know how.
  5. shavon

    Multiple Default Save Locations

    Hi jges: Thank you for pointing me in the right direction. I found this code that is placed into Class1. How do I get it to run when the save button is pressed please? Thank you, Public WithEvents App As Word.Application Private Sub App_DocumentBeforePrint(ByVal Doc As Document, Cancel As...
  6. 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...
  7. shavon

    Get USB drive's letter

    This might be helpful. From MSDN(http://msdn.microsoft.com/en-us/library/ys4ctaz0%28VS.85%29.aspx) Function ShowDriveType(drvpath) Dim fso, d, t Set fso = CreateObject("Scripting.FileSystemObject") Set d = fso.GetDrive(drvpath) Select Case d.DriveType Case 0: t =...
  8. shavon

    Correct case text strings?

    There seems to be a space between the apostrophe and the "S".
  9. shavon

    Strange File Character annoying problem

    I haven't touched VB in years but I assume you are doing this: Open "TESTFILE" For Input As #1 ' do whatever Close #1 Try this instead: Open "TESTFILE" For Binary Access Read As #1 'do whatever Close #1 I recall doing something like this about 5 years ago Good luck
  10. shavon

    default location for explorer

    thanks...
  11. 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,
  12. 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...
  13. shavon

    Use custom procedure in Access 2000

    Thank you...
  14. 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...
  15. 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...
  16. 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
  17. shavon

    fill ado recordset using stored procedure with 3 parameters

    Resolved!! This works for whatever reason. Thank you. Dim objCmd As New ADODB.Command Dim rs As New ADODB.Recordset With objCmd .ActiveConnection = d.c 'You can also just specify a connection string here .CommandText = "SP_GetTriplicate" .CommandType =...
  18. shavon

    fill ado recordset using stored procedure with 3 parameters

    Additional Info: The Stored Procedure being used CREATE PROCEDURE SP_GetTriplicate @pDateFrom varchar(20), -- This is the input parameter. @pDateTo varchar(20), @iDupCount int AS BEGIN CREATE TABLE #AllAcc (transit varchar(5), box int, imageid char(8), account varchar(7)) insert into...
  19. 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...
  20. shavon

    Excel formula help

    PerfeK!!! Thank you

Part and Inventory Search

Back
Top