Forms :: Group Membership - Select Which People Belong To Specific Groups

Mar 11, 2013

I need to create a simple database where I have a list of people, a list of groups and all I want to do is select which people belong to specific groups.

All I need is to create a form where I have a list of my people and a tick box next to the groups to show who belongs to which group.

View Replies


ADVERTISEMENT

Forms :: Creating Group Membership Database

Feb 10, 2014

I am having problems developing a membership database - I have three main tables.

1. A table of 600 members of an organisation

2. A table of the subgroups these members may join, about 80 in total.

3. A table of the members of each group.

The members do not have a unique ID - complicated reason for this so I use a system assigned ID. Group ID does have a unique Id but I chose to use a system assigned ID.

Table 3 records effectively consists of just two fields, memberID and groupID. When I create a form and subform to enter these values all is well. But I cannot expect users to know these values, so I have been trying to create a subform that creates/lists/removes members from groups, using a Group main form with a member tabular subform with a surname search through a combobox. Groups have between 5 and 20 members.

e.g enter 'smit' in the combobox on the subform and a list of smiths is displayed together with the full name, from which the user selects the correct entry. At this point the record showing for instance, Paul Smith belongs to Group 17 is written to table 3. All sorts of issues arise, too many to document.

View 13 Replies View Related

Forms :: Display Number Of People In Group For A Certain Flight In Subform

Apr 19, 2015

I have an access form that displays some data about customers and their booking for flight. so lets say if there is a group of five people that made a booking for a certain flight, i have to assign ticket numbers to them and store it in some table.

Now i can display the number of people in a group for a certain flight in a subform, i want to have another textbox in front of their names so i can type in the ticket numbers. So i went to design view and added another textbox, but the problem is if the subform in displaying 5 rows (for 5 customers) when i type in a ticket number for one customer, all the following rows gets and displays the same ticket number. How can i type something and let it not be repeated infollowing rows.

View 1 Replies View Related

How To Change Group Membership Of User

Jun 10, 2012

I have to change a group membership of one user in an multi user access database. As I see its no possibility to change it in the backend (in X.ldb file) nor in frontend.

View 2 Replies View Related

Ideas?? 1 Refernce Number For A Group Of People.

Feb 15, 2006

Hi,

I've been using excel to keep record uptodate, but i've got more than 300 people to keep track of, so using excel can limit my db.

i'm new to access, wondering if I can get you advice:

Senario:
A community temple, which i'm a member of, spend alot of time loggin who is donating and how much, with pen and paper - then update the excel spreadsheet i've done for them, don't ask me why they do it, its sort of a tradition. Evenone pays about 5 per family, 1 pound for each person.

I was thinking if each familly had a reference number, everytime they donate, they'd give there reference number and the database automatically updates with new records.

So if Mr simpson , ref 69, pays 6, the database adds 6 new records; Granpa, Homer, Marge, Bart, Lisa and Maggie.

how difficult is this to do?
whats best way to design the tables?

Any help is much appreciated.

View 2 Replies View Related

Queries :: How To Group People Titles By Gender

Nov 17, 2013

I have a database with two tables. One for customers, one for the books that they buy.

I have a field for people's titles (Mr, Mrs, Miss, Ms) and I'd like to make a graph in Excell to show the relationship between gender and amount spent on books.

I'd like to just have two fields, male and female to put into Excell so the graph makes more sense than all four titles and then an explanation that Mrs, Miss and Ms must be added together to compare the total spent with the males.

How can I do this?

View 1 Replies View Related

Printing Letters To Specific People Through Access

Feb 23, 2005

Dear All:

I have created a from containing names and address. On This form I have a checkbox called "MailLetter" and a command button called "Sendletter".

I place a check in the box corresponding to specific people, then using a command button a letter is printed to ONLY THOSE WHO ARE CHECKED.

The letter is a Word document that resides on the desktop.

Here is the code behind a command button to print. Not sure if it is correct:


Private Sub Command2600_Click()
Dim WordObj
Set WordObj = CreateObject("Word.Application")
WordObj.Visible = True
WordObj.documents.Open "C:Documents and SettingsUserDesktopLetter.doc"
End Sub

