473,671 Members | 2,446 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem with checkboxes in Access 2003

1 New Member
My problem is:

I'm trying to solve problems with my customers, some of them are paying me whole amount once, other pay 3 times a year and others 12times a year.
I put in a form 12checkbox-es each for every month. Now when user will select 2 or 5 different months to pay, i would copy those information’s into table.

Now i have different problem, how a table suppose to look like, i suppose to have only one field for all months, or separate field for each month.

Thank you in advance for your help.
I hope you will help to make my life easier :-)

I put screen shot from this form with months - it suppose to look like this :-)

http://www.fotosik.pl/pokaz_obrazek/...918c4ee73.html
Feb 21 '08 #1
2 1762
heifler
1 New Member
Just add one field in your table to accept a number byte data type will work.
Here is where you will store a value from 1-12.
To populate or change this value in a customer form, just enter the value directly or use a combo box containing the values 1-12.
If you really want the check boxes, then place them in an option group with each unbound check box have the value it need to populate this new field.
Then on the after update event of the option group, set the new field to the value of the option group.

Bob Heifler
Feb 21 '08 #2
NeoPa
32,569 Recognized Expert Moderator MVP
I'm sorry Bob, but links such as you posted are not allowed in technical posts on this site. I've had to remove them. Please review Signature Guidelines.
Feb 22 '08 #3

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

Similar topics

0
3734
by: Frank Collins | last post by:
Can anyone point me to some good examples on the web of using values from dynamically created checkboxes on forms in ASP, particularly relating to INSERTING those values into a SQL or Access database? Basically, I have a form on which I have a series of statements, with 3 checkboxes for each statement - YES, NO, MAYBE. This series of statements is being dynamically populated from a query of a table in Access, called "tblQuestions". In...
8
2836
by: Ralph Freshour | last post by:
I have multiple checkbox's created with an array name because I have many on the same web page - their names are like: frm_chk_delete frm_chk_delete frm_chk_delete frm_chk_delete etc. Here is my code line that creates each checkbox (the php variable get
7
2293
by: Bill Carson | last post by:
If anyone can help: I just created a data base in MS ACCESS, which is very basic. Its a list of users eg. names addresses etc. However on this list is 6 columns with checkboxes, the boxes representin if an individual user posseses a right or no. Check being yes, no check being no.
2
1461
by: JIM | last post by:
Hello, I would like to solve the following problem : I've a web site with ex. 5 checkboxes Each checkbox contains the name of a certain task ex. asp:Checkbox 1: Task 1 asp:Checkbox 2: Task 2 ...
3
1792
by: Jaime Stuardo | last post by:
Hi all... I'm trying to use a custom validator for a group of checkboxes in order to validate that at least 1 checkbox is checked before submitting the form. I placed 2 checkbox controls in the form and a CustomValidator. When I saw CustomValidator properties, the checkboxes aren't listed in ControlToValidate properties. Only textboxes are listed. Also, I set the ValidationGroup for the checkboxes to a name such as grpTipoEnvio and...
1
2075
by: RLN | last post by:
Hello. Re: Access 2003 I have a survey application that has 10 independent checkboxes on a form (chkLawnCare, chkCarpetCare, chk DrivewayMaint, etc.) One, or any combination can be checked before the form is submitted for processing. I need to do certain processes if checkboxA is checked, then other processes if ChkBoxB is clicked, and yet a third set of processes if
1
2572
by: RLN | last post by:
Re: Access 2003 I found a method here in the newsgroup that works for clearing checkboxes, but don't understand a particular line of code and how it works. Here is the code: 1. Dim ctrl As Control 2. For Each ctrl In Me.Controls 3. 'uncheck all of the checkboxes...
9
2914
by: martin DH | last post by:
I've seen similar posts to what I am looking for but have not been able to successfully use what I have read. I have a form with 4 checkboxes: CkQ1 CkJan CkFeb CkMar I would like to be able to select CkQ1, and in doing so, Access would select the other three checkboxes (sort of an "all of the above" option). These checkboxes are not in an option group because multiple boxes could be selected (eg a user might only select CkJan and CkFeb). ...
13
2553
beacon
by: beacon | last post by:
Hi everybody, I have a quality assurance database that has a form with a bunch of checkboxes on it that serve as reasons for why a product didn't pass inspection. It's a given that the users will be able to select individual checkboxes to indicate the reasons. What I would like to find out how to do is to put a checkbox or radio button on the form that will select all the checkboxes if it's selected. When I added a checkbox to...
13
19379
by: curious80237 | last post by:
In Access 2003: A table with four yes/no fields is part of a query used as data source for a report. The yes/no fields show in the datasheet and the report as checkboxes; the default value of the field is "no". The report pulls in a subreport. I want the subreport to be visible ONLY if any of the yes/no fields contain a yes (showing as a check in the checkbox). I tried an if then statement like this: If Field1 ="no" AND Field2 = "no" AND...
0
8483
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
8401
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
8926
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
8603
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,...
0
7444
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6236
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
4227
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
4416
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2818
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.