Re: Alternative drill down?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

hi,

JString wrote:
I've never heard of that method. How would I go about setting it up?
using a permanent open recordset.
Create a new form with this code behind:

Option Compare Database
Option Explicit

Private m_Recordset As DAO.Recordset

Private Sub Form_Close()

m_Recordset.Close
Set m_Recordset = Nothing

End Sub

Private Sub Form_Load()

Set m_Recordset = CurrentDb.OpenRecordset("anyTable", dbOpenSnapshot)

End Sub

Open this form at your application start using

DoCmd.OpenForm FormName:="yourForm", _
WindowMode := acHidden


mfG
--> stefan <--


.

Relevant Pages

  • Re: ComboBox Macro Issue!?
    ... Private Sub ComboBox1_Change ... Confectionery Mfg from Purchased Chocolate", ... "48611 Pipeline Transportation of Crude Oil", ... Wood Product Mfg", "322121 Paper Mills", ...
    (microsoft.public.word.vba.general)
  • Re: ComboBox Macro Issue!?
    ... Private Sub ComboBox1_Change ... Confectionery Mfg from Purchased Chocolate", ... "48611 Pipeline Transportation of Crude Oil", ... Wood Product Mfg", "322121 Paper Mills", ...
    (microsoft.public.word.vba.general)
  • Re: ComboBox Macro Issue!?
    ... Private Sub ComboBox1_Change ... Confectionery Mfg from Purchased Chocolate", ... "48611 Pipeline Transportation of Crude Oil", ... Wood Product Mfg", "322121 Paper Mills", ...
    (microsoft.public.word.vba.general)
  • Re: ComboBox Macro Issue!?
    ... Private Sub ComboBox1_Change ... Confectionery Mfg from Purchased Chocolate", ... "48611 Pipeline Transportation of Crude Oil", ... Wood Product Mfg", "322121 Paper Mills", ...
    (microsoft.public.word.vba.general)
  • Re: Edit Existing Code
    ... not just Option Compare Database. ... change in the export delim report not the export fixed report. ... Private Sub FindButton_Click ... DoCmd.TransferText acExportDelim,, "qu-Active Cad", ...
    (microsoft.public.access.externaldata)