Search results

  1. C

    Ordering Columns Cross Tab Query

    You made that look far too easy :-) Solved. Thanks for your help...
  2. C

    Ordering Columns Cross Tab Query

    I cannot quite get my head around this. I have a cross tab query. Essentially it groups together posted volumes into week numbers for different offices. However, when I run the query, the order of the columns is not in a logical number order. I get Week 1 then Week 10 then Week 11 and Week 2...
  3. C

    Doesn't find existing symbol in table

    Is there a way I can make the connection to the database and wrap it up into a database object similar to the way it is done for VBA in access? My thoughts were to somehow get to dB.openrecordset(...... Where Dim dB as database Set dB = currentdb
  4. C

    Doesn't find existing symbol in table

    Didn't realise I could do a Count(*) (I'm still learning) but yep I can code that instead makes more sense doesn't it!! Thanks for your comment BTW I did solve it before your reply by dong a Do While loop and counting the records instead but that's very convoluted method. Yours is a much more...
  5. C

    Doesn't find existing symbol in table

    trtying to query the Symbol table to see if a recod exists with symbol code. I am querying the tblSymbol table from Excelk vba and the Access DB is on my machine. The code I am using is: Set rs = New ADODB.Recordset rs.Open "tblSymbol", cn, adOpenKeyset, adLockOptimistic, adCmdTable...
  6. C

    Updating Access Table from Exel VBA

    I have solved this. Sorry to have inconvenienced. The problem was that I already had a connection to the Database in the Excel Workbook. I cleared this and now the code works fine :-)
  7. C

    Updating Access Table from Exel VBA

    I am trying to update an Access Table from Excel VBA and it is stopping on the update line: Set cn = New ADODB.Connection 'MyConn = ThisWorkbook.Path & Application.PathSeparator & TARGET_DB cn.ConnectionString = "Provider = Microsoft.ACE.OLEDB.12.0;" & _ "Data...
  8. C

    Cancel Event in Before Update Event

    Given that this is an unbound combo box and having Searched for the answer I don't believe a solution exists.
  9. C

    Cancel Event in Before Update Event

    I am almost certain my code is correct but cannot figure out why it isn't working so there must be more to it that I am missing.... Simply, I am trying to Cancel an update in a Combo Box's Before Update event in the Form: frmManageAdditionalCollections (the colletions combo box) Cancel =...
  10. C

    Query Def Always Asking for Parameter!!

    Thanks Bob - I had rebuilt the string about 8 times and each time the Auto Fields got shown in Access 2010 when building the reference so I was pretty sure the spelling was correct as I went straight to that as my first resolution. I checked it literally character by character to ensure the...
  11. C

    Query Def Always Asking for Parameter!!

    Thanks for taking the time to look CJ
  12. C

    Query Def Always Asking for Parameter!!

    I have resolved this. I am not entirely clear why, but I removed the existing Combo Box and applied a fresh one. it is now working. There must have been some problems with the combo box but for the life of me I have no clue what was wrong with it. For anyone reading this post, you may try...
  13. C

    Query Def Always Asking for Parameter!!

    I have attached the db after it has been compacted and zipped. I have spent 3 hours trying to find what the issue is on this. please can someone have a look, I bet it is only a 2 min fix for a professional ;-)
  14. C

    Query Def Always Asking for Parameter!!

    Yes I have it open in a form view already and I am changing the selection in the combo box to test it and then flipping back to the query results tab and hitting refresh all. It is then when I get the dialogue box asking for parameters...
  15. C

    Query Def Always Asking for Parameter!!

    I have a form called "frmManageACF", query called "qryACFFill". On frmManageACF I have a combo box (name cmbACFFill) which has three cols. col1 = SiteID, col2 = Site code, and col 3 = SiteName. The combo box Bound column is set to 1. In qryACFFill, results are selected where...
  16. C

    Changing Record Source in VBA

    Me.sbfCollectionsDayOfWeekHomeSubForm.Form.RecordSource = "qryCollectionsByDayHomeSubForm_Sunday" Works like a dream. Thansk for your help with this.
  17. C

    Changing Record Source in VBA

    I am assuming an ordinary set of query results built in the Query Wizard therefore qualifies??
  18. C

    Changing Record Source in VBA

    Very helpful, and I'll have a go at this. I appreciate your help :-)
  19. C

    Changing Record Source in VBA

    I just want the subform to 'point' its record source to a different query that's all after an event happens on the main form. (This is a essentially a combo box change with a different day of the week). I know I have to do a refresh in the main form with the 'After Update' action from the combo...
  20. C

    Changing Record Source in VBA

    I have a Main form (Home), and on it is a subform (Home_subform). Home_subform has at its record source some query results I made through the Query Wizard. I want Home_subform to change its record source to another Query which I have again designed with the Query Wizard. I want to do this in...
Back
Top Bottom