Search results

  1. C

    Outer Join Problem

    Plog - You make it sound so easy. This is now resolved. I appreciate your patience and help on this. Caz - Thanks also for your help, your images helped.
  2. C

    Outer Join Problem

    No problem I have made the change and reattached. Please let me know what you think and where maybe going wrong or if there is anything else you require.
  3. C

    Outer Join Problem

    The TrafficFormatID fireld in the tblTrafficNational Table is an Integer. It only shows text because it is a lookup from the other table and hides the Unique Key column. I have attcahed the table deisgn here for the tblTrafficNational Table
  4. C

    Outer Join Problem

    TrafficFormatID is a Lookup Field into the tblTrafficFormat Table and is an integer but displays the Looked up value and is bound on column 2 which is the Format column in the tblTrafficFormat Table I have included the Table Deisgn as an image here.
  5. C

    Outer Join Problem

    This is how it came out of Access as the Field is a 'Lookup' from another table and hides the column ID.
  6. C

    Outer Join Problem

    Just seen the previous posts, yes Caz that's what I am after in post #6 although it is lacking Walksorted Packets? Maybe i can take anther look at your query. How was your different to mine?
  7. C

    Outer Join Problem

    Thanks for looking into this btw, I do appreciate it. I have reattached the spreadsheet so it is clear for you in the format A,B & C as you have asked for it. It should make sense now let me know if it doesnt.
  8. C

    Outer Join Problem

    I have now uploaded some decent sample data with the formats and data volumes for the two tables as required. Ok so here is my tblTrafficFormat table headings in my DB are TrafficFormatID, Format, SummaryFormat 1 Delivered Walksorted Letters 2 Delivered Walksorted Flats...
  9. C

    Outer Join Problem

    I have two tables. tblTrafficFormat (This tables lists all the possible formats available): TrafficFormatID, Format, SummaryFormat (I am happy this table has the correct info within it) tblTrafficNational (This table lists all the volumes by Office where each volume is a particular format)...
  10. C

    Value in Query Returning As String and not a Number As Request

    Works like a charm!! Thanks
  11. C

    Value in Query Returning As String and not a Number As Request

    I have a query which runs fine, however one of the outputs is a calculated field and i use the Format(someValue,"Fixed") method of specifying the format for the % Change . Here is the query SELECT tblTempBearsWeek3.SymbolCode AS [Short Ticker], tblTempBullsWeek3.SymbolCode AS [Long Ticker]...
  12. C

    Query Too Complex on Joining Two Sub Queries Which Both Run Fine Individually

    I am receiving a Query too complex error. I have two sub queries developed using the Query Wizard. In one Subquery I get 9 columns with 28 records, and the other 9 columns and 30 records. Here are the two queries: Named: qryBestPerformingSpreads_Week9PricesBulls SELECT...
  13. C

    Reading In Excel Data into a Recordset from xlsx file

    My initial post said that I had checked the path and it was correct... I was in fact incorrect, how embarrassing. However, without your post of the alternative method and trying it, I wouldn't have found this as I know this method would have definitely worked. When I tried your...
  14. C

    Reading In Excel Data into a Recordset from xlsx file

    I am trying to use a Connection to an xlsx spredsheet to read in a table of information (the data is not a table, just laid out in a table, see attached, the one I am trying to load is xlsx not xls but I cannot for some reson upload the xlsx one on here) I have the following declared: Dim...
  15. C

    Label on form will not Update as the code runs in the background

    Fabulous, you advice was bang on. Thanks for your help. Resolved.
  16. C

    Label on form will not Update as the code runs in the background

    I have a userform that pops up when I am implementing a VBA subroutine. The nature of the form is simply to update the user what progress through the operation the code is using a label called lblProgressText. So, I have a form called frmProgress and in my loop I use: DoEvents...
  17. C

    Help with Cancel Parameter in Before Update Event

    Yes it is unbound. Is there a way around this?
  18. C

    Help with Cancel Parameter in Before Update Event

    Yes, the function return comes back correctly and the code enters inside the if condition as expected. I know this because I have 'Stepped' through it as you mention. Those two lines: Cancel = True, and the .Undo function does nothing though to cancel the User Action.
  19. C

    Help with Cancel Parameter in Before Update Event

    Yes that is another way and maybe I'll take that approach. However, I would still like to understand what I need to do to fix this (just so i know if I wanted to do it again in the future)
  20. C

    Help with Cancel Parameter in Before Update Event

    I am trying to use a Combobox BeforeUpdate Event to achieve a required result. I have two combo boxes inside a frame. The first is a year number 2011, 2012, 2013, 2014 The Second is the Week No ranging from 1-52, but 1-53 in some cases and this updates accordingly with the year number...
Back
Top Bottom