Report People With Same Flight Pattern
Sep 26, 2004
I have a database which has a contact table and a flight table joined in a one to many relationship. Each contact may more than 1 flight and I want to be able to report on people that have exactly the same flight pattern. For example if 2 contacts have flight records FlightID 1, 4, & 10 I want them to be grouped together.
I have tried a number of things including a cross tab query to end up with the contactID and then a string of their flight IDs but as there are over 200 possible flights, the string appears as 1,,,,,,,,3,,,,,,,,,,,,,5,,,,,,,,,,,,6,,,,, etc and when I try to group on this it doesn't seem to work. This seems a very messy way of doing it and I'm sure there must be a much easier way!
Help!
View Replies
ADVERTISEMENT
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
Mar 5, 2015
I would like to put 3 more people on as a CC but don't send the report
Code:
Dim strTo As String
Dim strSubject As String
Dim strMessageText As String
Me.Dirty = False
strTo = Me.E_Mail_address
[Code] .....
View 4 Replies
View Related
Jul 15, 2013
At present I have a tblData, a tblPeople, a long union query and a report that displays its results. On a form I select a person from tblPeople (another field on that table contains their email address), run the query and report in that person's respect and email the results to them.
What I want to do is add a button which runs some VBA code which cycles through tblPeople, runs the query for each person, works out if the query has returned any records from tblData for that person, and if so - sends them the report.
I am using Access 2010
View 4 Replies
View Related
May 7, 2015
I am new to MS Access. I am using Office 2013.
I've created a database at my work place, in which I wanted to add my requisitions. What I wanted is to have an auto increment field for my reference number field, that field is like 001/Jan/15. In which first 3 digits refer to the requisition number, then month and then year.
How can I create an input mask with auto increment to solve out this problem.
View 6 Replies
View Related
Jan 24, 2006
Hi all!
Got yet another question.
I have a text box field (txtLoanSN) for users to input serial numbers, but they can be of different formats depending on the type of service.
Examples are:
Type A - 020/2005, 001/2006
Type B - C2001/2006, C2006/2006
Type C - B1001/2005, B1021/2006
I would like to perform a series of actions based on the type of serial no. e.g. disabling another textbox (txtPNo) if txtLoanSN is like Type B or Type C.
How should the syntax for the If Statements be?
Would appreciate any help I can get!
Thanks!
View 9 Replies
View Related
Apr 14, 2008
hi
i have a flag in the back end of my database, which once ticked by me, should chuck them out of their front ends
it runs off the timer of the opening form and looks like thisL
Sub EveryoneGetOut()
Const MINUTESLEFT As Integer = 10
If booQuitFlagTicked Then
If Now() > dtQuitTime Then
AuditTrack "kicked someone out", "main form timer"
Application.Quit
Else
If (dtQuitTime - Now()) * 24 * 60 < MINUTESLEFT Then
'MsgBox "database to close in next " & 1 + Int((dtQuitTime - Now()) * 24 * 60) & " minutes for repairs/upgrades"
UpdateStatus "database to close in next " & Int((dtQuitTime - Now()) * 24 * 60) & " minutes for repairs/upgrades"
End If
End If
Else
'Debug.Print "no kicking done " & Now()
End If
End Sub
two things are going wrong:-
1) i have one user that it keeps trying to kick out (i see it keep loggin it in the audit tracker) but he never gets kicked out
2) i have another user that doesn't even get a mention as trying to kick out, but they're in it. IT told me so from looking at the network locks (and my audit trail knows they logged in earlier)
i'm a bit puzzled, how can the application.quit line run without making someone quit?
and as for the other user that it doesn't even try to kick out, i'm really really puzzled!
:confused::confused::confused:
and ideas welcome
View 4 Replies
View Related
Oct 11, 2005
I have a form with a textbox and a button. When the user enters in a number range, I need records to show up for only dates that are in-between and/or equal to the numbers typed in the textbox.
For example when the user types in 4-9, and pushes the button, a display of records will be displayed for only 4, 5, 6, 7, 8, 9 (if there are such records). The numbers are contained in a NUMBER field of a larger table.
This seems to be a tough question, and I've done days of research on it and can't find an answer.
View 1 Replies
View Related
Aug 15, 2005
I need some help here. I have a table which stores DateOf Birth . I used DateDiff to get the age of persons but what I need is a number of persons within certain age range (0-15, 15-30, 30-50, 50>). How should I get that? :confused:
View 5 Replies
View Related
May 7, 2006
Hi all
I have made a quick db with one table and its needs to be used to enter records and updates to records from three people at the same time. These people are going to be sitting at three networked terminals and entering data to the same db at the same time. I know about splitting my db but will this allow for these people to add and change data at the same time? Should I save the backend to one computer and have copies of the data entry form on all the computers looking at the backend? Or should I have multiple forms in the same location and then each computer open the differnt forms located on one of the networked puters?
View 5 Replies
View Related
Apr 11, 2007
Hi,
I was wondering if two can people can enter into the same database at the same time? What pitfalls do I need to look out for if it is possible?
Thanks
Eddie.
View 6 Replies
View Related
Mar 14, 2007
Hello,
I have done some reading in the forums and tutorial site and thanks to the help of many members here I am learning lots thanks!
My question of the day (Hour :) ) is I have a
ProjectTbl
ProjectID *Defined by user*
Project.StartDate
Project.EndDate
PersonTbl
PersonID *Autonumber*
Person.LastName
Person.FirstName
I have built a form which I can add multiple people to one project but when I look in the table only the person who the relationship was linked to gets the subtable.
Then I researched a Many-Many relationship and this solved that issue, now I can put multiple people on a project and multiple projects on people.
PersonProjectTBL
PersonProjectID *Autonumber*
PersonID
ProjectID
However how do I now make a form where I select a project and associate more then one person with this project?
I think I need to somehow increment the PersonProjectTBL and add to it as I go.
The layout I would like to have is:
Combobox 1: Selects the Project (After Select use a (queary ??)) to load in
Combobox 2 and 3 with people.
Combobox 2: Select a person to load into project.
Combobox 3: Select a second person to load into project.
I dont expect a full answer a link or multiple links is very appriciated, even a search topic of what to look for.
Thank you for your time,
Derek L
View 2 Replies
View Related
May 7, 2005
Dear All,
Can anyone help me with a problem I have with this database.
I want to be able to assign members (Contacts) of companies (Company) to training courses.
I just do not know how to do it. Contacts will need to be able to be assigned to many courses and many different contacts can go on the same course. I think it can be treated as picking inventory items from a list to make up an order, but I cannot get my head around it.
What I want to be able to do is to go through the courses button, double click on the course ID field to get to the course information screen. (I have already set this up) I want to be able to choose a course and select a member of the company to go on the course by using a yes/no box.
I have set up a course attendance table but do I need a query or something to link contacts of the company to the courses table. Is there a problem with my relationships?
zip file attached.
As someone new to access, this is hopefully easy, I just don’t have the know how. Please any help would be excellent and id be very grateful.
Thanks. Please help.
View 1 Replies
View Related
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
Jul 31, 2006
My search has been unsuccessful due to the search function refusing to play nicely with me and the fact that it's mixing up the problems with using special characters with field names, which isn't what I want.
My problem is I have comboboxes that looks up people's name and has a NotInLIst event to allow addition of new person. It uses split function and concentating query to keep data normalized while displaying the full name.
Access trips over, very hard, whenever there is a name that uses special character, which for obvious reasons, causes confusion. Example:
Mike O'Leary
Thomas O'Calloway
Janet Smith-Johnson
Mary-Ann Johnson
Can anyone point me to a snippet I could use to trap for those names and help Access deal with it accordingly?
Thanks in advance.
View 2 Replies
View Related
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
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
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
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
May 20, 2013
i have created a parameter query which will find a students best and worst time for each exercise they have done. so you enter the student ID when you run the query and it works fine but i have a problem i need to query to find two students in particular and then i have to create a report from this query on the two students identified and this is where i come up stuck. i have tried typing in both student id's into the criteria but this doesnt work no matter if i put and in it or not and im not sure how to get the job done.
View 7 Replies
View Related
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
Feb 14, 2013
I have created a database of club members in Access 2010. Each day I need to generate a report of who comes to the club. Up to this point I have been using an Excel spread sheet of members that I copy and paste to new daily spreadsheets each day. how to do this.
View 5 Replies
View Related
May 30, 2014
A user reported that when exporting a list of people from a query to excel, certain people/records are not contained in the export. I took a look (old db mdb v2002-2003 access) and what I found was quite odd.
First, I opened the resultant xls and the first 25 rows or so are blank - which I thought was weird - were these the missing records?
Next I noticed that I forgot to close the xls when rerunning/testing the export using this:
Code:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryemailods", Me!Premiername, 0
When I was watching the open spreadsheet, I noticed that it was repopulated with records (I actually expected to get a 'file in use' error, but access carried on) replacing the data.
But lo' and behold! All the records were exported, including the 25 or so missing records at the top where the blank rows previously were located!?!?
I tried a few things... compact and repair on the front and back end of the mdb. Save at newer version of access (2007/accdb), even working locally in case there was some network lag or other issue... Same story... when running the export with the target file closed, the first ~25 records are dropped - but if the xls is already open it runs fine.
Code:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "qryemailods", Me!Premiername, 0
...and that does in fact produce the proper listing without missing records (with target file closed), but the "12" export causes the following message to pop up when opening the file:
"The file you are trying to open [filename] is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source etc etc etc.. Do you want to open the file now?"
If I hit yes, the file opens and looks good - but why the error message?
View 1 Replies
View Related
Jul 1, 2005
I have made a couple of posts about this and had no response as yet. Maybe i didn't explain it well.
I have a form that logs emails. The emails are either "to" or "from" a person. I want to have two queries that pick out either to or from. Now each person i know sends me several emails over time obviously but i am only concerned with their last email or MY last email to THEM because that determines if i should email them back or if i am waiting for them to contact me. At the moment i am having problems filtering out the last record for each person which determines whether i need to email them or they need to email me. I also use the record to log when the last mobile text was sent, phone call etc so it is not just emails. The following is what my formsfields look like
CommunicationID
Communication type
TO or From
Date
Day (automatically taken from the date)
Subject
I cannot for the life of me get the filter to work properly. Currently i am either getting more than one record for each person or the results are jumbled up. I really need a better understanding of how to use the totals thingy in the querys design view. I'd really appreciate some help on this. Thanks....Ross
:confused: :confused: :confused:
View 6 Replies
View Related
Jan 9, 2013
I have researched the 'party' data model but it is a bit too complex for what I'm seeking. For those familiar with it, I don't really need the intermediary relationship from-to tables.
I'm interested in ideas about setting up a data structure that will allow users to search contacts or select contacts in dropdowns regardless if the contact type is a person or an organization.
Obviously the fields needed for both are different and the biggest issue is the name field because the person contacts are
The way I am accomplishing it now is writing the company name, or "first name " & "last name" for a person, to kind of a bridge table when a new record is inserted into the person table or the organization table...kind of inefficient.
Is this a relationship thing or should I just write a function to create a temporary recordset when needed?
View 3 Replies
View Related
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
