Search results

  1. F

    Combobox help

    I have a couple of combo boxes which are bound to respective tables where they look up their 'choices' - they work fine, however some of the text is too long to fit in the combo box and there is no room on the form to widen the combo box (well, there is, but it wouldn't fit on one screen without...
  2. F

    A text box with a warning on a report

    You are a diamond, thank you. I am just shutting down for the night, but will do that tomorrow an post back how I get on. Cheers :)
  3. F

    A text box with a warning on a report

    I will try and explain this as best I can, but please feel free to ask if I don't make any sense. I have a report which shows five year training records for staff; when they attain their qualification, they are given an expiry date for that qualification, and they must attend 5 courses over...
  4. F

    Search to find specific string, or something near it?

    After all that, I spoke with the primary users today and they don't want a fuzzy search, they just want a drop down that shows a list of email addresses already stored - so its as easy as a combobox. Thanks anyway :)
  5. F

    Search to find specific string, or something near it?

    I am trying to allow users to search by for an email address (they will type or paste the email address into a textbox), but I would also like to give them the option to go on and search for email addresses that are similar to rule out any potential mis-spells etc - is this possible with VBA?
  6. F

    Joining queries together?

    Fantastic! Thank you!! :) :) Works like a charm, and now that I see it, I have absolutely no idea what made me start faffing around with more queries.
  7. F

    Joining queries together?

    This is the code of the subform which simply shows the total number of complaints (first and second column on the screenshot): SELECT PublicComplaints.Route, Count(PublicComplaints.Route) AS “NumberOfComplaints” FROM PublicComplaints WHERE (((PublicComplaints.DateProcessed) Between...
  8. F

    Joining queries together?

    Sorry guys, I am being really thick here, but where would I put the expression? If it helps, here is the SQL for each of the three queries: SELECT PublicComplaints.Route, Count(PublicComplaints.Route) AS “NumberOfComplaints” FROM PublicComplaints WHERE (((PublicComplaints.DateProcessed)...
  9. F

    Joining queries together?

    I currently have a sub-report that counts the number of records between two specified dates, and sorts them into order based on a field called 'Route' however I am looking to refine the data a little further based on another field 'Fault' Essentially, I am looking to have a sub report that...
  10. F

    How to limit to the 6 most recent dates?

    I didn't know you could put something like that in a query, thank you :) It works, sort of, but it is returning the 6 oldest dates as opposed to the 6 most recent ones - - I have tried swapping the Top for Bottom or Last and that produces an error; what is the opposite of Top in Access? EDIT...
  11. F

    How to limit to the 6 most recent dates?

    I have a form with a combo that allows users to select from dates that are found in a table; as there are numerous records within the table that have the same date, I have used the min function to ensure that each date only shows once. However, the list of dates is growing, and I was wondering...
  12. F

    String ignoring null

    Sorry for the late response to this - broadband issues along with a few other things, and of course work, have all slowed me down somewhat. Thanks to all for the input - stopher's solution above worked a treat :)
  13. F

    String ignoring null

    Is there a way to create a text string that ignores nulls? I have the following fields Zone1 Zone2 Zone3 Zone4 Zone5 Zone6 These are set to return a number as text (so 1, 2, 3 etc), or Null as appropriate. What I am trying to achieve is that the text stored is concatenated into a string...
  14. F

    Field value from multiple records VBA

    If you were picked up at Heathrow, and (I presume) went round the M25 to head for Bury you would have been fairly close to me - - I am quite close to Staines (or Staines Upon Thames as it is now called, because the council wants to make it sound posh!) If you get a chance, for a reasonably...
  15. F

    Field value from multiple records VBA

    On the very fringes of South West London, about halfway between the M3 motorway and Heathrow airport. You would be most welcome (but I hope you can hold your drink, as I am a Scotsman by birth and we have a reputation to uphold! ;) If I wanted to get really fancy and put the result in order...
  16. F

    Field value from multiple records VBA

    Did I tell you I was blind as well as stupid? :D Well, it now works perfectly; once again, you have got me sorted. I am raising a glass of Scotch in your honour, and if you were here there would be a bottle with your name on it. :)
  17. F

    Field value from multiple records VBA

    It decompiles fine, so I am going to do a quick backup, compact and then reboot the PC just to put my mind at rest that I am not missing something by not doing the immediately obvious - I will be back shortly.
  18. F

    Field value from multiple records VBA

    Handy, thank you :) OK, I have stepped through again, with that in place and it returns: SELECT VehicleTypes FROM TypesKnown WHERE EmployeeNumber='0770979' I have attached a screenshot of the table structure, just in case you can see something I am not. The employee number is stored as text...
  19. F

    Field value from multiple records VBA

    It is huge, and loaded with stuff that I cannot release into the public domain I'm afraid. I have just stepped through the code, and it works through the function until it gets to this line: Set rs = DBEngine(0)(0).OpenRecordset(strSql, dbOpenDynaset) Then it jumps to the Error Handler
  20. F

    Field value from multiple records VBA

    Good call - there was a space missing after SELECT, so that is now back in place and I am back to square one - - Too few parameters, expected 1 Is there any other way to show this sort of result?
Back
Top Bottom