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

    Open Excel Activates When Opening Another Excel File Office 2013

    Thanks for the reply. I will give it a shot.
  2. kentover

    MS Access Linked to SQL Server Numeric Fields Lose Precision and Scale

    That worked well. I created the query and set the fields format as Standard and two decimal places. Thanks again Duane.
  3. kentover

    MS Access Linked to SQL Server Numeric Fields Lose Precision and Scale

    That is a good idea. Thank you.
  4. kentover

    MS Access Linked to SQL Server Numeric Fields Lose Precision and Scale

    It is read-only and cannot be altered in Access. The data types are correct in Access, They are just not displaying correctly. In the tables and views Access is dropping zeros instead of showing two decimal places (115.1 instead of 115.10). Also in the view one NUMERIC(18,2) field is showing a...
  5. kentover

    MS Access Linked to SQL Server Numeric Fields Lose Precision and Scale

    It is for an end user doing read-only analysis. He is writing queries and creating formulas. A form or report would be ideal for me but not for his purposes. He is an actuary.
  6. kentover

    MS Access Linked to SQL Server Numeric Fields Lose Precision and Scale

    I have an MS Access 2013 mdb linked to a SQL Server 2012 DB. There are tables with NUMERIC(18, 2) fields in SQL Server. I link to those and the linked tables show the correct precision and scale in the design view but not when you view the data. It drops the zeros off of the decimal places. So...
  7. kentover

    Open Excel Activates When Opening Another Excel File Office 2013

    When I have an Excel file open and minimized then open another Excel file it activates the minimized file and puts it behind the new file. How can I stop that from happening? It is supposed to be a feature but it is annoying. I read that Word does the same thing but there is a registry hack for...
  8. kentover

    XML Source - failed the pre-execute phase and returned error code 0x80070057

    I have a parent SSIS that uses a script for calling a child package that parses XML and dumps it into tables. The child package runs fine when standalone but fails throwing the error when called from the parent. All of the child GUIDs have been updated. "POLICIES" is the first XML node. I am not...
  9. kentover

    XML Source - failed the pre-execute phase and returned error code 0x80070057

    I have a parent SSIS that uses a script for calling a child package that parses XML and dumps it into tables. The child package runs fine when standalone but fails throwing the error when called from the parent. All of the child GUIDs have been updated. "POLICIES" is the first XML node. I am not...
  10. kentover

    Subscription Render Options Missing

    I have an odd issue with the available render options when setting up an email subscription. Currently I only have the options CSV, PDF and Excel. Anyone know why I am missing HTML, XML, Word and Web Archive? After searching the web and this site it does not seem to be a common issue. Thanks in...
  11. kentover

    XML Query Issues

    OK, I found the answer. It is ugly but works when you strip out the XML tags. Here is what worked. DECLARE @TO XML DECLARE @String NVARCHAR(MAX) SELECT @TO = REPLACE(REPLACE(CAST(MatchData AS NVARCHAR(MAX)),' xmlns:xsd="http://www.w3.org/2001/XMLSchema"...
  12. kentover

    XML Query Issues

    I pull the following XML from a field in SQL Server 2008 and need to query into the string to get the values. Each attempt has returned NULL or nothing at all. <ScheduleDefinition xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">...
  13. kentover

    Copy online text file via HTTP

    Thank you for your response. The code runs very well but is returning a XSL Stylesheet instead of the data within the text file.I have done additional research on the method you suggested but am still haveing trouble getting the actual data returned. The creation of the new text file works...
  14. kentover

    Copy online text file via HTTP

    There is a daily text file that is accessible only through a URL such as HTTP://somefolder/text.txt. I need to copy the file to a new network location. I have tried using the FileSystemObject methods but it does not like the URL path. Is there another method that will allow a copy through the URL?
  15. kentover

    Fill Access Form from Word Form

    The bookmark names were returned as well as their ID. All of the range values showed that square. I am not sure what the square value actually is though.
  16. kentover

    Fill Access Form from Word Form

    Actually nothing happened. The Debug did not start. Instead I put the code behind a button and dumped the values into a string to populate a multiline textbox. Private Sub CommandButton1_Click() Dim I Dim strINFO Me.GETANSWERS.Value = "" For I = 1 To...
  17. kentover

    Fill Access Form from Word Form

    The code below returns  in each field. strPath = Me.DOC_LOC Dim oWord As Object Dim oDoc As Object Dim I As Integer Dim strFLD As Stream 'Open MS-Word via OLE. Set oWord = CreateObject("word.application") 'Open the form...
  18. kentover

    Fill Access Form from Word Form

    Yes, I am using bookmarks but I did create fields as well. For some reason they are not registering... I have tried hundreds of combinations but still cannot get the values pulled over. At best I was able to pull some type of object over but it appeared as a small box like a line feed or...
  19. kentover

    Fill Access Form from Word Form

    Yes, the count was 0 each time.
  20. kentover

    Fill Access Form from Word Form

    Within the Word form and hitting the form from Access still gives me the error that the member does not exist.

Part and Inventory Search

Back
Top