Search results

I already posted this under reports and was directed to queries; sorry in advance for reposting, but this post will be more specific. I have a table with one field for each of 75+ survey questions. All survey responses are either 1, 2, 3, 4 or 5. Ultimately, I need a report that will tell me...

I have a form that collects student survey responses to about 75 questions. Each response is a value between 1 and 5. What is the best way to get averages, counts, and other statistics from the table?

I have a simple report of names and phone numbers. I have used the page setup to put them into two columns to get as many on a page as possible. Is there a way to repeat the headings "Name" and "Phone Number" at the top of each column? Would I be better off exporting this to excel or word?

I am trying to make certain controls visible on a form for both "on current" and "after update" conditions. I started with this: Private Sub Form_Current() If Item = "Monitor" Or Item = "Printer" Or Item = "Telephone" Or Item = "Scanner" Or Item = "Workstation" Then SerialNumber.Visible = True...

I have an invoicing form (frmInvoice) for computer purchases with a primary key of "InventoryID." frmInvoice has a combo box where I identify the type of equipment purchased (i.e., monitor, printer, tower, etc.). I also have separate tables for each type of equipment where I store the...

I have a backend on our server and a front end running on individual workstations. I have applied the shift enter lock (referred to in these forums and downloaded from Utteraccess.com) on the front ends and made them reasonably bullet proof by customizing menus, turning all forms into modal...

I have a database that tracks student issues. Each issue in this database is either "open" or "closed." When the user opens the form that allows her to edit or "close" an "open" issue, a modal popup dialog box requires her to choose from a combo box list of students who have open issues. The...

I have created a custom dialog box and am able to open a report displaying the selected data; however, I am unable to to the same to open a form. The parameter query works fine, but when I open the form from the custom dialog box (form) no records are present. Any ideas?

I want a custom dialog box with a combo box to appear when I open a form. I have browsed the forum and tried the following solution to no avail: Add a combo box to your form then lookup the table that your drop down list is stored in. You can then open your report based on the selection you...

I am a frustrated newbie. Have pity. My Goal: I am trying to set up an auto email notification process where I will receive an email message (without attachments) whenever one of our employees completes an electronic Access form. What I have done so far: I have set up a macro with the...