Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Modifying searchdb (Access 2000)

    I've attached a sample searchdb. The form frmSearch allows you to search any table or query in you db. You have the option to save the query or export. Is there a way to modify this so that the user would be able to create a report within the current db?
    Thanks..
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Modifying searchdb (Access 2000)

    Is this related to your question in <post#=362888>post 362888</post#>?

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Modifying searchdb (Access 2000)

    yes... I'm dealing with an extremely rude and demanding person on this. NO matter what I do I can't please them.. It driving me crazy...

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Modifying searchdb (Access 2000)

    You could save the generated SQL as a query (you already have the code for that), select it in the database window (DoCmd.SelectObject) and create an AutoReport from it (RunCommand acCmdNewObjectAutoReport).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •