Search results

Wow, you are a genius. How did you work that out? Thanks heaps! Any idea why your version works and mine doesn't?!

Hi guys & gals, I recently came across this really strange behaviour and was wondering if anyone else knows this bug or knows a better workaround than mine. I've attached a little Events DB, which has a search interface. I've included an export button, which runs a macro that does an OutputTo...

Thanks heaps, you just solved my problem :D

Thanks Bob, I finally worked it out. Writing a whole little program in ONE line kinda sucks... and it's not easy to debug either. My final "program" was a derivate of: =IIf(Nz([RoleID],0)=0,"True","False") where I replaced "True" with "" and "False" with the original DLookup query. Yay!

Ok, I kinda solved it by adding a dummy Role with a blank description to the Roles table. Every new entry in the subform-bound table now defaults to that blank role. Not pretty, but it works... I'm all ears for a more pretty solution, of course :D

How can I hide '#Error' in Text Field after DLookup? Hi there, I've been struggeling with this problem for hours now and I'm sure there is an easy fix. Searched the forum to no avail :( I've got a form with a subform in which combo-boxes are used to add staff to projects. Then, their Role is...

Thanks for the elaboration Doc_Man. Your post was very educational and nicely outlined the core issues I was facing. I think just through this thread I have a much better understanding on how I can translate my OO knowledge into the world of databases. I can't wait to give it all a whirl...

Wow, thank you so much CraigDolphin! Your solution with the different RoleTypes is *exactly* what I was looking for! It was doing my head in. Even with an example DB! I am literally blown away. Thank you (and also John_W) so much for your help, time and consideration. I really really appreciate it!

Fantastic, thanks CraigDolphin! I've thought along those lines, but your post gives me the confidence to go ahead with this approach. The only "problem" I see is that staff members of my company can take on *different* roles in a project than staff members of clients. So I guess I'll have to...

Hello guys & gals on here. I've been struggeling with this problem for a couple of days now and finally decided to post here and kindly ask for assistance. I've got a pretty strong OO background, but haven't worked with databases much... I'm trying to set up a small client database for my...