I assume this can be done through some sort of mail merge?

Thanking in advance.

Regards,

Dion

View 3 Replies View Related

Reports :: Sum Group Items By Specific Item And Hide Details Of Group Summing

May 29, 2015

Despite Google I can't seem to figure this out.

I have some data in a format similar to:

Name / Style / description / speed / distance
john / driver / careful / 80 / 5500
mary / driver / careful / 70 / 7000
pat / racer / reckless / 100 / 6000
anne / driver / careful / 75 / 1000
peter / racer / reckless / 110 / 6500
don / snail / slow / 60 / 6000

I want my report to total by style, without details and to look like:

driver careful 13500
racer reckless 12500
snail slow 6000

How do you get a report to sum the group items by a specific item and to hide the details of that group summing?

View 2 Replies View Related

Select Specific Records In Forms- Help!

Nov 3, 2005

Hello,

I'm sure this has a simple solution, but iv searched this forum and every solution that i get is filled with code that goes over my head! Well here goes...

I have a main form called expense... which contains a tab control. the tabcontrol in turn has three pages containing a subform each. (lets call them sbfrm1 sbfrm2 and sbrm3.)
All three subforms are based on three different queries (say Qry1 Qry2 and Qry3) but the three queries are based on the same table. this table contains all the expenses incurred over the months across three categories (hence three queries). the subforms are to display these expenses according to categories.. i.e. sbfrm1 displays records pertaining to Category1, sbfrm2 for category2 etc.(the queries ensure that!)

when the main form opens, the subforms display all the records in the table according to category...but not according to the month in which the expenditure was incurred.

I now want to add a feature that enables the user to choose records pertaining to a given month at the click of a button.

