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

    PPT Macro in Master

    I have the following sub proc in the master of slide presentation B: Sub SubBranchLink() Dim sCurrentPresentation As String Dim sPath As String sPath = ActivePresentation.Path sCurrentPresentation = ActivePresentation.FullName MsgBox (sCurrentPresentation)...
  2. gottaski

    Visibility in NS 4 again.

    Can some kind soul out there please tell me why the javascript code below does not work. I have it working in IE and NS 6 (so i took out the code to keep the post shorter). I'm really losing my mind here. Thanks. <script language=&quot;javascript&quot;> function hideFields(){...
  3. gottaski

    ODBC User DSN for FileMaker Pro

    I have some FileMaker Pro files in a folder on my desktop. What I want to do is import this data into a SQL Server database. When I try to create a User DSN for the FMP data, it's not working (well, I shouldn't say that it's not working, i should say that I don't know what I'm doing as I've...
  4. gottaski

    Select Query Help

    I have a table w/ the following fields: EmpID | Salary | Month-Year with data such as: 2134 | $50,000 | Jan-01 2134 | $80,000 | Feb-01 2134 | $75,000 | Mar-01 2134 | $0 | Apr-01 2135 | $50,000 | Jan-01 2135 | $80,000 | Feb-01 2135 | $80,000 | Mar-01 2135 | $80,000 | Apr-01 What I need...
  5. gottaski

    Only 10 records updating

    <%@ Language=VBScript %> <!-- #include file = &quot;../dbConnection.asp&quot; --> <% Set cmd = Server.CreateObject(&quot;ADODB.Command&quot;) Set cmd.ActiveConnection = dataConn cmd.CommandText = &quot;MainCalculationBatch&quot; cmd.CommandType = 4 cmd.Parameters.Refresh...
  6. gottaski

    ODBC error 3151 - connection failed

    I'm using Access as a front end to a SQL Sever database -- via linked tables. I'm generating a pass-thru query to return a recordset. When I run the query for the first time from a form, I get the error -- ODBC error 3151 - connection to *my database* failed. Now, if I close the form, open it...
  7. gottaski

    MSWord Labels

    Does anyone out there know where I can find some info on how to create labels in MSWord from an ASP page? Thanks, MJ
  8. gottaski

    Select most current record based on date field for mulitple records

    I'm trying to write a query that will select a record that has the most current date for all records in another table. Since that probably didn't make any sense here are the tables and results i'm looking for: Candidates table CandidateID FirstName LastName 1 Joe Joe 2...
  9. gottaski

    Drop table syntax

    Can someone please help me w/ this syntax as I'm stumped: DECLARE @mytable varchar(1000) DECLARE @sqlCheck nvarchar(1000) SET @mytable = 'tmp' + CAST(@@spid AS varchar(3)) SET @sqlCheck = 'if exists (select * from sysobjects where id = object_id(N'+ @mytable +') and OBJECTPROPERTY(id...
  10. gottaski

    Mark records to view later

    Can anyone help me figure out the best way to mark records to view later. (I am using Access 97 as a front end to a SQL Server db) Scenario: I have a form that allows the user to dynamically generate a sql pass-through query. Users hits enter -- query results are displayed in another form. I...
  11. gottaski

    Using RecordsetClone w/ subform

    Does anyone if you can use RecordSetClone w/ a subform and if yes, do you know the correct? I have tried the following: Set rs = Forms![MainForm]![Subform]!RecordsetClone and Access97 keeps telling me that it can find the field 'RecordsetClone'. If I try: Set rs =...

Part and Inventory Search

Back
Top