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 Rhinorhino 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: Ross1
  • Order by date
  1. Ross1

    I Want to Create Financial Functions in SQL

    Thanks donutman!
  2. Ross1

    I Want to Create Financial Functions in SQL

    Ahh...donutman...from you're handle we are obviously kindred spirits :) You are correct about the basic formula. I'm having difficulty solving for NPER. I know I need to use some kind of a LOG function here, but I'm not sure exactly how to do that with the functions in SQL. I believe the only...
  3. Ross1

    I Want to Create Financial Functions in SQL

    I need some financial functions that will work in SQL. In Excel (and Access too I believe) these functions are RATE; which tells you the interest rate when you know loan amount, number of periods, and payment amount. PMT; which tells you the payment amount when you know loan amount, number of...
  4. Ross1

    Need Financial functions in SQL

    Good idea. Thanks cjowsey :)
  5. Ross1

    Need Financial functions in SQL

    Thanks RiverGuy and MichaelRed, but I really need to do the calculations from within a view. I'm going to try to solve the basic equations algebraically and then maybe create some user-defined functions (which I've never done before.) The trouble I'm running into is with the LOG functions. It's...
  6. Ross1

    Need Financial functions in SQL

    I need some financial functions that will work in SQL. In Excel (and Access too I believe) these functions are RATE; which tells you the interest rate when you know loan amount, number of periods, and payment amount. PMT; which tells you the payment amount when you know loan amount, number of...
  7. Ross1

    Need to Confirm Connection to Server Database

    Thanks 'cmmrfrds' and 'cjowsey'. That gives me some things to investigate. Ross :)
  8. Ross1

    Need to Confirm Connection to Server Database

    That's the curious thing...I can edit records right in the datasheet view and I can edit the records from the form...most of the time. Are you thinking it could be an issue with the record locking? Thanks for your thoughts. I'll check out the links.
  9. Ross1

    Need to Confirm Connection to Server Database

    Here's the SQL for the view: (I know using the pound sign in a field name is very bad form, but it was inherited.) SELECT TOP 100 PERCENT TIN#, ShortName, LastName, FirstName, DBA, History, LastUpdateHistory, LastUpdateHistoryBy, Address, City, State, Zip, AsgndOfficer, AsgndOfcrSigned...
  10. Ross1

    Need to Confirm Connection to Server Database

    Hi 'cmmrfrds', The Error I mentioned in my final paragraph occurs when the users are using a form in an Access ADP project connected to an MS SQLServer2000 database. The recordsource for the form is an updateable View saved on the server. Regarding your last question: Are you referring to the...
  11. Ross1

    Need to Confirm Connection to Server Database

    I have a project with an SQLServer2000 Database back-end and an Access2000 front-end. On one of my forms, I'm want to confirm that my network connection is still good before attempting to update the data on the server. Here's a paraphrased sample of the code I've been using...
  12. Ross1

    Must Export from Access to XML and Include One-To-Many Relationships

    that's affirmative on the difficulty of the other solutions you posted :):):)
  13. Ross1

    Must Export from Access to XML and Include One-To-Many Relationships

    By the way 'jel', do you recall what you searched for when you discovered this article? I tried to search msdn before I posted my question, but I was probably not using the appropriate XML terminology. Thanks again, Ross :)
  14. Ross1

    Must Export from Access to XML and Include One-To-Many Relationships

    Thanks, but I think I'm going to upsize to SQLServer2000 and use a method described in this article. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexxml/html/xml07162001.asp I was already snatching some of my data off of an SQLServer2000 database anyway. This reference...
  15. Ross1

    Must Export from Access to XML and Include One-To-Many Relationships

    Thanks jel :) This is my first forray into using XML and the article you pointed me to was most helpful. Have a great day and God bless. Ross :)
  16. Ross1

    Must Export from Access to XML and Include One-To-Many Relationships

    I need to export data from an Access (or SQL Server) database into an XML file with very specific syntax. The reason for the exact syntax is that the folks receiving the XML file will use it to upload data into their system and the syntax must match exactly. I have a table called FD. FD stands...
    • Ross1
    • Thread
    • Replies: 8
    • Forum: XML
  17. Ross1

    Must Export from Access to XML and Include One-To-Many Relationships

    I need to export data from an Access (or SQL Server) database into an XML file with very specific syntax. The reason for the exact syntax is that the folks receiving the XML file will use it to upload data into their system and the syntax must match exactly. I have a table called FD. FD stands...
  18. Ross1

    Access Project is storing stuff I don't want to store!!!

    I have an Access 2000 data project connected to an MS SQL 2000 database. I have code written on a Continuous Records form, (called Form1 for this explanation) to open another Single Record form (Form2) depending on which record you selected from Form1. I had entered test data in the database and...
  19. Ross1

    Trouble Displaying Section Header on Each Pg of Report

    Thanks jigjag! Very clear and concise response. I'll try your suggestions. Have a great day!
  20. Ross1

    Trouble Displaying Section Header on Each Pg of Report

    I have an Access report based on a query. The report has two subreports in the detail section, and a section header called "Officer". When I set the Repeat Section property, for the "Officer" section header, to TRUE, the report freezes. It starts to run, but then it just...

Part and Inventory Search

Back
Top