Search results

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

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

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...

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

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.

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...

Thank you Bob. Problem solved! :D

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

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 & ""...

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()...

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...

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...

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...

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...

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!

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...

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!

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...

How? I don't understand, sorry.

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.