Search results

Hello, I have a form with three subforms that display three separate tables. I know there's a way to do it, but I haven't figured it out... I'd like to have a unbound textbox and button where I can enter a keyword into the textbox and On Click, the three tables filter to only those...

I have an excel that exports from another program. Unfortunately, the source includes leading spaces in some of the column headers. I have the following command to import to a specific table with similar headers: DoCmd.TransferSpreadsheet acimport, acspreadsheetTypeExcel12XML, "tblA"...

I have a form that opens in new and includes a couple fields with DMAX code On Load. But, sometimes the rest of the form isn't filled out. Is there a way to set the form to save only when the other fields are populated? Otherwise, I end up with a table with a bunch of empty records.

I have an On Open event for my form that says Me.fldX DMAX("[fldX]", "tblX") + 1. fldX appears fine (it adds one to the highest number in that column and places the result into fldX), but when I enter values in the remaining fields and close the form, fldX show a value of 0 in tblX. Any...

Simple question for a silly program. Is there a way to and have two fields on a form automatically populate with a random field when a button is pushed? I.e. txtfld1 populates from a random field in column 1, tbl1 txtfld2 populates from a random field in column 2, tbl1

I tried doing a search on this, but apparently "contains" is too common of a word that the search automatically deletes it as a keyword.... I have an unbound textbox where I want the user to place keywords. Then when they click the report button, I want the report generated to show all records...

Below is a code I'm trying to use to filter a report by the value in Combo14. The value in Combo 14 is determined by the value in Combo 8 (cascading) The code I'm using causes an "object required" error. On Error GoTo Err_cmdReport_Click Dim stDocName as String If Me.Combo8.Value =...

Easy question I can't find an answer to. I know how to cause frmB.fldA to match frmA.fldA using the onopen cmd. But how do I cause rptA.fldA to match frmA.fldA using the onopen cmd? There doesn't seem to be a "Me.fldA.Value =" option.

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

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