Recent content by prodtest

Thanks for that, I am using 2005, so will look into that first. Thanks again. Ben

I will try and explain some more. Basically we have a sales quoting system that takes all the product information from a database table situated on our SQL server. On the same server we have a SAGE1000 system that contains a table that has all our stock information (part nos, stock levels, etc...

Hi Simian, Thanks for responding. I was hoping it would be as simple as point our quoting software at the view from the other database, however it wont allow you to look at a view in another database only the table that it is already setup to use. I was hoping by setting up the table to update...

Hi All, I have bee thrown in at the deep end with a SQL task, all because I have experience on Access! Here it goes: We have a view called quote_products on a SQL server in a database called live. Also on the same server have a database called quotes, in the quotes database is a table called...

Hi, I have a report which I wish to suppress the whole page if the a particular field is not the correct value. I have used the section expert to suppress each section individually and this works to suppress all printable details, however I still get a blank page. Is their a way to disable...

Hello, I am in need of a piece of code to help me a sum a selection of returned fields in a recordset. I already have the recordset sorted, but I am struggling with how to sum between rows. The recordset ruturns a result similar to below: product_code batch_number qty bin_location...

RivetHed you are a star !! Thanks for that, now works a treat after the changes and me forgetting to add in the Edit and Update lines. Thanks again

Hi, I am trying to write a simple peice of code that when actioned from a button opens two recordsets, it then cycles through one of the recordsets and updates a stores bin location from data held in the other recordset. The code is below, however when run I get a "data mismatch" error appear...

Hi I have a text box on a form which needs to be populated with the SQL statement below: SELECT SUM(costprice * (ukuntested + uktested + ukbonded + ukfaulty + ukavailloan + ukgoodsonloan + uktestkit + uksupplierreturns + usuntested + ustested + usbonded + usfaulty + usavailloan + uste +...

Sorry hit post before I said: Any help is greatly recieved :) Ben

Hi, I have a stock database that I have been builing as a side project at work and have an issue with linked tables. I have a transactions table on an SQL server that has its primary key field set to unique identfier, this works fine so long as I input data direct via an adp file. However...

Hi, Thanks for replying, I think I understnad what you mean. I have written the code below: Dim strsql As String strsql = "SELECT data.customer, data.importairwaybill, data.shipmentid, data.customsimportno, data.importdate, data.exportairwaybill, data.date, data.customsexportno FROM data WHERE...

Hi, I have a subform which is populated using the SQL below, SELECT data.customer, data.importairwaybill, data.shipmentid, data.customsimportno, data.importdate, data.exportairwaybill, data.date, data.customsexportno FROM data WHERE customer Like '*' & Text4 & '*'; # thing is I would like to...

Hi, I have a form on which customer order are entered and I would like to have an automated email sent when the data is saved. I created a form which works fine with Outlook, but as some of our employees dont have email and some use Goldmine (eerrgghh) this is not really a suitable solution. I...

Hi thanks for your help, I have sort of managed to get it working but the date needs to be entered into the textbox in US format mm/dd/yyyy, not good for UK users (damn users!!). Any ideas how I can get it to accept it in UK format dd/mm/yyyy ??? Ben