Search results

I'm looking to build a string in VBA I have successfully implemented code using Listbox.itemsSelected However, I am now trying to build a string that uses all of the items in the list box, when none are selected. I am having trouble locating what property I should be using For Each...

I have a string of text on a form (in a text box) Example: "Includes: Room 1, Room 2, Room 3," I am looking to extract the Rooms to turn into a SQL statement "Room 1" OR "Room 2" OR Room 3" I need to loose the "Includes:" and the commas, including the comma at the end. I see the Split...

Couple questions. When a Dim is defined as String (Dim strCriteria As String) and then I want to use the String in a SQL statement What does the Quotation and ampersand mean here: " & strCriteria & " Context: WHERE ((" & strCriteria & ") AND(" & strCriteria2 & ")

I have a form where I push a button and some code runs and generates the SQL for a query. I'm looking for a way to automate a check in a yes/No "completed" field in a sales table based upon the results of that query. For example the query generates a table of Product A, Room 1, Job Z...

I have a multi select list with VBA code feeding a query. Currently, if I select one or many of the items in the list, I get a query that is filtered by those selections. I'm realizing that it will be necessary to have the option to exclude the selected items from the list. The form needs a...

I have a field labeled U/M (unit of measure) that is mixed. Meaning it has "hr" ; "ft" and "ea". Thats the way my imported excel sheet is set up. I'm trying to setup a control on a form to check a query, and total the quantities associated with each U/M Any advice on how to express this?

Newbie here, I'm having a problem trying to implement VBA. I have a Form that is working fine, then I turn on the VBA and some controls stop working. For example, I have a text box control source set to this =DLookUp("[Project Name]","ProjectLog","[Project Number] =" &...