Search results

  1. B

    Word count of memo in query?

    It only needs to be a rough estimate so that's perfect for my needs. Thanks!
  2. B

    Word count of memo in query?

    Spot on, thank you SO MUCH! :eek:;):D
  3. B

    Word count of memo in query?

    Hi everyone I have a database which receives nominations for an awards ceremony. I would like to filter these nominations using a query which shows only the nominations which meet a certain word length (>500). Currently, I have this as my query, but I realised this is actually filtering based...
  4. B

    Change combo box to original value?

    Yes it is this line causing the Null error: new_gp_practice_id = Trim(Replace(Me.cmb_gp_practice, vbCrLf, ""))
  5. B

    Change combo box to original value?

    Sorry, I realise my post sounds confusing. This code is working as in it doesn't give me any weird errors with normal use, only when I try to select Null values or when I try to cancel the change.
  6. B

    Change combo box to original value?

    Hi everyone I maintain a large database of employees. I have a form with a combo box (cmb_department) which I can use to select a particular department. I have written an After Update event procedure which updates the relevant fields on the form after I've selected a department - e.g. their...
  7. B

    Data type mismatch in criteria expression

    Thank you Bob. Problem solved! :D
  8. B

    Data type mismatch in criteria expression

    Ahhh I think that explains where I was going wrong. Thanks, will give it a go on Monday!
  9. B

    Data type mismatch in criteria expression

    Hmm, I'm sure I tried that... I'm not back in the office until Monday to test it but just to confirm, would this be the solution? SQL = "SELECT name, department_manager, department_code, address, organisation, phone_number from dbo_departments WHERE department_id = " & new_department_id & ""...
  10. B

    Data type mismatch in criteria expression

    I'm feeling really confused! I have a piece of VB code working perfectly when I "hardcode" a value into my script, but I get the run-time error '3464' data type mismatch in criteria expression when I run it with a variable. Here is my code: Private Sub cmb_department_AfterUpdate()...
  11. B

    Drowning in queries - is there an easier way?

    Thanks CJ... I've not done much with reports before. Do they work in a similar way to forms? Can you select variables in a report, e.g. if I need to change the date selection? I'd like something I can easily hand over to someone who has never gone "behind the scenes" in access before and is...
  12. B

    Drowning in queries - is there an easier way?

    Just wanting to pick the collective brain of the forum and ask how I would be best off doing this... I maintain a large database of employees. Each employee has a record (stored in "user" table) and any changes relating to any of their employment details are audited by recording a record under...
  13. B

    Run-time error 3075

    Oh goodness me. It didn't work originally and threw up all sorts of problems, which is why I tried the second suggestion, and then tried to get that working. I've just tried yours again to remind myself of the errors I was getting, and it works as intended...
  14. B

    Run-time error 3075

    Thank you... your suggestion eliminates the error Paul, though it means that when I search for nothing I get nothing, rather than everything. It's not such a big deal though and I'm happy to just not see the error anymore, and will encourage our users to use * instead of a null to return all...
  15. B

    Run-time error 3075

    Just tried that too and still getting an "invalid use of null" error... :( I've attached a screencap of my code. I'm completely lost!
  16. B

    Run-time error 3075

    Thank you CJ_London. I've tried that but I'm getting compile errors saying "expected end of statement" after this bit: Replace(search_text, "'", "''") & "*'") but I can't see where there's a bracket missing... I've copied your code like for like. Can someone with a more finely turned eye for...
  17. B

    Run-time error 3075

    Sorry, what I meant is sometimes I search for nothing e.g. just hit enter on a blank search box and it used to return all values, until I changed the code to your suggestion, and now it gives me an error saying nulls are not allowed. Not sure why!
  18. B

    Force unique, set length field value OR exceptions

    Thing is, I can't give everyone a number as they don't have numbers. That's like saying give everyone a fake name. I need to be able to query my employee_number field - if it's got a number in it then that means they're one of our employees and they have an employee number. If I put some random...
  19. B

    Force unique, set length field value OR exceptions

    How? I don't understand, sorry.
  20. B

    Force unique, set length field value OR exceptions

    Unfortunately, an autonumber field wouldn't work in this case. The employee number is imported from our payroll system so not determined by our database. There will be internal staff without a number too.
Back
Top Bottom