Search results

DAO database I read another thread where a similar problem was related to the program being a DAO database?? I am using Access 2k and have used the above code (modified)in another application and it works. Is there something I need to do with it now?

I have made an Income calculator for a financial planning database. The calculator is a subform on a tabbed control. To calculate tax I have created a tax table form [Tax Table Calc Frm] and placed it as a sub form in the Income form. So that I can get the tax to calculate during input of...

Had a go at looping without much luck so I thought I would try to set up a command button to create a duplicate of a payment. I could then set up multiple payments with the corresponding clicks of the button. I resurrected some code I had used a while back to create a record duplicate. However...

Thanks Malcy and Rich for responding. Malcy I will give the loop thingy a go, although I haven't set one up before I'm sure I'll find heaps on this site to help with that. Rich I need to append them because the program is designed to generate a two year debt reduction plan for clients and part...

I Have a situation where a client will want to pay some lump sum amounts of money off a loan and it may be something like $100 per month for 10 months. I have created a table for lump sums payments into which this info would be entered but I need to create an individual payment for the period of...

:o Found the problem. My requery code included a docmd.echo false at the end of the code only. I changed it to a docmd.echo false at the beginning and a docmd.echo true at the end and lo and behold it fixed it.

Hopefully just a simple one??? I am using a popup form to input data into a display form which is on one page of a tabbed control. The display form updates through an afterupdate requery command. This all seems to work OK but when I enter the new record via the popup form then close it, it...

No I haven't done that but I have run it on a office 2003 system here and had no problems with it. It just seems that on some other systems this problem has occured. I have asked one of the clients having the problem to try changing words security settings to see if it works after that. The...

I have produced a A2k db for distribution to others. Part of the db is a function that links to some word docs via hyperlinks. The word docs have been set up as mail merge docs to a table in the db. When used in Office 2000 this function is faultless but when installed on a computer running...

The following code attempts to create an append to table called [PA1link] and append the data to a table called [Customers] in the DB called [ProReport1]. As the location of [ProReport1] may vary due to the installation on a variety of servers its location is dictated by the [Links] table which...

I have a Form [customers], which contains a tabbed control and within one of the tabs I have a subform [Loans]. The Loans form is a "display only" form which lists clients loans. The loans can be updated or added to by a popup form which acts as a loan calculator. The "After Update" event of the...

Thanks for that Pat. All OK with this one now it works fine.

Great Minds think alike RG. I rethunked the approach and used a subform with the tabbed form enclosed. It worked fine. Still can't fathom why the other system wouldn't work when I have done it before. I think the subforms a cleaner approach anyway. Thanks for the help.

I have placed a tab control within a tab control (which I have done before). The problem is that the sub tab control appears on every page of the main tab form (encountered this before). I fixed it in the past by placing code on the on open event to make the sub tab control not visible unless...

Thanks once again Pat. I will give it a go.

I am building a debt management program in A2k. I have created a tabbed control which contains 6 pages based on a set of queries. These pages are a budget template and the intention is that when this form is inserted as a subform into the customers form the budget will open as a blank template...

Hey RG thanks for the help. I'll give it a go.

I am building a Access 2k form which will serve as a loan calculator on a project I am doing. I have a field called [amount] which will store the loan value (Principal). Sometimes the user will know the value of [amount] and enter it directly into the field. At other times the value is unknown...

I have found and set up Microsoft Excel 9.0 Object Library (can't find 11.0, assume it is a version later that A2K). I have made sure that msowcf.dll is installed but still no joy. I have tried to create a Principal calculation formula of my own but need the Power Function, this doesn't work as...

I am doing some work on a loan calculator which I have done successfully in Excel. I now wish to do this with an Access form (A2K). Can anyone please confirm that the Financial Functions (ie CUMPRINC etc) that are available in Excel can be used in Access. The Access help menu calls them...