Recent content by dj_mix

Thanks, I already reveiw that example.. I was able to fiilter the result to the next form. I have other problems. Please look at pics they show what's wrong.

Guys, I need help on how do I pass information from my Listbox to another form via double click envent. I'm trying to create a call log, please view my database and see if it's possible, maybe my tables and relationship is the cause?

Very Nice I went with the majority Left([TYPEFY],Len([TYPEFY])-3) Thanks again

I trying to figure out how to remove the last 3 Characters from my data Such as MA-D-97 MA-09 UJS-KK-OL-20 Like the data to look like MA-D MA UJS-KK-OL I Have This so far Right([TYPEFY],3) that selects the last three now is there a remove function I can use?? Remove(Right([TYPEFY],3)...

Thanks that worked !! so that whats that's called

Need help how do I disable this bar ?

thanks got it to work..

How do I add <ALL> to the top of my combo box ? <ALL> = * (ALL) this is my current Row Source SELECT DISTINCT [State Aid Projects].COUNTY FROM [State Aid Projects]; this is for a form, with a command button to view report.. query looks at the combobox for the data

hmm , this might be a problem ma-07 1907 since we add new projects for 07 now.. I may need to add a buffer to the "current year + 1" This is the code I ended up using and works great "current + 1 year" Year: IIf(IsNull([TYPEFY]),"",IIf(Right([TYPEFY],2)<=Right(Year(Now())+1,2),"20" &...

cool it looks like its works, thanks

Year: IIf([TYPEFY] Is Null,"",IIf(CInt(Right([TYPEFY],2))<="06","20" & Right([TYPEFY],2),"19" & Right([TYPEFY],2))) This code won't work if I have 2001-2005 it will give me years 1901-1905 anyone every run into this problem ? I would appreciate any help.

More of a update got the blank taken care of Year: IIf([TYPEFY] Is Null,"",IIf(CInt(Right([TYPEFY],2))<="06","20" & Right([TYPEFY],2),"19" & Right([TYPEFY],2))) instead of using )) "06" how do I convert it to current year format "yy"

I guess I didn't explain it well, but I was able to modify your code but need one bit of help Year: IIf(CInt(Right([TYPEFY],2))<=DatePart("yyyy",Now()),"20" & Right([TYPEFY],2),"19" & Right([TYPEFY],2)) how do I modify this DatePart("yyyy",Now()) to current year format "yy" also how do take...

The field is a text field which usually looks like these: MA-04 CA-02 BW-99 MA-MAD-02

I have the following data in the field MA-84 I created a query and added the following Year: "20" & Right([TYPEFY],2) when I run the query I get a new field named Year and the format looks like 2084 Now I just need a IIF statement that looks at 2084 and compares to to current year is the...