Search results for query: *

Thanks donutman!

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

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

Good idea. Thanks cjowsey :)

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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