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: *

  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.

    The javascript error that is generated: document.layers.layer1 has no properties. not very helpful to me...anyone else? thanks.
  3. 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(){...
  4. 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...
  5. gottaski

    Select Query Help

    jjonesal -- thank you so much!
  6. 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...
  7. 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...
  8. gottaski

    ODBC error 3151 - connection failed

    Please ignore this thread. I finally figured it out. I was using a trusted connection in my query and it didn't like it. Once I changed the trusted connection to &quot;no&quot;, it worked. Thanks, MJ
  9. 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...
  10. 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
  11. gottaski

    Select most current record based on date field for mulitple records

    Guess I should have given myself a little more time to work it out as I figured it out. Needed to use Group By for CandidateID, Last for Title and Max for Date. Hope this will help someone else out there.
  12. 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...
  13. gottaski

    Drop table syntax

    Thank you! That did it.
  14. 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...
  15. 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...
  16. gottaski

    Using RecordsetClone w/ subform

    Thanks DougP for your help! Acutally, I just stumbled upon an article in MS Knowledge Base that explains how to duplicate a main form and it's subform detail records -- which is exactly what I am trying to do. Sorry to have posted before exhausting all other search options.
  17. 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