Search results

The control is appearing on all Tabs because you didn't select a Tab before you placed the control on the form. Delete your control, select a Tab and redraw your control.

...actually just taking that one step further you could show the message box only if the number of pages exceeds a set value. Dim stDocName as String stDocName ="Name of your Report" DoCmd.OpenReport stDocName, acViewPreview, , , acHidden If Reports(stDocName).Pages > 3 Then...

Try this ,Access 2002 or later Dim stDocName as String stDocName ="Name of your Report" DoCmd.OpenReport stDocName, acViewPreview, , , acHidden If MsgBox("There are " & Reports(stDocName).Pages & " pages in this report, Are you sure want to print it?", vbOKCancel + vbQuestion...

I don't know is this info will be of any use, but you can actually embed the users Outlook 'InBox' into an Access form, at least in Outlook 2003. The ActiveX is called the 'MIcrosoft Office Outlook View Control'. When it's embedded you can right click any email received, select 'Find All >...

Hi DBL, I've never upsized one of my commercial apps, but I will have to do one shortly. In preparation for that I've been doing some investigating and came accross the Microsoft white paper on upsizing which might be of some help to you. - Dave...

Dim i As Integer For i = 0 To lbSeleccionePuerto.ListCount - 1 lbSeleccionePuerto.Selected(i) = True Next

Me("SubFormName").SetFocus DoCmd.GoToRecord , , acNewRec ...should do it

In Form Load event put... Me!ComboName.DefaultValue = Me!ComboName.ItemData(0)

Here's something I picked up to get you started, it resizes the sub depending on the number of records.

You could set the Can Shrink property but here's a function you can reuse. Save this code in a Module... Public Function acbMakeLine(varValue As Variant) If IsNull(varValue) Then acbMakeLine = Null Else acbMakeLine = varValue & vbCrLf End If End Function Replace your four...

It's quite simple, just drop two checkbox controls onto your report, set the control source of each check box to... =IIf(Forms!Your_Form_Name.Option_Group_Name=1,True,False) and the other to =IIf(Forms!Your_Form_Name.Option_Group_Name=2,True,False)

another way... Me!ComboName.DefaultValue = Me!ComboName.ItemData(0)

Thanks for the code Treason, I have it working now.

Thanks a lot cbearden, that does work, but not quite as the original poster said. I had to put the code into the on_click event as opposed to Before_Update. Regards Meltdown

Still looking for a solution to this, if anyone has any ideas...thanks

Hi Treason, the checkbox is actually bound, as I was aware of the unbound checkbox problem. A bound checkbox is also necessary if I want to know which row was clicked/selected.

Hi Treason, I do need a continuous form...I think. The continuous form lists a number of possible report headings, the user clicks the checkbox beside the heading they want to use, and I then pull the selection into the top of the report, so I only want one checkbox to be checked. Thanks for...

Hi everyone, I have a bound checkbox on a continuous form and I want the user to be able to select only one checkbox at a time. At the moment they can select as many as they like which is not what I want. Anyone know how to do this? Thanks for any help

...another option from mvps http://www.mvps.org/access/modules/mdl0037.htm

Hi Cereldine, I did a demo for you...see attachment.