Search results

treason, they are on different pc's, however i've changed format on each pc itself and they still dont work? anything? thanks a lot!

Thanks for the response. My next question would be this. Do I have to make different queries for each month, quarter, etc.? Because I only want data from each specific month in the report. What would the code look like on this? Thanks a ton! Brian

Okay, here is my situation. I have 2 option groups set up. One option group has the names of employees. The second group has the months of the year, as well as 1st Quarter, 2nd, Quarter, 3rd Quarter, 4th Quarter, and Total Year. I want the user to be able to choose an employee and a month and...

Okay, so I made a macro that will print just page 3 of my form. That is great. The problem is that now it will only print page 3 of the first record of the form. I want it to print whichever page i am on. I then tried making a combo box and selecting from there, but it still will not work. Any...

Okay, so I made a macro that will print just page 3 of my form. That is great. The problem is that now it will only print page 3 of the first record of the form. I want it to print whichever page i am on. I then tried making a combo box and selecting from there, but it still will not work. Any...

Wayne, thanks for the response. The problem is that mostly everything on page 3 is formula driven off of other things in the form. how would i make a query this way, since I can't bring over my formulas to the query. or would i just have to do that an redo all of the formulas?

How would I go about doing this? What is the code so that my command button only prints page 3 of a form? Thanks a ton!

How do I rotate a text box 90 degrees so that I can use it to print envelopes, or is there a way to pre-set it that way? Any help is greatly aprpeciated. Thanks alot!

Could someone please tell me the code to make a command button in a form print only a certain page. For instance, page 3 of the form. Thanks alot!

Here it is Okay, here is the DB. let me know what you can do. Thanks alot! i appreciate it alot!

DB Ive taken everything out possible and I ZIp'd it, but its still too big for what is allowed on the website. I could email it to you, what is your email addy?

Term I have the term in number of months. Maybe it should be years?

ID number No i dont, should i do that? if so, how do i do that? Thanks a ton for your help!

What I have so far Here is what I have so far: =Pmt([Interest Rate]/12,[Term],-[Loan Amount]) It's giving me some wacky number that is way out of range. Any suggestions? Thanks alot!

Form Name The form is just called "Info Form"

still not working Okay, I put that in and it still doesn't work. Let me be more specific on this database. It keeps records of clients, their mortgage information and monthly liabilities. I have a table that i put liabilities in to. the query then totals them up by name. this query has 2...

more specific Okay, still a bit confused. so here is what i have. The query name is "Monthly Payment" The field in the Query is "SumOfMonthly Payment" So what would the exact code be that I need then? Help is greatly appreciated. Thanks a ton! Brian

What is the formula for calculating a monthly payment on a mortgage in a form? is this possible. I have the loan amount, term, and interest rate. I can do this in excel, but how in access? Thanks alot!! Brian

okay, here is the situation. I have a table where i put monthly liabilities (monthy payment). i then have a query that total's all these payments up for each individual client. They all appear as total's in the same query. I have a form where I have information about the client. I want to...