I have created a table driven email notification system which sends emails using outlook to employees depending on if a boolean field (blnEmail) in the email notification table is set to TRUE. I'm wanting to create a tabbed panel with a control that displays all records in the email notification table so that managers can check/uncheck the boolean field (blnEmail) depending on whether an employee should receive email notifications. I'm not sure what approach to take. I'm not very familiar with combo boxes, list boxes or subforms. Any suggestions would be appreciated.
2  1970  MMcCarthy 14,534
Recognized Expert Moderator MVP
If you want the user to be able to edit checkboxes then you will need to use a subform to display the records. I would suggest that you set the subform to open as a datasheet. This should make everything relatively easy.
jimatqsi 1,277
Recognized Expert Top Contributor
I have to assume that you want to add a tab to a pre-existing form. Otherwise I don't see any reason for a tabbed panel. You may be over complicating the task, but let's assume for a moment that your design approach and my assumption are both correct.
Start out by making a new form. The data for the form should come from your email notification table. All you need is a single checkbox on the form, bound to the boolean flag blnEmail, and the Employee ID number.
Then, go back to your original Employee maintenance form and add a Tab for "Email Notification." Drag your new form onto that tab. That will make your new (email notification) form a subform of the main (employee maintenance) form.
In the properties of the subform object you will need to put the Employee identifier from the main form in the Master property and the Employee identifier from the Email Notification table in the Child property. That way, when you choose Employee X on the main form, the subform contains the matching data from the Email Notifications table.
Hope that helps,
Jim
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Richard Coutts |
last post by:
I have a query created by the "Find Unmatched" query that lists items
in a table that were not selected by another query. The Query does
what it needs to do, but I can't edit any of the resulting fields the
way I can with other Queries. E.g., the "Description" field is a memo
field, but when I try to click on the text and edit it, I get the
fimiliar "bonk" sound, telling me I can't edit this.
Here's the SQL:
SELECT...
|
by: Rob |
last post by:
I doubt this is the best way to do it, but what I came up
with was to hide the XML in an HTML Comment then edit the
file deleting the HTML stuff and keep the XML results. If
anyone has a better solution, I would be interested.
Thank you.
Private Sub Page_Load(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles MyBase.Load
Dim cmd As System.Data.SqlClient.SqlCommand
cmd = New System.Data.SqlClient.SqlCommand
|
by: Jerry M. Gartner |
last post by:
Greetings:
As evident from a previous post, I am a php noob. I would like to
display MySQL query results in an html table with one of the row values as a
category and the rest of the data displayed under the relevant category.
I can get as far as displaying the data in a nice readable format but I
don't know how to have the records placed under their corresponding
category. This is my code thus far (sans the html output):
|
by: Kelii |
last post by:
I've been trying to get this piece to work for a few hours, but have
given up. I hope someone out there can help, I think the issue is
relatively straightforward, but being a novice, I'm stumped. Below you
will find the code I've written and the error that results. I'm hoping
that someone can give me some direction as to what syntax or parameter
is missing from the code that is expected by VBA.
Overview:
I'm trying to copy calculated...
|
by: Rotor |
last post by:
Hello again,
Problem: I created a query to pull a set of records by workorder number. It works like a champ. However, I need the user to update/edit the records if need be. I am displaying the query results in a form. However, when I try to change an entry in any of the fields, I get a "ding" and nothing changes. The records are there for display (it seems) and nothing can be done to edit them. Everything I've read tells me it should...
| | |
by: veaux |
last post by:
Might not have explained this correctly in subject, but query results
look like below:
Name ID Phone
Bill 001 123
Bill 001 234
Bill 001 456
Sam 002 999
Mary 003 888
|
by: Arli |
last post by:
I have the following linked tables:
tblMainPL is my main table that I need to pull the information in from. It has the following fields:
Autonumber1 -PK set as autonumber
Date - short date format-example: (10/22/08)
Load Number -Number-Single (should not be higher than 35-40 per day)
WorkOrder -Text- 50 (string of letters and numbers of varying length)-example-KR53103 2625000-48
Badge -text- (employee badge number)-example-c12345
|
by: OzNet |
last post by:
Hi
I am using Access 2007
I have a form called frmProjects and a tabbed panel on it.
The first tab is Project Details, the Second is Lump Sum Estimate and the third is Percentage Estimate
My problem is on the Percentage estimates panel which has a couple of subforms with requery and refresh functions to update changes. After these occur the whole form reverts to the first record.
|
by: DigitalWallfare |
last post by:
Hi all,
This is my first post here, but i've lurked for a while.
I'm working on a website but have come across a major stumbling block in the code:
I've managed to structure the search query but have 2 problems:
I dont know how to code the results into the table, and make the table repeat itself 5 times per page (and recognise it needs a new page)
|
by: CoreyReynolds |
last post by:
Hey all,
This may be the dumbest thing I've ever seen. I'm creating a queryDef in VBA for access. Here's a sample of the query it creates:
SELECT tblEquipment.equipmentID, tblSample.sampleDate, tblSampleResults.Chromium, IIf(=True,'X',(IIf(=True,'U',' '))) AS Critical
FROM (((tblEquipment
INNER JOIN tblCompartment ON tblEquipment. = tblCompartment.)
INNER JOIN tblSample ON tblCompartment. = tblSample.)
INNER JOIN...
|
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...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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...
|
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...
|
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();...
| | |
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...
|
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
| |
