Search results

  1. C

    Can't trap this error

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

    Error 2501 and parameter Queries

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

    Can't open secondary db to full 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...
  4. C

    Decipher please

    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)
  5. C

    Check table for existing record

    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!
  6. C

    All data entered on a form to a table

    I have a form with several tabs on it, where the user enters various info.. I want to have the user hit the save button and have all info saved to a single table. Is there an easy way to do this. Please excuse my ignorance but I am fairly new to Access. Thanks in advance!
Back
Top Bottom