Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. prodtest

    Newbie to SQL :(

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

    Newbie to SQL :(

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

    Newbie to SQL :(

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

    Newbie to SQL :(

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

    Suppress Printing of Page

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

    SUMMING a selection of rows in a recordset

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

    Recordset SQL query issue.

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

    Recordset SQL query issue.

    ...& serial number 'matches the product code & serial number in the current 'open record in inputdb recordset Set carddb = db.OpenRecordset("SELECT * FROM card WHERE product_code = " & inputdb![product_code] & " AND serial_number = " & inputdb![serial_number]) 'set bin location on record...
  9. prodtest

    SUM function ??

    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 +...
  10. prodtest

    Linked Table and Missing Unique Identifiers ??!?!??!?

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

    Linked Table and Missing Unique Identifiers ??!?!??!?

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

    WHERE query help required

    ...data.customer, data.importairwaybill, data.shipmentid, data.customsimportno, data.importdate, data.exportairwaybill, data.date, data.customsexportno FROM data WHERE " & Combo2 & " Like '*' & Text4 & '*';" Is this the sort of thing you mean ? Adn how would I store it as a query ? many thanks...
  13. prodtest

    WHERE query help required

    ...data.shipmentid, data.customsimportno, data.importdate, data.exportairwaybill, data.date, data.customsexportno FROM data WHERE customer Like '*' & Text4 & '*'; # thing is I would like to be able to change the "customer" bit in the "FROM data WHERE customer Like". I would like this to be...
  14. prodtest

    Button to send email ?!?

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

    Date Problem in Stores Procedure

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

    Date Problem in Stores Procedure

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

    Date Problem in Stores 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...
  18. prodtest

    Text box that adds two other together !!

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

    Conditional formatting subform

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

    Wildcard Search On Memo

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

Part and Inventory Search

Back
Top