Search results for query: *

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

Hi, More information on this problem I have: If I run the stored procedure with out opening the form I can enter the criteria manually when asked inc the dates and it all works ok. So i must have a problem transfering the date content form the text boxes on my form to my procedure...

Hi, Im new to ADP's, I having trouble passing dates to a stored procedure. I have a TextBox on a form with no date formats set on it, it has the mask set to date ( 00/00/0000 ). The procedure has (dbo.transactions.date BETWEEN @startdate AND @enddate) as I criteria. The subform that runs of...

Hi, This seemed such an easy thing to do after working with MDB files for so long !! Basically I have a form that shows results from a sql database, the problem I have is it shows two boxes 'tested' and 'untested'. Now I thought it would be easy to add another unbound text box that would...

Hi, I need to have a text box background colour changed based on the value of another text box. Example: the text box 'partno' turns red when text box 'availablity' shows obsolete orange when text box 'availablity' shows limited and no colour when text box 'availablity' shows available. Any...

Sorry Remou Having a blonde moment !!! Sorted it !! Works perfectly !! Cheers Ben