473,626 Members | 3,291 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to produce report on the options, checkboxes, etc a user entered on a form

1 New Member
I've been trying to figure this out for a few hours now.

I have an MS Access 2003 quote configuration tool that produces quotes based on about 100 different controls (including option groups, combo, list and text boxes, etc) that an end-user selects. I imagine that these controls will change in the future, so I want flexible 'what did the end user click on to produce this quote' report. I don't want to have to change the code behind this report every time I make a change elsewhere in the quote configurator.

I've created the following code, which cycles through all controls that have tags. What I'm having trouble with is programmaticall y determining what option group values mean (same problem for combo boxes). I don't know how to identify the options and their respective labels in an option group.

Expand|Select|Wrap|Line Numbers
  1. On Error Resume Next
  2. Dim i As Integer
  3. Dim str As String
  4.  
  5.  
  6. Me!SelectProperties.Controls
  7.  
  8. For i = 1 To Me.Count - 1
  9.     If Me(i).Tag <> "" And Me(i).Visible = True Then
  10.             Debug.Print "tag: " & Me(i).Tag
  11.             Debug.Print "Value: " & Me(i).Value
  12.             If Me(i).ControlType = acOptionGroup Then
  13.                     'me(i).  I get stuck here...
  14.             End If
  15.     End If
  16. Next i
Jan 26 '07 #1
1 1288
NeoPa
32,567 Recognized Expert Moderator MVP
I get most of what you're saying but I'm not sure what you want to do in the stuck section.
What do you need to determine here?
Can you provide an example to illustrate.
Jan 27 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

5
10105
by: Deborah V. Gardner | last post by:
I would like to use "Yes" and "No" checkboxes on a subform. The problem is that when I click the Yes checkbox on the subform, all of the checkboxes are checked. Currently, I have a field "Refused." It is defined as a text field. A "Y" means that the service has been refused; an "N" indicates it has been accepted. If the field is Null, the question has not been answered, i.e. we don't know if it has been refused or not. I want the user...
3
2892
by: RC | last post by:
I can't quite grasp the concept of creating custom reports depending upon what options a user picks on a Form. For example, the user clicks on a "Print Reports" button and a Form pops up. On the Form the user can choose to get a report that shows the Box Numbers that are at Warehouse A, Warehouse B or Warehouse C. and then click on the Print Preview button and get a report showing only the Box Numbers in whichever warehouse was...
1
4618
by: crjunk | last post by:
I've got an aspx page that allows the user to select different options whenever they want to run a report. On this page, I have added an additional text box for the user to enter in comments about the report they are running. I would like to be able to have the comments that the user has entered to appear on the report that is generated. I thought that I might be able to pass this text to the report by using a session variable but I...
4
2372
by: schmidtmic | last post by:
I have a table that contains 20 checkbox fields. Each checkbox corrisponds to an Score amount. For Example: Checkbox1 is worth 10 points Checkbox2 is worth 5 points Checkbox3 is worth 2 points Checkbox4 is worth 3 points
2
3081
by: john | last post by:
My report is based on a query with user input . In my report I have a text box with the following code: =. This works when the query outcome is 1 or more records. But when the query output is zero records this field shows #Error while I would like this text box to still show the year the user entered. The user input doesn't seem to be available when there is no query outcome. Anyone an idea to make this possible? thanks, john
1
1367
by: mbolokofsky | last post by:
I have been over the forums here, and I'm not sure if I have a unique situation, or I'm doing it wrong. I have a form with 7 listboxes. Each one is unbound, and the results chosen by the user are fed to the report. I also have checkboxes that are bound to a query. I am only able to display the data in the listboxes OR the checkboxes on the report, not both.
2
2174
by: Mike | last post by:
Hi guys, i have a table with 12 checkboxes for different type of products, so basically user has to tick if this product applies to the entered account. So, i have the same group of boxes in my report which i want to modify in a way, that instead of the checkboxes i would have text fields and instead of checkmarks i'd have numbers: so if Product1 box is ckecked in the input form, the report should show 1 in the Product 1 text field of...
12
3527
by: Studiotyphoon | last post by:
Hi, I have report which I need to print 3 times, but would like to have the following headings Customer Copy - Print 1 Accounts Copy - Print 2 File Copy -Print 3 I created a macro to print the report three times, but do not know how
0
8262
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8196
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8701
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8364
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
6122
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5571
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4090
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4196
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1807
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.