Recent content by diesel_medic

Hi I'm trying to produce a database that will convert Ebay download files to a format more suitable for import into Sage Line 50. I have a table "Customers" that has all the customer information in it. One of the fields is "Country", this lists the full name of the country the customer lives...

Thanks for that guys, I've tried the changes and I now don't get any error messages, but it won't produce any results! A bit more thought required I think!

Hi, I've been trying to get the sub bellow, without much suceess. Private Sub cmdSearchDate_Click() Dim db As DAO.Database Dim rst As DAO.Recordset Dim strSQL As String Dim StartDate As Date Dim EndDate As Date If IsNothing(txtStartDate) Or IsNothing(txtEndDate)...

The query creates a 2 field table, the first field listing the the different 'OverheadTypes' and the second the summation of the values associated with those 'OverheadTypes'. I wish to extract the numeric values and display them in text boxes on a form, so I need to be able alocate the value in...

Thanks for that, just what I was after. Now the problem I have is displaying the results. I have a form (frmProfitAndLoss), which has text boxes to display the results of the above query. Is there a way of geting the text box to display the contents of one field, based on the contents of...

Hi, I am currently trying to produce an accountancy package of use with Ebay in Access. I have a table that lists all the expenditure, as imported from Ebay/Paypal. For each record there is a field that records the nett valve of the transaction as well as a field, 'OverheadType' which...