Search results

In this situation the popup box works much faster then a list, combobox since the list of municipalities large, easier to type the 1st few letters and print a report it works fine in my query Like "" & [Please Enter Municipality Name:] & "*" but i trying to remove the query and add code to...

Yes it's a Parameter Box [Please Enter Municipality Name:]" is a popup box where you enter the name of the municipality this part works fine: stWhere = "[County] = 'ESSEX'" & " And [FPAID] Is Null" & " And [LOCATION] =" & "[Please Enter Municipality Name:]" I want to add a * to the end...

I trying to add a additional arugument.. and hope someone can help me these syntax errors are killing me stWhere = "[County] = 'ESSEX'" & " And [FPAID] Is Null" & " And [LOCATION] =" & "[Please Enter Municipality Name:]" I get the popup to enter municipality works fine but I'm trying to add...

Thankyou that worked great !!

How do I combine these 2 aruguments into one Line ? stWhere = "[FPAID] Is Null" stWhere = "[County] = ""ESSEX""" I tried stWhere = """[FPAID] Is Null" & "[County] = ""ESSEX""" i get a syntax error (missing op) in query expression '("[FPAID] is Null[CCOUNTY]= "ESSEX")' BTW Code works fine if...

I like this code, but have 1 question what does these two lines do ? DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBer, acEditMenu, 6, , acMenuVer70 Reason I ask is I if remove those 2 lines, my form opens and has focus (curson goes to the first form box)...

I'm glad you used the chr trick I never knew about it and now when I get into complex code I will keep it in mind.

Ok I got it working thanks again.. the syntax for print preview did require a space.. stwhere needs to be the 4th argument .. DoCmd.OpenReport stDocName, acPreview, , stWhere Private Sub ActiveEssex_Click() On Error GoTo Err_ActiveEssex_Click Dim stDocName As String Dim stWhere As...

will there be a problem with this part of the code? DoCmd.OpenReport stDocName, acPreview, stWhere I seen somehwere where the condition should be the 4th arugment? like DoCmd.OpenReport stDocName, acPreview, , stWhere

001 - Status Report 1 - General - Active is the name of the report I know it's long but that how it was setup at work.. I will try what was mention when I go back to work on monday...

I am trying filter my query from a form to print a report. The orignal query includes all the counties field = [County] I would like to click on a certain command button on my form and only show counties that equal ESSEX ... I have this code so far but it will still show all counties in my...

Try it and worked Great !! Thanks so much

can anyone help ass code this this module so it will connect to a access database file that has a password. The code works fine on non password database file. I search the web and found some info but doesn't seem to work for me.. main module Option Explicit 'Look in the Examples module how...

Got it to work "SELECT * FROM [qryProjects]" & "[PROJECT] LIKE ""*" & Me.txtSearchString2 & "*"" And "

Hello I'm trying to convert my exsting LIKE Command to search Contians a word. Example currently it will search for word starting with word in the search box. I type in 2006, it will only look for project names starting with 2006. I would like to Motify the search to "Contain" 2006 in the...

Ok I got it to work Thanx for the help .. I lead me to the right direction LSearchString = txtSearchString 'Filter results based on search string LSQL = "select * from [Projects - Active]" LSQL = LSQL & " where [ID] = " & LSearchString & "" Form_frmSearch_sub.RecordSource = LSQL...

says 2001 You cancel the previous operation I appreciate the help...

Just tried that I get a error Run-time error '2001': You cancel the previous operation any idea what the error is ? Thanx

I have a search box and it looks up project id number. the orginal code works but filters anything with that particular number. I like to adjust the filter to equal to the number enter. ex,, I enter 22 , i get records with 622, 223, etc I want it to be only 22 I can't seem to figure this...