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 figured out the issue- when one of the excluded boxes is checked the text in the text206 or text208 will never be all. So I had to change the if statement to reflect reality. However, I would like to ask question about the instr function you are referencing. It appears to use this, I would...

I changed to True/False- Still Getting same "AND () AND ()" Error

Whats wrong with this: If Me!Text206 = "All" And Me!Text208 <> "All" And Me!chkExcludeRoom = No And Me!chkExcludeMemo = Yes Then strCriteria2 = Me.Text208 strCriteria2 = Replace(strCriteria2, "Included: ", "") strCriteria2 = Left(strCriteria2, Len(strCriteria2) - 1)...

June7- Thank you! That worked, except rooms that have 2 names are not winding up in the string Example- "Staff Lounge 123" is not updating. However "Exam Rooms" are EDIT: NM, I think I had something wrong in the Replace Function. Working fine now

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 & ")

June7- Yes there will be 2-3 users, potentially simultaneous, but highly unlikely they will be in the same Record at the same time. That said, I don't think that I understand the problem with the check field...

Completion of a work order. Updates the Estimate Data table. Which then I can use to generate invoices (Construction- monthly billings) At least that's my theory I'll take a look at that update query. Any tips are appreciated!

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

Thanks for the help!

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

Holy Crap, Thanks Mr. Obvious I was racking my brain with that for 2 hours!

Excel sheet is imported to table, One of the fields is U/M, containing LF (Lineal Feet, ea (each) or hr (hour). The excel sheet also has other columns, Such as Products (product A, B,C) along with Rooms (Room 1, 2, 3), and QTY I have a form with a combo box for Product and a combo box for...

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?

FYI- I've created a copy of the problem form and everything works as expected. I must have changed some setting in the VBA or something. Not really solved, as I don't know why the program was behaving like that, but I can at least move on

I have the same scenario in another Form, except everything is working fine. The problem form works fine too, until that forms Module property is turned on. Then it doesn't work. Heres the setup On the a form named "EstimateDataReportForm" Combo box selecting project number (to a table...

I dont have anything yet.. Just says Option Compare database The VBA explorer says i'm in "Microsoft Office Class Objects" folder -Form_WorkOrders

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] =" &...