Search results

I have a main form with combo box used for selection criteria. On the same form is a datasheet subform which show the records according to combo box criteria. I have also managed to insert (All) into the combo box to show all records but when I click "All" nothing happens. It does work for all...

I need some help please on passing parameters such as a recordsource to a report but not using OpenArgs I heard that this can be done using a hidden form. I have a calling form (form1) which opens a preview snapshot form (form2) which in turn brings up a rptCurrentRecord (form3) I can't get the...

link criteria ScottGem I have no problem with opening the form that has a picture on the hard disk and I am using something similar to your code. All thats fine. What I need to do is to prevent the form from opening if the image for that product is not on the hard disk. At the moment the form...

Is there a way of formulating a link criteria on opening a form whereby the link on the form is a file on disk which has the same ID minus the .jpg. So instead of this the Me![txtProductID] will be the jpg file on disk minus the extension of course If the ProductID is not = JpgID then the...

I have a form which brings up another form like this However, on the frmImage there is also an ImageControl that may or may not have a picture. The name of the path and filename is stored in a field in a table (not OLE). I do not want the frmImage to open at all if no image can be found under...

OpenArgs lagbolt Brilliant. How did you spot that ? However, you can't assign the bit 'assign the second element to txtTitle Me.txtTitle = var(1) on the OpenReport Event. This has to be under the OnActivate, but it doesn't work I have this under the OnActivate Dim var As Variant var =...

OpenArgs WayneRyan Yes, both forms and reports are supported

I have a calling form with the following code Dim strTbl As String Dim strTitle As String Dim strSQL As String strTbl = Me.cboRep.Column(0) strTitle = Me.cboRep.Column(1) strSQL = "SELECT tblSupp.SuppName, tblCurr.CurrName, * " _ & "FROM tblCurr INNER JOIN (" &...

Is there anyway to replace the default MS Photoed when using the Image Control on a form. What about using Infraview instead ? Any suggestions

run tim error 2501 Hi Rich Thanks for your guidance. All is working well now.

run tim error 2501 Hi Rich I did seek and didn't find and still didn't find. This event is the Nodata event not the OpenReport event which however pops when the NoData event triggers. Here is the full code once more. Private Sub Report_NoData(Cancel As Integer) On Error GoTo...

I have the following code on the NoData Event in a report. Private Sub Report_NoData(Cancel As Integer) MsgBox "No data to Display" Cancel = True End Sub If in fact no data is found for the report I then get the following error message "Run time error 2501 the OpenReport action was cancelled"...

Pass Parameters If you recall I have a list of forms (8) displayed in a listbox which will have loaded up 8 different queries in those 8 different forms. Now since all the forms and routines inside the forms are identical I thought it would be better to use just the one form but have the record...

change record source ejstefl I would like to put that statement somewhere in the code you supplied below Private Sub List0_DblClick(Cancel As Integer) DoCmd.OpenForm Me.List0 End Sub So when I open the form from a listbox it will pass the parameter to the OnLoad event the form. Thanks

change record source How to dynamically change record source of a form using the OnLoad event when the call is from a listbox as follows Private Sub List0_DblClick(Cancel As Integer) DoCmd.OpenForm Me.List0 End Sub Thanks

Form Open Hi ejstefl Thats exactly what I needed and it was so succint. Thank you very much

No Help Thanks but the thread doesn't tell me how to open the form from a list box so its of no help

Instead of using command buttons to open forms I would like to open forms displayed in a list box Is there a way of doing this, so for example the listbox will show CustomerForm SupplierForm OrdersForm ProductsForm When any of the above is clicked the relative form will open. Regards jmeek