Search results

What I would like to achieve via code on a button From the table orders orderDate orderID ref name amt vat 02/02/2014 56789 01 magdi 600 100 22/06/2014 12122 01 magdi 654 100 22/06/2014 65897 02 simon 250 159 22/06/2014 12345 02 simon...

I have a main form which opens another form, the link being AccountID. On the second form I have AllowAddtions=No to prevent the blank line at the bottom of the continuous form. I would like to add a new record to this continuous form but its just not working. I have added a button (OnClick)...

Customer price lists I have the following setup tblCustomers tblProducts tblCustomerPrices tblCustomerProducts tblPackSizes (different prices per products based on packsize) MainForm with Order details etc and subform with product details etc Various queries comboxes etc When selecting a...

Can somebody please help me create a loop from the following code. At the moment the code only adds one record at a time from the subform table. Private Sub Command0_Click(0)

I need som ehelp please in resolving this VBA/SQL code which run a crosstab query. The query itself needs to be deleted before running it from the button on the form. Private Sub cmdOK_Click() On Error GoTo cmdOK_Click_Err Dim blnQueryExists As Boolean Dim cat As New ADOX.Catalog...

I need to prevent a form from opening if no data (no picture) is found in an image control on the form that needs to be opened. The form is opened in this manner: DoCmd OpenForm StDocName,,,stLinkCriteria Certain records will not have a picture so the form doesn't need to be opended. Thank you

I have the following code Dim strSQL As String strSQL = "SELECT * " _ & "FROM tblProducts " _ & "WHERE (((tblProducts.SupplierID)=" & Combo0 & ") " _ & "AND ((tblProducts.CategoryID)=" & Combo3 & "));" I would like to add a clause which would say OR WHERE (((tblProducts.SupplierID)=" &...

Can anyone kindly help me with the attached database. I need to synchronize 3 combo boxes. based on the choice made in the previous box. I have seen it done before using text fields but not using numeric fields as in my case here and without using queries. I have set the RowSource for the 3...

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...

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...

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

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"...

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