Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: nrjhano
  • Content: Threads
  • Order by date
  1. nrjhano

    Cannot delete form object while database is open

    I am attempting to use "DoCmd.DeleteObject acForm, "Form1"" to erase a temporary form that I partially design from VBA code based on a template. I get the message that this cannot be done while the database is open. How can I get arround this problem? I use "copy&quot...
  2. nrjhano

    Preload button to delete form created earlier by an object.

    I have defined an object that calls and generates a form. On the form I have save button that should save all information entered into the form and then close the form. The save button is preloaded onclick from my object: btnCmdButton.OnClick = "=RemoveCondFormOnclickV(""" &...
  3. nrjhano

    Replace allready linked table

    I use QueryDefs to retreive an address table from backend. To avoid time delays I reconstruct a table with the same contents in frontend and then change the content of a linked table when there is a need to refresh addresses in my frontend. This works fine. However, I would like to change the...
  4. nrjhano

    Passing function name into a public function as an argument

    I have spent some time to search for techtips for this problem and on microsoft´s site but in vain. I would like to pass a function() or procedure() call as an argument to another function() or procedure(). The most obvious thing is to send it as a string, however, when I assign this string to...
  5. nrjhano

    Slow macro execution

    Due to early bad choice of mostly bounded design I have been forced to top-off my design by setting RecordSources and controlsources. An effect of recursive use of a form (works fine by the way). Next time I will do the complete recursion in program. Is there a way to perform these operations...
  6. nrjhano

    Can "To:"-address in a macro be set from VBA code?

    MS access-97 SR-2 Windows 95 VBA-code DoCmd.RunMacro &quot;Print schedule&quot; Action arguments... Object type: Report Object name: Schedule Output format: Snapshot format: To: <blank> etc. Is there a way to set the &quot;To:&quot;-address from VBA code? The following code...

Part and Inventory Search

Back
Top