Search results for query: *

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

The javascript error that is generated: document.layers.layer1 has no properties. not very helpful to me...anyone else? thanks.

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(){...

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

jjonesal -- thank you so much!

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

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

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

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

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

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.

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

Thank you! That did it.

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

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

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.

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