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.
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.
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:
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.
...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?
I have a query which is my list of orders. Now I want to create other type of orders. New types don't use the code in red (tbl Offset and tblRodzajZlecenia). Is it possible to modify the query, in order to keep new types too?
New types of orders are in the same tables. But if I don't fill fields in tblOffset then query can't show new type of oder - that's the problem.
Code: SELECT z.ID_Zlecenia AS ID, tblRodzajPracy.RodzajPracy AS [Rodzaj pracy], tblRodzajZlecenia.RodzajZlecenia AS [Rodzaj zlecenia], z.NazwaZlecenia AS [Nazwa Zlecenia], k.NazwaSkrocona AS Klient, z.DataPrzyjecia AS [Data Przyjęcia], z.TerminOdbioru AS Termin, tblStatus.Status, tblStatus.lp FROM (tblKlienci AS k INNER JOIN ((tblStatus INNER JOIN tblZlecenia AS z ON tblStatus.Id_Status = z.Status)
I have a database where I have 3 tables. first is client data, second orders data and third the products data. What I would like, is to have a button on my form that after selecting from a combobox a product, it wil enter it in the tabel orders in the next available free record (row). I created a button and the combobox in the client form. The Products table has also the price per unit in it. It should take the whole row of data and put it in the Orders table.
Is there a way to do this? I guess it needs to be done with vba, but not sure.
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!
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.
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:
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?
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.
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?
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?
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!
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'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?
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?
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 ?
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.
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.
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:
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?
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.
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?
I am new to access and have a form set for processing orders. How do I process multiple orders i.e a customer orders an onion and a pepper. Currently I have to create 2 orders and would like 1 order with 2 items. I am sure this is very simple. Hope someone can help
