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

    Duplicate a record 2 weeks later

    Hi, I have a company that delivers skips to customers. I input the data on a subform for the delivery of the skips which includes the date (Taken from the main form), address, skip type, type of job(deliver/collect/Swap) etc..... Is it possible to duplicate that entry (if it is a delivery or...
  2. dmkennard2

    Query not working in Access 2007

    It's a record source for a subform.
  3. dmkennard2

    Query not working in Access 2007

    Hi, Thanks for your help with this. Unfortunately it did not work, but what it has highlighted is if i take this out of the statement the query runs and returns data. Now i am even more confused!!
  4. dmkennard2

    Query not working in Access 2007

    Hi, Thanks for this. SQL code is: SELECT tblMainData.Handling_Unit, tblMainData.Material, tblMainData.SUT, tblMainData.Blocked, tblMainData.Type, tblMainData.WCS_Qty, tblMainData.SAP_Qty, tblMainData.WCS_Location, tblAisle.Aisle, tblSide.Side, tblLocation.Location, tblLevel.Level...
  5. dmkennard2

    Query not working in Access 2007

    So why did this work in 2003 and not in 2007 and are there any solutions on how i can make it work in 2007?
  6. dmkennard2

    Query not working in Access 2007

    I have 4 which are text and one which is a comparison of one field against another to see if it is greater than the other. So 4 x Text and 1 x Number
  7. dmkennard2

    Query not working in Access 2007

    Hi, I have a query that did work in Access 2003 but i cannot get to work in 2007. The form where the query is used has several checkboxes that filter a subreport when they are clicked. Like IIf([Forms]![frmAllData]![chkBlocked]=True,-1,"*") This is the code i have in the query for each...
  8. dmkennard2

    Use variables in R1C1 Formula

    Hi, Thanks for getting back to me. Looks like i have solved it with the code below. With xlRange .FormulaR1C1 = "=SUM(R[" & 8 - lngLastRow - 1 & "]C:R[" & lngLastRow - lngLastRow - 1 & "]C)" End With Probably not the best way of doing it, but it seems to be working. dazz
  9. dmkennard2

    Use variables in R1C1 Formula

    Hi, I am using code to extract data from Access into a spreadsheet. I am having problems inserting formula at the end of certain data columns that totals the column above. The first row will always be row 8 but the last row will always change. Am i missing something in my formula code below as...
  10. dmkennard2

    First record code not running

    No reason, just my lack of knowledge. :) I moved it to the format area and it works, Thank you. Dazz
  11. dmkennard2

    First record code not running

    Hi, I have two text boxes on a report that i show and hide depending on a value of a tickbox. The code below works for every record apart from the first record if the value is true. Both boxes properties are set to invisible, but if i enable them they show all the time on the first page. Do i...
  12. dmkennard2

    Filter a Pivot Chart

    Hi, Thanks for the reply. I would like the option to be able to display more than one day when looking at the chart. Choosing one day at chart creation make the chart a lot less busy and easier for users to understand.
  13. dmkennard2

    Filter a Pivot Chart

    Hi, I have got the code to create a pivot and a chart from the source data. The problem i have is there is far too much data to be displayed in a chart. Is there a was of deselecting all the entries, in this case date, and only display the first date that is in cell A5 in the pivot table? At...
  14. dmkennard2

    Print Text Input on a Report

    No the form closes.
  15. dmkennard2

    Print Text Input on a Report

    Hi, I have a report that is run by selecting dates between a range on a form. A different page for each customer is produced in the report. I also have a textbox on the form where the user inputs the date they want printed on the report. I can get the date to print on the first record of the...
  16. dmkennard2

    Update Checkbox

    Edit to a above 4 - I have an outstanding amount that is not stored in the table. This is what is used for the calculation. So, Amount_Payable - Amount_Paid = Amount_OutStanding Checkbox to be ticked if Amount_OutStanding=0 Sorry for the confusion. Dazz
  17. dmkennard2

    Update Checkbox

    Hi, I have a subform (Datasheet View) which has, amongst other fields,: 1 - A text are where i enter the amount paid, formated as currency. Stored in the Orders Table. 2 - A total amount payable which is a calculation of other fields on the form and cannot be changed by the user, formated as...
  18. dmkennard2

    Update Checkbox

    Any other ideas? I am stumped!!
  19. dmkennard2

    Update Checkbox

    The check box is in the subform and is ticked when the amount paid is equal to the amount due. Each record has a checkbox of its own.
  20. dmkennard2

    Update Checkbox

    The form in question is a Datasheet Subform.

Part and Inventory Search

Back
Top