Recent content by zkoneffko

I'm having an issue that I feel should be a simple fix but I simply can not figure it out. I have an iif statement: IIf([forms]![Main]![District] Is Null,IIf([forms]![Main]![DistrictList]="View all Districts",>0,[forms]![Main]![DistrictList]),[forms]![Main]![District]) The problem is the...

I have a drop down menu in a form and for the default value I have it set to "View all Districts" so the use can simply view all districts instead of choosing one from the dropdown. I am using an iif statement and trying to use the Like "*" function if the drop down is equal to "View all...

I trying to have a way to to have the same iif statement across multiple queries without have to go in and change each query every time that statement changes. The statement will change rather often so this would make future use much easier.

Yes I meant iif, sorry for the mistype. I understand it might not be the best way but I personally don't know another way. If someone can tell me another way to only change the iif statement in one place to affect a large amount of queries I willing to listen. If not if there a possibility to...

I am developing a access program that has a large amount of queries in it. Most of the queries will use an iff statement in them. The iff statement will be the same across most queries but it will also change every few weeks. Is it possible to save the iff statement in a table and just call...

Thanks that worked good!

I have drop down menus on a form that I use in an iif statement in a query to narrow the results according to what is selected. However they will have the option to leave the drop down blank and I want it to return all possbible results. How do I write an iif statement to return all items if...

I have a field that looks like this YCS1292. It is saved as a text field. The right 4 number are the month and the year the account was created. In this example it would be 12/1992. I need to convert this to a date so I can do a between function in the query. Can anyone help? Thanks!

I tried =[CurrentDb].[Name] but that doesn't seem to work. Any reason that doesn't work?

I would like all of my reports to list the current filename. Can someone please help me out with how to do this?

I am having a very odd thing happen in one of my forms. I have added 8 if statements that simply display a line of text if a statement is or is not null. The if statement looks like this: IIf([AttributesPrivateNote] Is Not Null,"Private Notes Available","") Each field is looking at...

I'm an idiot Never mind I'm an idiot. I just refered to the field in the form like this: Private Sub Command1_Click() Command1.HyperlinkAddress = Forms!form1.testfield End Sub

Ok. Here is what I'm trying to go. I have a field in a database that is the name of a file. In a query I formated it to a new field that included the address of where that file is on the network. The new query looks something like this: \\web01\website\images\test.jpg Since I created the...