for eg. if there is an option group named month, (with toggle buttons as the month names), then if the user selects the month Aug, then immediately the subform1 displays records under category1 for the month Aug? However I want to include an "ALL" option as well whereby all the records are displayed for all months (the category criteria must be maintained at any cost!!!!
Is there a solution that will not use too much code!

Thanks in advance.

View 5 Replies View Related

Forms :: Option Group To Select Subforms To Be Displayed - Popup Message

Aug 23, 2014

I have a form with an option group to select subforms to be displayed .To save space on the main form I have added a subform (frmSubService) to the option group to display some of the data that was originally on the main form. The subforms data source is the same as that of the main form but only displays five fields.

After editing data in the subform frmSubService, if I then click on a field on the main form no problem, however if I click on an option button to view another subform I get a messagebox pop up with the following message;

The data has been changed. Another user edited this record and saved the changes before you attempted to save your changes. Re-Edit the record.

If I click OK,and without re-editing the record, I can open another subform.

I have checked and the data changes made on frmSubService, in both cases, has been saved.

How do I prevent the pop-up message?

View 3 Replies View Related

Forms :: Automate A Membership Status Flag - Invalid Use Of Null

May 20, 2014

I am trying to automate a membership status flag based on comparing today's date and a recorded expiry date. The expiry date control is on a sub-form. I have the following code in the OnLoad event of the master form:

Dim DateGap As Integer
While Me.CurrentRecord < Me.Recordset.RecordCount
If Not Me.NewRecord Then
DateGap = DateDiff("y", Date, Forms!PersonalMasterF!MemberSubF.Form.MemberExpire )
Else
DoCmd.GoToRecord , , acNext

[Code] .....

With debug pointing to the DateGap = statement I get the error 'Invalid use of Null'. As you can see, I've tried to trap any new records it might run into to avoid nulls in MemberExpire, and there are no null values in the MemberExpire field of the underlying table. I've also tried defining DateGap as Variant, which does not work at all.

View 7 Replies View Related

This Question Should Belong Here

Apr 26, 2005

Hello,

Access has a Masked Edit control for input like SSN, phone numbers, etc.
I'd like to be able to use this functionality in a VB application. Which dll does this control belongs to? How can a developer using VB .NET instantiate this control and add it to a project?

Thanks in advance,

Rick

View 1 Replies View Related

Stop People Printing Forms

Mar 22, 2006

Hi all,
I have a form that i use for data input, I have limited all of the menu's how ever the print option is still available. This leads to muppet users printing out the form and using it.
There is a print button on the form that prints a report out that lays out the form into a useable item.

So the question is... How can I stop people being able to print out the form?

Thanks in advance

Steve

View 14 Replies View Related

Forms :: Adding People To A Record

May 3, 2013

I am building a database for running a shoot. I want to be able to add Firers, Beaters and Picker Ups to each day. All of those people are held in a [Contacts] form and have a checkbox to designate them as Shooters, Beaters or Picker Ups or a combination of them

I have a form where I can create the shoot date and timings etc. Now I want to add people to the form.

My idea is to have a seperate form with a list of all the Shoot Dates, on the same form will be three more lists showing Shoot Date and ID, List of all Guns, List of All Beaters, List of all Picker Ups in the Database.

You would then select the shoot date from the first list which would highlight, then go each of the other three lists and select a checkbox next to each person that you wanted to attend that day.

I know what I want to do but dont know how to do it!

I have attached a picture....

View 5 Replies View Related

Using 'Group By' To Find A Specific Record...

Oct 10, 2005

Hi,
I have a table with various customer items, a current price and the date the price changed.

EXAMPLE DATA

CustID/ItemCode/DateChanged/Value
AAA 21 01/01/2004 3.00
AAA 21 01/06/2005 5.00
AAA 21 01/03/2005 4.00
AAA 22 01/01/2005 6.00
AAA 22 01/06/2005 7.00
BBB 25 01/01/2005 8.00
BBB 25 03/07/2005 9.00
BBB 26 01/06/2005 1.00
BBB 26 01/09/2005 2.00

Note: Dates are in "dd/mm/yyyy" format. Also, not all data is in order in the table. Its not how I would have designed it but thats what I need to work with!

I would like to run a query that groups by custID & itemcode and also the most recent date for any price change. I would then like the query to display the relating price for the record it pulls out. (EG for custID 'AAA' and item 21, it would display the price of 5 as that is the value for the most recent price as of 01/06/2005)
I then want to link the custID & itemcode to another table that has sales in, to check that we are using the most recent price.

Is there a way I can do this via a query or do I need to put some code together?

Cheers
Red [CODE]

View 2 Replies View Related

Forms :: Add People's Names Into Database Using Two Fields?

Jul 24, 2014

How important is it to add people's names into a database using two fields ?..ie: [FirstName] and [LastName]. Would it be ok to put their full name into one field if you also had a unique Identity Number for each person in the same table ?

View 14 Replies View Related

Select All Columns Of Each Group

Jan 17, 2007

SELECT contractid, min(RTRbalance) AS minRB
FROM ACHACT
GROUP BY contractid;

will have two culumn

What if I want to select all columns of ACHACT associated with minEB in each contractid group?
THX.
Jeff

View 1 Replies View Related

Group And Select First Records

Feb 9, 2015

how I would write a code that will recognize information by same “ID” and then only take the first 6 years of that information. Each row has an ID and a corresponding year with other information associated with it. The data looks similar to this:

ID Year Avg HR
JohnSmith 1988 .789 78
JohnSmith 1989 .854 85
JohnSmith 1990 .456 85

TomJones 1978 .465 56
TomJones 1979 .165 85

View 9 Replies View Related

Forms :: Sortable Lists In A Form - Show People Who Have Product

Jan 14, 2014

I have a form I need to sort based on criteria in a persons record. We sell certain products. And we need the ability to only show the people who have a product. For example, we sell EPLI and WCF. I want to be able to pick a drop down list and it only shows and goes through the EPLI people. How do you do this?

I attached my database can you take a look on how to do this?

View 3 Replies View Related

Select Group By Having In (SELECT), HELP !

Jun 28, 2006

This is driving me nuts guys...

I need a query to show only those Company's that have a relationship to ALL Departments. These are the tables:

tblCompanies
CompanyID

tblUserDepts
UserDeptID

tjxCompanySubscriptions
CompanyID
UserDeptID

tjxCompanySubscriptions is a junction table that defines which Department has a subscription to a Company.

I need to know which Company's are subscribed by ALL Departments.

Probably simple, but not for me!

Scott

View 2 Replies View Related

Query Using Buttons To Select A Group

Jul 14, 2005

I have a query which I want to based on a group selected on a form using a selector button. EG if a person is a member of the accounts team that button would be selected. I could then just run the query to get members of the accounts team.

I am using the following SQL, but find when I run it "every" record is selected....

View 1 Replies View Related

Joining Tables, Group By Name, Select On...

Nov 18, 2006

Hi I have 2 tables(tblA and tblB) and I want a query result(tblC) where ‘group by’ only one record per individual, with the total added together and the type starts with ‘01’. Below(tblA and tblB) are examples of the two table. TblC is the query result that I want. tblAName---Type---Amount---StatusJoe---01FAE---$10---NewJoe---01FBE---$10---NewLee---01FBE---$10---OldBob---30FBE---$30---NewtblBName---Type----Amount---StatusJoe----01FBE---$5------NewLee----01NAE---$20-------OldLee----30FBE--$30------NewtblCName---Type---AmountJoe---01FAE---$25---NewLee---01FBE--$30---OldI have tried linking/joining, adding SUM function, First, Group By, etc. but all the results came out to be all different. Also, am I support to add a ‘join’ of tblA to tblB on BOTH the NAME and TYPE? I am so confused! Please help.Thank you very much. Joe

View 1 Replies View Related

Is There A Way To Use Keyboard To Select From An Option Group?

Apr 17, 2005

I have a user who can't operate a mouse and I want to make it possible for him to select from an option group using only the keyboard.This is possible if a default button is stipulated, but can it be done when there is no default?

There is no event associated with the keyboard in an option group, only with the controls within it. I tried using the Got Focus event on an option Button, but entering the control doesn't cause the options to receive the focus, seemingly.

Any ideas, (they don't have to be fully formed) would be gratefully accepted.

View 7 Replies View Related

Modules & VBA :: SQL SELECT SUM GROUP Not Working

Nov 8, 2014

I have a select clause, it executes fine, BUT the totamt is not calculated. The field is Amount. The code is not working.

strSQL = "SELECT Account, Dept, " & "Sum([Amount])" & " As [totamt] FROM TB201410 GROUP BY Account, Dept;"

View 5 Replies View Related

Forms :: Entering Values For Multiple People On One Form Based On Month

Jan 31, 2015

I need to enter workload counts for 10 people, and it is done on a monthly basis. So I have a table of Months (Jan-Dec), a table of names, and a joined table with the months, names and a field for the workload counts.

I would like to make a form where I could select the month and all the names show up so I could go and enter the counts for everyone at the same time. I've attached a diagram to show what it would look like

View 3 Replies View Related

Select Query Statement (group By) Function

May 24, 2007

I have several records to search for. I need to select just 1 record for each Tkt_no group using Tkt_id (max no).
Example, I only want to select

Tkt_NoTkt_IDTicket_ProblemTicket_StatusTicket_Finish_Time
114problem 1Done
210problem 2Done00/01/1900 20:00
32problem 3Ongoing00/01/1900 20:00
43problem 4Done00/01/1900 20:00
711problem 5Done21/05/2007 9:15
913problem 6Done22/05/2007 0:00

from below data

Tkt_NoTkt_IDTicket_ProblemTicket_StatusTicket_Finish_Time
14problem 1Ongoing00/01/1900 20:00
114problem 1Done
25problem 2Ongoing00/01/1900 14:30
26problem 2Ongoing00/01/1900 11:30
27problem 2Ongoing00/01/1900 10:15
28problem 2Ongoing00/01/1900 15:00
29problem 2Ongoing00/01/1900 8:00
210problem 2Done00/01/1900 20:00
31problem 3Ongoing00/01/1900 20:00
32problem 3Ongoing00/01/1900 20:00
43problem 4Done00/01/1900 20:00
711problem 5Done21/05/2007 9:15
913problem 6Done22/05/2007 0:00

Any ideas?
Appreciate the feedbacks.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved