Search results

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

Finally got it to work with the following stWhere = "[County] = 'ESSEX'" & " And [FPAID] Is Null" & " And [LOCATION] like '" & strMunicipality & "*'"

Just tried it and got a syntax error: syntax error in string in query expression '([COUNTY]='ESSEX' And [FPAID] Is Null And [LOCATION] =bloom*")'

I will give this a try tomorrow, I appreciate everyone's help. I basiclly learned everything from this forum.. 6mths ago I had no idea about macros and vb code was... hopefully some day I can help out others as well.

It's based from a from run from a command button.. Private Sub ActiveEssexM_Click() On Error GoTo Err_ActiveEssexM_Click Dim stDocName As String Dim stWhere As String stDocName = "01 - Status Report 1 - General" stWhere = "[County] = 'ESSEX'" & " And [FPAID] Is Null" & "...

how do I convert to variable ? I'm new to access any links that can help me ?