Search results

Hi Smig I couldn't create the sum query, only a totals query. Please see the code in the attached zip file. All works well except that it doesn't export to csv based on unique values of date and ref

OK EdFred taken note about the slash but how do I get the unique record based on date and ref ?

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

With the Nwind database you have to key in a discount. No such customer discount scheme exists.

Hi Uncle What you say is an eye opener. I hadn't thought of doing it that way. It seems perfectly logical to offer a pefcentage discount of the retail as you suggest. Could you please tell me how you would insert/use the additional field you mention so that when a product is called it will...

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

Can anybody help on the following matter Have a form(1) that opens another form(2) that has an image control on it. The path to the image is held in a field in a table. The image file itself may or may not exist on the hard disk but the full path and the name of the file is held in the table. I...

ScottGem The DIR function still doesn't prevent the form from opening. Just tells you whether the file exists or not. However, if i wanted to tie it in with stLinkCriteria as stated above on the initiating form how would I compare the jpg on disk to the name in the field. So, the record on...

Hi ScottGem Thanks for your example but the problem is that the picture is not embeded. The field in the table refers to the jpg such as c:\pictures\123.jpg. Therefore the form will still open. The code or your example needs to checks for the existence of the file itself. Can that be done. Thanks

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

SQL Statement jrjr I heard that queries are optimised whereas sql optimisation is done at the last moment and on the fly. Although it is very difficult to measure any speed differences between the 2 techniques, they both seem the same. jmeek

SQL Statement Thanks to both cyberpac9 and jrjr I used the JRJR solution. JRJR, what was it you recently found out about the speed ? Also would it be better to run this query from the local w/station rather than from the server when using linked tables ? Thanks

SQL Statement By the way the code shown above is not PHP but VBA. I seemed to have clicked the wrong button

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)=" &...

3 Combo Boxes Hello Pat Thanks for your reply. Could you kindly give me an example where or how to reference the combos in the sql or query code. eg. in combo2 after update reference combo3 with an sql statement. Thank you

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

Sub/Main form Hi MStef Just picked up your zip file. Your solution works. Thanks for your help. I do however lose the datasheet subform using your method. Trying to simulate a datasheet will take a lifetime Thanks