Recent content by timon10z

Ok I can change the names of the boxes and objects, thats easy. For now I have used the where clause in my sql, I don't want to get into VBA yet. Once I get it working I'll start to look at VBA and improving the build. R.

Ueeeeeeeeeeeeee it works!!!!!!!! Thank you really! A little bit closer to the end now! R.

Ok thanks, I'll try this when I have time and let you know the result So just a little background, I am a Finance major who is doing a Finance Internship and hadnt seen Access in my life, and suddenly I was asked to create this database. So I know I am not using and doing things probably as I...

Still doesnt work, but I dont understand why...something like that should work. I have even tried ending it like Iif(......,<>"U")) , which is not very professional but doesnt work either...

Ok great help thank you! (Btw your code didnt work either, the bits and pieces was a second try). Please if someone has a solution to this it would be great. Thanks! R.

I am asking the same thing. And I was not offered a solution, I was offered a reply. No need to be rude. WHERE [Proj Type]=IIf(([Forms]![Main Menu]![Frame73])=1,"CAP",IIf(([Forms]![Main Menu]![Frame73])=2,"OPER",[Proj Type] Not Is Null)) gives me a syntax error. Thanks! R.

Ok so "A" and "B" are already the two values that the field contains, I don't know if I understand well what you try to say. My Iif statement is to take only all records which have "A", all records which have "B" or all records in general. If on my [Frame73] I click either 1 (only "A") or 2...

Hello! I am more or less new in Access, and I am creating a Database using different tables. I have made a Union Query to put together some common fields for all tables and I am trying to define criteria. I have a field called [Proj Type], which can either contain "A" or "B". This is the...