Search results

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?

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

Need help how do I disable this bar ?

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

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

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

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

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

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