Search results

  1. Mile-O

    Cleaning up the name field

    Is it only this one name you need to clean up? If so, you could just use an UPDATE query.
  2. Mile-O

    Scottish Independence

    What did you originally predict?
  3. Mile-O

    SQL Error?

    Dim rs As DAO.Recordset Dim myVar As WhateverTypeItShouldBe Set rs = CurrentDb.OpenRecordset("YourQuery") myvar = rs.Fields(Whatever Field Number It Is) rs.Close Set rs = Nothing
  4. Mile-O

    SQL Error?

    Your SQL can't be found because the OpenQuery method is looking for a query. It doesn't recognise your SQL as the name of a query in your database. Time to look into the QueryDef object.
  5. Mile-O

    SQL Error?

    For info, the SQL you built was a SELECT query. All it does is select some records. The command you used was DoCmd.RunSQL. This supposes the query will perform an action. Actions include UPDATE, INSERT, DELETE. They do not include SELECT.
  6. Mile-O

    Access 2000 Tables imported into Access 2007

    Is it in a folder that isn't yet trusted by your Access install?
  7. Mile-O

    Date Problems dd/mm/yyyy - mm/dd/yyyy

    If you change the format to: dd-mmm-yyyy what results are you getting?
  8. Mile-O

    Unexpected Data Retrival in Form

    Use queries for your forms and controls; never tables.
  9. Mile-O

    Question about VBA Code

    Before the WHERE you have a random bracket. Take it out.
  10. Mile-O

    function for dayvof the week

    Set the Format property of your textbox to: ddd. mm/dd/yyyy
  11. Mile-O

    Help me in this query

    With all respect, I'm advising, not doing your work for you. Advising is free. Doing work costs.
  12. Mile-O

    Newbie creating 1st Form

    A screenshot is fine, but example is good, too. Just trying to get an idea of how it works. Not wasting anyone's time. On the board, anyway can take a look and advise.
  13. Mile-O

    Newbie creating 1st Form

    Sorry for being so forensic in my questioning, just trying to get a clearer picture. So, each person is asked 25 questions, all of which can have the same answer? Or each person (of which there are 25) is asked one question and the answers are all recorded on one form? I'm also curious as to...
  14. Mile-O

    Newbie creating 1st Form

    25 comboboxes on a form...? What are you capturing?
  15. Mile-O

    Help me in this query

    While you've seen my example, I don't know how helpful it can truly be as you've not answered my first question about your table structure?
  16. Mile-O

    Scottish Independence

    It may well be difficult on both sides for the first number of years. Should Scotland vote Yes then there will have to be money spent on setting up institutions to facilitate the running of the country. Maybe the north can have its own referendum. Or maybe a more federalised UK will become a...
  17. Mile-O

    Scottish Independence

    Scotland's lost some land, then. Hadrian's Wall is completely inside England. If that was true, that Labour needed Scotland to effectively assume power in the UK, then they may have been less likely to sway right from their lefty roots. However, out of the post-war elections, I think it's only...
  18. Mile-O

    Do I need a requery?

    Data Type mismatch? Sounds like a delimiter issue. What's the line you use to reference your combobox?
  19. Mile-O

    Runtime 3061

    RecordSet objects don't like parameters unless they are defined via a QueryDef object first. If you search the form for 'Too Few Parameters: Expected' then you will find countless examples of this and how to solve it. Effectively the '[TempVars]![tmpFieldWorksID]' needs defined in the Query...
  20. Mile-O

    Do I need a requery?

    Completely aside, as I'm curious about the situation... What have you been doing there for the last thirteen years?
Back
Top Bottom