Recent content by cybhunter

Hello, I have a form based on a parameter query. The form is launched via a command button from another form with vba code. When I click to "Choose Report" (my command button) I am prompted to enter a report numer. If I enter an ID all is happy -- if I click cancel w/o entering anything I get...

Hello, I have a form based on a parameter query. The form is launched via a command button from another form with vba code. When I click to "Choose Report" (my command button) I am prompted to enter a report numer. If I enter an ID all is happy -- if I click cancel w/o entering anything I get a...

Awesome! It works! thanks Allan57!

Allan57: Looking forward to seeing that code. I can open the secondary database no problem. The problem is that the second session of access is not opening maximized. Thanks!

I just realized something......the app is opening maximized it is the second session of access that is not. Any ideas?

I'm not opening a form...I am opening a second db. I want it to open in full screen. Like the primary db does. I have to manually hit the maximize button to get it to open full.

That's not working for me..... the db opens but only 3/4 of the screen. :(

RESOLVED: Can't open secondary db to full screen I am opening a secondary db from my main db using the following code: Dim accapp As Access.Application Set accapp = New Access.Application accapp.OpenCurrentDatabase ("C:\GEM\Gem Backups\OptimumDesign\OptimumDesign.mdb") accapp.Visible = True...

Anyone? ;)

I get the concept of PV. I guess what I am looking for is more the syntax of what is happening. Wht is the "-1" for, what is the "-Nz" for. I realize there are 3 values there, the interest, how many payments are left, and the payment amount. I am kinda looking for the A + B + C = D help...

Can Someone help me understand how the statement below works? Thanks in advance! Me.txtproratedlumpsum = PV(Val(Me.txtmonthlyinterestrate), Val(Me.txttermleft) - 1, -Nz(Me.Monthly)) + Nz(Me.Monthly)

I have a form that has a "ProjectName" Field on it. I want to look to my "ProjectEstimates" table (which has a "ProjectName Column") to see if that Projectname already exists so I know if I need to do an Update or Insert to the table. Can I get some help with this please? Thanks in advance!

sorry I wasn't very clear on my first post. In a nutshell, this tool (form) was created to do estimates for engineers. It was NOT designed to save the estimates. Now they want to save estimates. So now I am trying to back track. I guess there is no simple solution, it is just going to take a...

The form I am refering to is not a simple form. It is actually an job estimating tool with a ton of VBA behind it that does calculations etc. In reality it is an application on it's own. The user enters info into the tabbed form and then various actions are performed as the user clicks...

so..... I have the form already built. Now I create a new table at this point and then bind the form to it how? Do I have to manually create all the columns in the table or will access do that for me? Sorry, told you I was new to this. :) I am looking on the net for help to bind the form to...