Search results

Ya very poor design but it is what I am stuck working with until I rebuild it but I modified the report a little and was able to use the IsNull() to help me do what I wanted to do. Thanks again for the help.

Well the report source is a table and the way the person had built this is a little screwy. It has several fields one is employee, one is training, and one is the year (so this year it would be 2013 but it contains past years). The Training and Employee already have data filled for example...

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

Thanks missinglinq. I played around with changing some stuff in the trust center settings and the folder where the database was being stored was not a trusted location so that fixed it. Thanks again!

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

Wow I feel pretty embarrassed. I had no idea that a couple spaces would be the cause but I got rid of them and it works. Thanks for the help and the tip for debuggin, it will definetely help in the future.

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

I knew it would be something easy but I have never used crosstab queries before but that is exactly what I needed. Spent alittle bit of time reading about them and was able to create the reports which my boss has been asking me about. Thanks your a lifesaver.

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

Ya I wasnt sure about using the string or date/time but I tried what you had said and that code worked perfectly. Thank you for the quick reply and help I appreciate it.

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