Search results

Is there an option in excel to identify (and list the number of times) common phrases that appear in the worksheet? My boss wants me to go through a worksheet of hundreds of customer feedbacks and identify the 10 most common complaints.

Hello, Simple question (if I can ask it correctly)... How do I properly quote a field if it is a number or text? i.e. I know a number textbox is written as " & fldA.Value & " How is it written if it is a text field (or any other type)?

Hello, I have a form with the following fields: fldAutoNumber - Auto Number - TextBox - PK fldYear - Number - TextBox fldSurveyName - Text - TextBox fldQuestion - Text - TextBox fldAnswerType - Text - TextBox fldWritten - Memo - TextBox fldSelect - Text - ComboBox fldMultipleChoice - Text...

Hello, I have a form with some fields from a query and some fields that are to be filled in. How do I get the form to save the user input into another table? The table I want to save to has fields named the same as the form fields.

I don't know what happened, but I got it to work!... Do you mind answering another quick question though (promise it's the last with this issue)? I created an open form button that I want to take the values of the 2 combo boxes and display all records with matching values in the opened form...

I created a query using the code and I drilled down the issue further to the problem being somewhere in - " & Combo9.Value & " Still not sure how to resolve the problem though. I've tried everything I can think of.

Which bit are you referring to? I'll run it through a query and see what comes up...

OK, So what I've figured out is that the problem is somewhere in the WHERE clause. What exactly, though, I don't know because I'm not getting an error. Any thoughts? " WHERE tblSurveys.fldYear = " & Combo9.Value & " "

The code is the same but without the apostrophes. I'm not sure what you mean by setting a breakpoint...

I thought it might be, but it still appears blank.

I know this is an easy fix... I have cascading combo boxes. The first combo box returns the value of tblA.fldA (which is a number field). The second combo box is supposed to return the value of tblA.fldB Where tblA.fldA = the first combo box. Nothing is coming up in the second combo box...

I have a form with 4 boxes: Box 1 has one of 3 values in it. Box 2 is a textbox. Box 3 is a combobox. Box 4 is a listbox. The value in Box 1 determines which of Box 2-4 becomes visible. I have the code written/tested already: If Me.Box1.Value = "A" Then Me.Box2.Visible = True However...

Hello, I tried writing code to change the control type of a field in a form, but to no avail. Here's what I wrote.... If Me.fldAnswerType = "Select" Then Me.fldAnswer.ControlType = acCombobox But that is only part 1 of the problem. Part 2 is the following: fldAnswer is an unbound text...

I created a database where the user can "Create A Survey". The survey is designed to allow the user to create questions and then indicate whether the responses are going to be written, select one, or multiple choice. If the user designates the responses to be select one or multiple choice...

This is my first time trying to use a msg box. How do I write code to display a msg box asking, "Are you sure you want to exit without saving?". If the person selects yes, then the form is exited. If the person selects no, then the form remains open.

I have a form that auto-populates based on data from a previous form. So my issue is that a record is created even if I don't enter additional data into fields that aren't set to be auto-populated. How do I modify the close button to delete that record before closing the form?

Thanks Bob! That helped!

I know I've seen the answer before, but I can't seem to find it now... How do I get the value of a field in the form I'm viewing to automatically match the value of a field in another open form.

Hello, I have a vb code written that opens a word document and displays the results of a query. What is the code to cause the document, after opened and populated, to automatically save a copy into a predesignated folder - and to rewrite previous existing documents with the same name...

Ok, I figured most of it out except 2 things 1. How can I change the Browse button into a save button that saves into the "c:\desktop\" & Me.fldA folder? 2. How do I have it automatically display the results of what is in the folder?