Semi-urgent Help With Linking Tables/forms
Aug 2, 2006
Hi there - I have a database for a conference. I have an attendee's form where I enter their personal details. Then I have another form called Options Form (which I've set up as a command button to open the form) where I can enter the workshops/sessions they sign up for.
As attendees send us their completed options forms, I need to enter their choices into the options form.
TheProblem: If attendee 103 sends in his form, I enter his choices and close out of the options form. If attendee 67 sends his form, I do the same. BUT when I go back to these attendees and open their forms, those choices I had just entered have disappeared.
The Options Table (that I set up and designed the Options Form off) has the following fields:
AttendeeID
FirstName
LastName
Workshop 1
Workshop 2....etc
When I designed the form, I formatted the AttendeeID, FirstName and LastName field to use this same info from these fields in the Attendee Form (ie, =Forms!Attendees!AttendeeFirstName). However, when I tried to find out where these options 'went', I had a look on the Options Table and they are there, but there is nothing in the AttendeeID, FirstName or LastName field - these fields are blank.
Originally when I first started entering the options, it just seemed to Autonumber the choices I entered, so even though I may have entered them for Attendee 103, in the Options Table is showed in the Attendee column as 1, then if I entered info for Attendee 86, the Options Table showed it as 2 and so on, so whatever order I entered the information it put it in numerical order as opposed to the actual AttendeeID number.
What I need: I need to be able to enter any attendee's options (whether they are attendee 1, 26, 200, or 105 - ie not necessarily in numerical order) on their options form and for this info to be saved.
I hope this is not too confusing for anyone and someone is able to help. I would really appreciate it, or if you need further clarification, please just let me know.
(My guess is it has something to do with making sure my fields are formatted correctly, ie on the Options Form the AttendeeID field was set on Autonumber which is why it may have been putting the choices in numerical order instead of whatever the AttendeeID number is. I'm also wondering if I need to set up some kind of relationship between the Attendee Table and the Options Table - but I'm not sure what type of relationship it should be on. I've tried several options and none of them seem to work)
Many thanks
Kath Price
Auckland, NZ
View Replies
ADVERTISEMENT
Dec 9, 2005
hi to all,
I have a software which links itself to a fox pro database/tables. Now i want to link some of these free tables or database from fox pro to access. Whenever there is a slight change in the fox pro tables/databases they must reflect directly into access database. Is this possible and how?
thanks,
ashley
View 3 Replies
View Related
May 21, 2013
I've received a database that is a digitized population register from the 19th century. All adults have been entered into the database, but all children are missing.
Every person has a unique number that corresponds with the original source (this variable is called 'no', this is not the autonumber primary key thing). Instead of searching in the original source which numbers are still missing, I would like to add the missing numbers (with no additional information, because I still need to type that in).
For example, the table now looks like this:
no - name_last - name_first - occupation etc
1 Smith Henry baker
2 Smith Mary
5 Williams John butcher
6 and so on
So 3 and 4 are missing.
How can I add these missing numbers automatically?
View 3 Replies
View Related
Dec 20, 2004
Hi
Hopefully someone can help me here. been struggling with this for a while.
Here's the brief!!
I have a access 2000Db, In it are are 2 tables, Tbl_Main & Tbl_Customer. and two forms frm_main & frm_customers based on the tables.
I have created a form called Form_main On this i have created a button which opens the form, Frm_Customers.
I want to link each record in fom main with form customers, basically so when i click on the button in form main it opens the correct corresponding record in frm_customers
Unfortunately when i scroll through the frm_main and select the customers button the customers details dont follow with each record. it only shows last record. Each record in the main form should follow with record from Customers table
I have created a relationship 1 to 1 so the data would follow each record but no avail.
where am I going wrong - If i can avoid code then that be fantastic as it confuses me! :)
View 14 Replies
View Related
Nov 22, 2012
ive made a db to keep a record of my employees and then keep a record of the addresses they attend.each employee will tend to visit numerous addresses in any given day so ive made a table for employees and a separate table for the addresses they visit...i then made an 'employee form' that is generated from my 'employee table' (standard stuff like name, address etc, nothing fancy here) so it is more user friendly...
what i want to be able to do is push a button on the 'employee form' which will then prompt me to add an address that will only be linked to that specific employee.i guess in esssence im looking for a way to link a specific employee to a bunch of addresses, and be able to data entry it on a form..
View 2 Replies
View Related
May 27, 2013
I am a girl guide leader trying to make a faster way to keep track of my unit's completed badge and program work. I have made tables for every area I need (I started with one table but it was too large to change into a form).
In total I have:
- Basic Member table (main information like their name and how many years they have been in, whether they are still in the unit, etc)
- Program area tables
- Interest badge tables
What I want to do is be able to "add/edit" members from the main form, then go to all the sub forms for their program and badge work -- problem is, how to link them!
I am using Access 2007-2010.
View 2 Replies
View Related
Feb 13, 2006
Hi! This may be an incredibly simple query. We have access users and non-users at our organisation.
Although our database is in access, the non-users would like to use excel, so I am trying to set up a link between the two.
I have managed to set up the link between the main database table and an excel spreadsheet, but I also use a form to enter info on the main database.
When I set up the link, I add something to the main database table and it changes the excel document... but when I change a name or something on the form, it doesn't change it in excel.
Any ideas how I can link all of it would be very much appreciated!
With thanks, Hayley
View 1 Replies
View Related
Jul 22, 2005
Hiii All.......
I am new to MSACESS........and i am just trying a small project and having a problem .... when ever i use any table / query in the expression builder of a FORM element...i am getting this error mesg " Automation object table / query not found "..........Should we link the objects of same database in some way ?? R they not connected??...Why is it that form elements r not recognizing tables of same database???...i am trying on this in several ways......but not able to solve this.... :( ....plzzzzzzzz can anyone help me out with this??????
Thankz in Advance
daffodils
View 1 Replies
View Related
Oct 6, 2013
I want to have a navigation Form where the top tab will show the main Customer, and in the same tab also a sub table with chosen contact information.
With that top tab chosen, I want to chose left tab wich shall open (in this example) the phone number of that contact.
I provide a PDF with a few pictures of tables, relationships and how I want the forms to look.
View 5 Replies
View Related
Aug 26, 2014
problem is that i have 2 tables - Consolidated Orders, Customers.
Customers has 2 fields with a record inside one field with the clients name , but it also has an address in another field in the same table which i want to link to the name of the client because in my invoice i show the companies name and to the left of it i show their address.
i wish to link the two fields together so that when the name shows up, the address of the client will be to the left side .
View 2 Replies
View Related
May 11, 2007
Hey guys, I'm relatively new to Access and I need some help building a query. So I work with a website that handles credit card transactions, and we keep a log of activity ie. NameOnCard, Date, Status. About once a month or so, I do an audit to make sure that all the attempted transactions are successful. Sometimes the server needs to restart, or the users computer has a problem, etc. Typically, someone who's had a failed attempt will have a successful attempt minutes or seconds later, so the NameOnCard is exactly the same, but the Date and Status are different. Right now I've created a query that look for failed attempts and one that looks for successful attempts, but what i want is one that returns only people with failed attempts that don't also have a successful attempt. Everything I've thought should work hasn't. Filtering for unique values doesn't help, because each row is slightly different, and the NameOnCard isn't the primary key. I recently tried this as a column with this in the field value:Success: IIf([Online Gift Errors]![NameOnCard]=[Online Gift Successes]![NameOnCard],"Success","Failure")(NOTE:Online Gift Errors and Online Gift Successes are queries, not tables)But when I try to run the query it thinks [Online Gift Errors]![NameOnCard] is a parametric value and asks for an input. What can I do? Should I be trying something else entirely?
View 5 Replies
View Related
Aug 24, 2006
Hey all, I've been banging my head all day trying to find a method and have nothing. Perhaps someone could guide me towards the right path... Here's a generic simplification of what I have:
ID# - Friend
1 - Fred
1 - George
2 - Fred
3 - Bill
3 - Ray
3 - Scott
Here's what I'm hoping to end up with:
ID# - Friends
1 - Fred, George
2 - Fred
3 - Bill, Ray, Scott
or even this would get me there:
ID# - Friend1 - Friend2 - Friend3
1 - Fred - George
2 - Fred
3 - Bill - Ray - Scott
I'm dealing with thousands of id#'s and thousands of possible friend's names.
Any help out there? If I need to explain myself better, just ask and i'll write some more...
thanx for any help you can offer...
Jim
P.S. I'm only a lite-weight in programming. I've been trying with a thousand different query methods so far using temporary tables and anything else I could possibly imagine...
View 3 Replies
View Related
Nov 7, 2006
Hi, this dilemma really has me in a bind - say I have table1 and table2, when I enter data/update table1, I need to also enter the same data into table2. I know this sounds royally weird, but if there is a way to do this I would appreciate any and all help asap!
Thanks in advance.
View 3 Replies
View Related
Oct 31, 2004
I am trying to create a database which will act as a timesheet and management system.
I have several tables set up. some are:
01-Staff details containing Staff ID, Names, etc
11-Timesheets containing Timesheet ID, Staff ID, Timesheet Period ID
17-Timesheet Periods containing Timesheet Period IDs, Start Date and End Date.
13-Hours containing Hours ID, Timehseet ID, Project ID, Hours
etc.
I want to set up a Combo that lists Names from Table 01-Staff Details, and when the user selects their name, enters the Staff ID on a new row in the tabll 11-Timehseets.
I am able to create the Combo to list the names from 01-Staff Details, but am not able to get the selected name to jump into 11-Timesheets. The field is not available in the Control Source.
Could you please assist? I am not an Access expert, nor have I done any programming, so a step-by-step solution would be greatly appreciated!!
Many thanks in advance
Sunil
p.s. I would then like to ensure that users can't edit data in certain tables (eg. they shouldn't be able to create a new Staff ID/name, etc)
My next task will be to create a sub-form (which I am able to do) where the user can select a project from a combo-box and enter the hours worked on it. I would like the project and hours to be entered on a new row under the table 13-Hours
I look forward to your reply!
Many thanks
View 4 Replies
View Related
Jul 29, 2015
I currently have 3 tables within a database with student details of three different classes. I need to create a user form that has a dropdown box which I can select a student from one of these tables with a number of text boxes below which brings up all the students details, then once the student has been selected and the correct details are shown then I need to create a button which allows me to move that student from one table to another.
View 4 Replies
View Related
Dec 3, 2012
I have 2 identical database in terms of structure but it differs in data.
Basically I would like to import data from subDatabase to mainDatabase and ensuring that there are no duplicate records.
I have used the "link to datasource method" through importing the tables to have the "updating" function.
However, this method also means that the records in mainDatabase are also imported over to subDatabase which I do not want.
Is there a method to ensure that the records are shared/update one way only? (i.e. import from subDatabase to mainDatabase and not main to sub?)
View 1 Replies
View Related
Sep 26, 2012
Currently trying to build a database for customer management and order placement/tracking. Want to set a couple of rules so that if I for instance click yes of billing and shipping address the same that the database will automatically fill the shipping address with the data I inputted for the billing address in the same table.
The other issue I can see I'll run into is, I want to be able to select one of the company ID's (made up of a three letter abbreviation of the full company name) in the product ordering table and it will automatically fill in the rest of the customer data (phone, email, address etc) data into that form.
View 2 Replies
View Related
Apr 15, 2014
I am doing a project where we are collecting home owner data and information on all the dogs in the household. The data for homeowner has an autonumber primary key because no field is unique or has been consistently collected. I am struggling to link the data for the dogs to the owners because an autonumber primary key will not work since not all homes have dogs. I need to have this set up so that people who are not tech savvy can look up each homeowner (or dog) and get the dog (or home owner) information. And to make things even more fun we need up to 15 potential dogs per household each of whom will have 18 different pieces of data collected.
It looks a little like this (and you can see my not matching ID issue):
Homeowner table
ID First Name Last Name...........Total Dogs
1 Max Maximus 5
2 Min Minimus 0
3 Mus Musculus 1
Dogs 1-5 table
ID Date Dog 1 Name Dog 2 Name .......Dog 5 Name
1 (Max's) 4/11/14 Bobby Billy Betty
2 (Mus's) 4/11/14 Jojo
Min will have no dog records at all, just home information.how to link the dog's to the homeowners .
View 3 Replies
View Related
Mar 18, 2013
I have been asked to design a database to replace our old excel sheet to log one of our customers server builds. It a four noded system and i require a seperate log for each node serial models of parts etc, qa checks.
I intitial started by just using one table but forgot the limit was 255 rows, i need about 600 - 700. So my plan is now to transfer to indivial table for each node. Then, a general table named Main for all my other details.
Although this seems simple, i now have the annoying task of being able to link them all together and produce a single PDF file to send to our customer whilst only entering our system serial number once to produce this.
My basic understanding will be to create a System Serial Number field in each table a link it via relationships, but if i produce a report with everything i need would it input my details for all four nodes? If so how would i set this up?
I will be splitting the database once completed and then making a ACCDE file for my techs to use.
View 4 Replies
View Related
Sep 28, 2012
I recently imported an excel file into access. Let's say it contained data for both domestic and international customers. With different things needed from each type of customer, once in Access, it became needed and easier to create separate tables- one for international and one for domestic. However, each customer needs their own unique id - and I need a way to link or relate the tables in a manner that it will not allow duplicate customer numbers between the two tables.
View 7 Replies
View Related
May 23, 2013
I have two tables called Hardware and Desk. They both have two fields called ChangeID and Priority.
What I would like to do is set it so that if we change the Priority in a record existing/created in 'Hardware', the Priority of the related record in 'Desk', also changes.
How can I achieve this?
View 2 Replies
View Related
May 19, 2005
Question for someone..... I was looking at the "LinkTables" in Access..... I see that I can link one database to another..... When I do this I can add the table to my relationship window... I have not played with this too much.. But looks interesting. Now, all the info I might add to this linked table is stored in the other database??? If this linked table is also linked to other tables in the other DB can I use those in queries? Not much covered (that I can find) in the Access help files on this sort of thing.
Thanks
View 3 Replies
View Related
Jun 26, 2006
I am looking to lonk tables in a database.
I have one table a pc tables which has a list of pc's
the other table is a pc software table which has a list of software
i want to build a form to show the pc's and their software how do i do this
View 5 Replies
View Related
Jun 29, 2007
I have a table with job info like: job #, job name, job addy.
I would like my end query to look like this: job #, job name, job notes.
I want the query to list all jobs, job names, and job notes for a particular week(we have a weekly meeting on the status of our jobs), so if I were to query the jobs for 6/26, i would get: job #, job name, and job notes for that date as fields in my query.
I am not sure how to accomplish this. Should I make a seperate table that contains job notes? If so, how would I accomplish this and create a relationship between the job info table and the job notes table?
Thanks in advance!
View 4 Replies
View Related
May 16, 2005
:confused: How can I link a table to one specific item in another table in order to avoid repeating information? (ex: school name that would be narrowed down to its different departments)
View 3 Replies
View Related
Oct 4, 2005
Excuse me for sounding extremely dumb, but I have a question that is really bugging me. I have created a database using two tables. The two tables are called User and Assets. In both tables I have set the primary key to be the field Username. I have also linked these two fields.
I have created a form that is my interface for the database and can add and delete from the table (User). I now want to insert a sub form into my form, that displays the contents of my second table (Assets) and reference's the field Username. Hopefully this will enable me to display my table (User) in the Form, whilst only displaying the relevent data in the subform (Assets) for the particular user.
I'm sorry if this sounds confusing, but I would really appreciate your help ...
:confused: :confused: :confused:
View 1 Replies
View Related