Search results

To make this as simple as possible lets say I have a report with 2 fields Field1 and Field2. What I want to do is if Field 2 is null then display Field 1 otherwise display Field2. I used the following code Iif(IsNull([Field2]),[Field1],[Field2]) This did not do anything. Is it not possible...

Hopefully this is an easy fix but can't seem to find anything on it and I have never had this happen to me before. I have a command button with the following code to insert a hyperlink Me.Attachment.SetFocus DoCmd.RunCommand acCmdInsertHyperlink This worked fine when I first created...

Wrote this code about a year ago and worked fine up until last week. I do not use access or vba daily so this problem maybe something very easy but I tried a lot of things and am kind of stumped. I have a table (tbl_classes) which contains all upcoming and completed classes, the difference is if...

Looking for some help again. I have a table that stores training records so if employee A went to training they enter the data on a form and save it so a new record is created in this table. Now if employee B goes to the same training later that year it creates another record in the table. Now...

I have never used access before and started working with it a couple months ago and have gotten a very good understanding on how it works but now I have been trying to learn some coding. This is my problem: I have a table (tbl_events) which contains training records for some employees. It...