Search results

Oops...yes it is on the first form. Okay, just change this line: stDocName = "cmb_select_project" to... stDocName = "frm_add_edit_comment"

It is not neat but it should do the same thing as the existing button, but no more.

Let's give this a try for starters: Private Sub btn_add_comment_Click() On Error GoTo Err_cmdOpen_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "cmb_select_project" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_cmdOpen_Click: Exit Sub...

Okay, we'll fill in something then. Hang on a second.

Welcome back. Can you post the code the wizard created for us?

Did I lose you Louise?

What version of Access are you using? Does it let you create code?

Okay, let's give it a shot! First create the [btn_add_comment] button again but select code rather than macro. When it is created, post the code and I'll show you how to modify it.

I completely understand but frankly I don't use macros, only code so I may be of limited help here. If you would like to learn how to do it with code, I would be glad to help.

There are actually several way to do this. Here's the one I like the best: http://www.baldyweb.com/OpenArgs.htm

How about creating a pdf and attaching it to an email?

What happens if you open the report NOT in dialog view?

Thanks! There are now some very bright helpers looking at this issue.

Did you answer my post #6?

Where do you have the code you posted.

That's easy!: DoCmd.SelectObject acReport, "rptCapitol", False DoCmd.MoveSize , , , 20000 DoEvents

You might try a DoEvents to give the rendering engine some cpu time.

The suggestion on the MS site was to put the: Application.Quit ExpiredMinutes ...inside of the IdleTimeDetected procedure at the end, not where you put it. Jeff Conrad has a ton of "KickEmOff" links that you could review. http://www.accessmvp.com/JConrad/accessjunkie/kickoff.html

One of the nice things about reports is you can have invisible controls in each row that can keep track of what you want. Then you can sum that invisible column in the footers.

I doubt you can have a ComboBox (dropdown) within a ListBox but I know a SubForm displaying a Datasheet or Continuous Form will do it. :)