Search results for query: *

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

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

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

Hi, I have an electronics components database which contains a text field for each component entry, in this text field is the discription and value of the component. see below: partno descprition ----------------------- 11056801 res 1k 5% 0603 11056902 res 10k 2% 0805 11057001...

Hi, I have been following a book sample to create a replicated database, problem is it tells me to add a reference to the "Jet and Replications Objects Library 2.1" which I can not find in the reference list !!! can Any one help Cheers

Hi, I have a button a form which allows me to save a report to file. I would like however to make it less user reliant, at the moment I use the code below: Private Sub yes_Click() On Error GoTo Err_Command6_Click Dim stDocName As String stDocName = "repairquer" DoCmd.OutputTo...

Hi, Not sure if what I want to do is possible, I need to be able to have a button on a form which when selected generates a report with the file named after a text box on my form and saves in it in a new folder with the same name as the report. The folder needs to be saved in a folder on a...

Hi, I need a text box that when data is placed in it, it adds a * character at the begining and end of the data typed in that text box i.e 1234 would become *1234* any help gratefully accepted. Cheers Ben

Hi I have a query which shows customer orders and purchase orders. The data is as below: Order no Customer Date Item -------- -------- ---- ---- 4056 Fred 01/08/2004 68709 4059 Paul 05/04/2003 68701 PO050879 TIS...

Hi I'm struggling to build a report that I need, Basically I have a query that shows all itmes shipped to customers between a certain date, what I need is a summary of this, The query is as below Item Quantity ---- -------- 68700D 2 68710 10 68705 3 68701 1...

I have a table as below: Serial No Date Manufacturer Engineer =========== ========== ============ ======== 68701/12345 05/05/2005 TIS Robin 68709/00256 01/04/2003 MPE Robin 68707/44589 09/12/2005 TIS Colin 68701/12587...

Hi, I am new to ADP's but am ok with MDB's, I have worked out how to a build table in a project and have also got forms to enter data into the tables. But I am struggling with queries, I have basically got all the fields listed on the view, when I run the view with no criteria all is correct...