Search results

I went through this EXACT same problem yesterday. Let me guess, you are putting the IIf statement in the criteria of a field on the query. I found a solution for it. It's ugly but it works. Check out the thread I started for it.

No matter how I tried this in the criteria section, it wouldn't work. But, I got it. Instead of putting the IIf statement in the criteria section of the query design, I had to add another column in the query and add this: Expr1...

SELECT [txt_JobID], [txt_JobCategory], [txt_JobStatus] FROM tbl_JobTracking WHERE ((([txt_JobCategory])=IIf([Forms]![frm_JobList]![cbo_Category]="<All>",Is Not Null,[Forms]![frm_JobList]![cbo_Category])); I did try it with quotes around Is Not Null. When I do that it actually looks for the...

Tried that. Tried that too. Though when you put quotes around it, I believe it is actually looking for the string "Is Not Null" in the field and not all records that are not null Now if I substitute an actual selection from the combo box the query works as expected. So the error definitely...

[SOLVED - sort of] IIf and Is Not Null not working I have a combo box on my form that will filter my query criteria. In my combo box, I have the selection "<All>" to allow all data to show. I put this statement in the Query criteria box: IIf([Forms]![frm_JobList]![cbo_Category]="<All>",Is Not...

Are you getting errors when you execute this? I rarely use DAO anymore to update records like this (I usually use SQL statements now) but below is how I might write the code for what you are trying to do. If you use SQL, I think your code would be shorter. Good Luck Private Sub CmdAdd_Click()...

I agree with pbaldy. Do a search for Audit Trail. There are many excellent examples on here. I put mine in the "Code Repository" section.

If you want this done automatically, look up "CDO Email".

In my previous job, once one person figure out the bypass key, it wasn't very long until EVERYONE knew about it, so I learned to disable it rather quickly. They were bypassing everything in all the databases we had. Needless to say it became a data integrity nightmare. I understand what you're...

I put my audit trail sample in the code repository Give it a try and see how you like it.

Try adding the word "DISTINCT" after "SELECT" in your query. Ex... SELECT DISTINCT [MyField] FROM [MyTable] This will only return the one value. Without seeing it in action, I'm not sure if it's what you are looking for or not.

If you work for a large corporation, be careful. It is highly likely that you signed an NDA (Non-disclosure agreement) when you were hired which prevents you from doing this if they can prove you developed even one line of the database at work or on a work computer. Usually, anything developed...

Try using the words "True" and "False" instead of the integers. If Me.filterirregular = TRUE Then ElseIf Me.filterirregular = FALSE Then End IF

Since you are using an option group try something like this: If Me.OptGrp1.Value = 1 then Me.cmdPrint.enabled = true Basically, since you are using an option group, you need to use the option group as a whole and assign values to each check box. The you are going to use the option group value...

Just wondering if anyone has run into this. I have a backup/compact procedure similar to Roger's example here The code copies the original then invokes: DBEngine.CompactDatabase sOriginalBackup, sCompactedBackup The problem is that it really isn't compacting the database. Example: My...

I (as many others here) wouldn't suggest actually storing the files in Access. Can it be done? Yes. But by storing files in Access, your database will bloat very quickly. My suggestion would be to "catalog" them in access, storing only the file name and path in the table. Keeping the actual pdf...

Thanks. Sometimes I overlook the obvious thinking it's more involved than it actually is. As far as the "kill" yes, deleting the file is the goal. I'll probably remove it though.

Hi All, Please reference the attachment. The item in particular is the image box. I have the code so that when I double-click, I insert an image, and the image shows up via the "Me.Requery" statement. The weird thing is when I delete the image, and try to requery the form, the image box...

Oh, I do. I was just using that as an example. I always use prefixes such as "frm" "tbl" or "rpt" (I changed the original post to reflect that)

No wonder I couldn't get it to work LOL. Thank you once again for your help. I appreciate it.