Search results

Ok this is a weird issue that has been troubling me, On some computers that I have, Access refuses to open databases through a shortcut. The only way to open any databases is to first open access the go to file open. I've tried creating new shortcuts, as well as mapping a drive and making a...

DB Code for query, Here is the click_event that calls the query. Private Sub cmdCSVStates_Click() On Error GoTo Err_cmdCSVStates_Click Dim filename As String Dim query As String query = "pkg_not_registered_email" filename = "C:\querytester\" & Format(Date...

query crazyness... That thought crossed my mind as well which is why i tried running the criteria with only one value ie "CO" , and yet it still returns nothing.

Query_pulling_from_form The query runs fine but it pulls no values - i've checked the info from the textbox that is being pulled in and it shows a value (in this instance it's states) "CO" OR "AZ" OR "CA" And prints a CSV but with nothing in the CSV (assumabely because it's resulting in no...

Hey, I'm a VBA Newbie. I have a query that pulls information from my form as criteria and i want to create a table with the results...I am having trouble searching online for a solution and Access Help is no help. Is there a way I can do this using vba?

I am having an issue pulling information from a form into a query. In my criteria column in the query i have: [Forms]![frm_createcsv]![txtCriteria] it pulls from a valid string from a textbox txtCriteria. My vba code is: Dim query as string query = "pkg_not_registered_email"...