I posted earlier today and despite all of my best efforst I have made very little progress. I keep hitting my head on the desk at the same point.
I am trying to get one tool entry to link to many records for each tool.
The form [frmVibrationResults] holds tool info, PK is [serial number/reference] as a text field.
The subform on this form called [frmVibrationMagnitude] holds test data for each tool. I want to be able to add a record for each tool for each test. At the moment it only lets me add one per tool. If I try and add more than one record for a tool I get an error message telling that I am duplicating information in the PK, index or relationship.
I have tried all day to solve this and can't proceeed without it working. Can anyone help. I've attached the zipped version of the DB.
basically i want to have a button that opens up a form that links to the record i'm currently viewing. But then i want to be able to navigate to the other records, in access when you use the wizard to find specific data on a form it doens't then let you navigate to the other records
OK, I so I am trying to filter one combbox tbltCatch from tblLocation (which is a sub filter from tblLocationCategory). Thing is, I am trying to select "Catches" filtered from the tblLocationCategory table. Reason being is because the "Catches" are the same the location types (example below). I know the code I am trying to utilize is incorrect and needs to be modified.
I have a table (tbl Team Info) which contains names and codes for teams within my business (>400 records) and another table (tbl Process) which contains a list of high level tasks (30 records).
I need to create something where for each team name 9in tbl Team Info) I can map them to the tasks that they undertake (in tbl Process) and assign a percentage of time then spend on each task. Each team could map to several different tasks.
I have a database with a table with company names, then a relationship to another table that shows that companies' address, but I also want there to be an address 2 and 3 and so on, and some of our companies have multiple sites.So what Im asking is how would you be able to show multiple data, on a sing record.
I have created a very simple database. I have one form and one table. I have items in the same table as different records that are similar but not the same. I would love to create a link between records to get to these similar records easily. I have read a lot about linking between tables on other things; is it possible to link between records on the same table? If so, any info on where to find it?
I'm experimenting with access and I figured I'd try making a small recipe database, and I entered in all my field names like: Item, Item description, Ingredients, Procedure, etc etc. And when I make my form I want to be able to have links in my ingredients list.
So for example:
Item: Birthday Cake Item Description: Cake for birthdays. Ingredients: Eggs, Flour, Frosting, etc.
Now eggs and flour in the ingredients list wouldn't have links since they're basic components. But for frosting, I want to be able to click it like a hyperlink and it'll send me to this record:
Item: Frosting Item Description: Sweet stuff that goes on cakes. Ingredients: Sugar, etc etc.
I found out i can link fields in different tables together. But is there a way to do what I'm describing above? Linking records to other records?
First of all, apologies if this is in the wrong forum, it's my first post and I'm new to the site.
I'm currently working on an Access database that stores personal details.
I would like to be able to link the database to a network drive so a user can see all related .doc .pdf .xls files on the network that are associated with that record.
************************** Here is the ideal situation:
User looks up record with unique ID 123456 in the database
Database then displays screen showing content of S:Users123456 (Where S: is a network drive)
User clicks database record showing "Personal Details.doc"
Hi, I have been thinking of allowing our users to be able to link records together within our database. We have a CRM system that lists customers and their details of mortgages and other insurance related products which they have. Some entries maybe linked in some way, possibly other family members etc.
My question is, is it possible to perform this kind of action? So they can then see relationships between either related records (ID ref etc).
I'm sure I've seen this in SQL based applications, but haven't come across it within Access.
Before I spend an age trying to get this to work I thought I'd consult some experts.
I have a main data table for recording all possible insurance claims against a company. What I want to do is create say 2 incidents but link them in some way. i.e. One of our drivers had a car accident (1 claim against our motor policy), but then the driver of the other car sues us(1 claim against our public liability).
I can create 2 seperate records and maybe have a field to highlight parent/child reference numbers, but is there anyway I could allow the user to click a button and see the related records simultaneously?
I'm building an access2000 database for the development department for a nonprofit. The database houses a contact list which is populated by the names, addresses etc. of all the people that have donated money. The organization will often receive a gift from the husband OR the wife - so we want to have 'gift histories' which isolate a unique record (the individual - in this case we don't want to send a thankyou letter to John AND Mary Smith for a gift that came in from ONLY John Smith). However, when the organization has a fundraising event, or wants to identify how much a specific household has donated then we want to run mail merges and reports that pull information from both the husband AND the wife's records.
Currently the only to do these things is a manuel process. We have records for: John Smith (husband) Marry Smith (Wife) THEN WE ALSO HAVE John and Mary Smith
Therefore, whenever we want to send out a mailing or generate a report we have to delete duplicate addresses from the mail query report, making sure we use the appropriate record for the mailing.
Thus, my question is this:
Is there a way to associate two records from within the same table? That way I could:
run a report for just 'John Smith' OR John Smith PLUS affiliate record.
Send a mailing to 'John Smith' OR send a single mailing to John smith AND affiliate.
This very simple task is actually quite difficult because access doesn't want me to link two records from within the same table. Any suggestions?
Attempted to link to a table on an SQL Server, which included customer records & various contact dates, after the importing the records became corrupted in that they repeated the initial date over & over e.g.
Customer Date AB1111 16.11.04 AB1111 16.11.04 AB1111 16.11.04 AB1111 16.11.04
...as opposed to listing same account number but with 4 different contact dates...also when the Access database was opened on a different PC (also Office 2K) the table was displayed correctly?
Has anyone else come accross the same issue, any advice/guidance much appreciated. :rolleyes:
I have been looking around for a while now to learn how to show in a subform similar records from the same table, and a way to link them together.
I work for a mental health organization and we have a call log database that we create a new record every time a person calls us - this allows us to track the outcome of these calls. Over the last 3 years we have about 10% repeat callers. I am trying to find a way, when creating a new entry, to see if this person has called before, and if they have, link their past contact (record) to the new contact (new record).
For example.
Caller: John Smith (555) 555-5555 (this is the new record)
in the subform, a list would populate all the 'john smith' records with an option to link or attach them to the new record.
I am trying to put together a database that tracks individual clients and what products they selected for a finance company. I have setup the CLIENTS list but because each client will have different (and multiple) services I wanted to add the SERVICES list as a separate item and then link each product to the individuals that each record relates to. There may also be two clients on the one product so again it would be ideal if the product (i.e a Home Loan product) was setup in the SERVICES list, and then I could link One or Two clients to that individual mortgage record using their data which is stored in the CLIENTS list.
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!
Firstly to set the scene i am trying to create a training DB.
I have a form with one textbox in it which is for the course title. I then have a continuous subform with all the peoples details in it and whether they are trained or not.
There are nearly 40 courses and 33 people.
The problem i have got is that i want the list of people to stay constant in each course but this the gives the problem of the 'Course Completed' checkbox. BECAUSE if i link the subform to the mainform and a new person starts you have to go through every course and add them and if i dont link the forms the 'Course Completed' checkbox stays the same!
Is there anyway to have it so that the list of people in the subform stays constant even when one is added to the table but the checkbox gets updated?
I have tried this many different ways like adding the checkbox as a subform etc etc but with no luck!
If you can think of a better way i am VERY open to ideas - Thanks in advance!!
The titles a bit vague but im doing a library database and i have done everything except from the main part of a library which is taking a book out. So what i need to do is choose a specific member, then click a button that allows me to choose a book for that member, and then click another button that puts the members details and book detail into the loan table, so i can then issue the loan.
another thing i need to do is when a book is taken out, the 'available_in_library' check box needs to be unticked.
I have 2 tables Respondent & question, for a survey. THe relationship is one to many. I'm having users login on Form Login. After login the actual survey form opens and I hide the login form. Problem is only the login information is writing to the table. I need the RespondentID to store a value in TblSurveyID. Both forms are based on a query. I placed this on the form survey Before Update Event.
Me.ResponentID = Me.TblQuestion.ID, but I get an error message.
Any idea how to fix other than scrapping a form and using a subform(s)?
I have the following tables: tblSales, tblCustomers, tblEmployees, tblInstall, tblCreditCheck.
There are 6 products in 2 categories: Sky: Sky A, Sky B, Sky C and Phones: 3G - A, 3G - B (these are related by tblProducts to tblSales)
tblSales has lngCustomerID and lngEmployeeID. I want to be able to input data into both tblSales and tblCustomers and tblInstall or tblCreditCheck at the same time.
tblInstall is only used for Sky deals and tblCreditCheck is only used for phone deals, and the data needs to be entered there at the same time as into tblSales.
However the biggest problem is creating an entry in tblSale and tblCustomers at the same time... so I want to link from frmCustomer (Having created a customer entry) to frmSkySale or frmPhoneSale where it will automatically input lngCustomerID # (The one that I have just created) into the lng_CustomerID field. Hence I would be putting the data into the frmSkySale which would correspong to a particular customer.
I am currently making a database where I need to make fields in various forms link to each other and create a final summary report which contains all the info found in the previous forms. Any ideas? Thanx :confused:
I have a button opening a create item button on a form. This open and creates new record on a input item form. This form is also on the 1st form within a subform (dataview).
1st Problem I am having is that the 2nd form for inputing items into the DB doesn't show the current customer the items would be assigned to as it does with the 1st form.
How do I get the button to open the form and have the correct customer in the data without having to enter it?
2nd Problem is how do i grey out a box so it shows the autonumbers and does not let you edit the field?
Hi, I have a question.I have a form with details of a people on (Such as forename, surname and the such like)I also have a button to open another form (which pops up on top of the original form). On this form is other details (Such as Medical Details)No matter what record im viewing on the original form the details on the medical form, when opened, doesn't change corresponding to what record is being viewed on the original form and only shows the first record all the time.My question is this:Is there a way so when the button is clicked to open the medical form, the data shown on that form is for the person/record being viewed on the original form.Thanks
In the past I have used basic access. I have now been set a task to create a database and there are a few things I cant quite figure out.
1. Is there a way to link text from one form to text on another form, for example if MR.A was doing a course called 'abc' could i click on abc under his details and have it open a page on a different form that shows abc's details
2. in a text box i want to hit enter and be taken to the next line in the box instead of the next field, how do change this? also is there a way to increase the maximum text in one box as there seems to be a limit to the amount i can enter
3. this is the smallest of my problems, however would still be nice if I could fix it. on a text box label when i enter the & character it shows up as _
thank you in advance for your help, it is much appriciated
i have been trying to for the last several weeks create a database which holds information about companys e.g addresses etc on it. It also has a subform on it which runs a query and shows me the courses they run with a button beside it. This subform propertys is set to continues and so there is a button that appears beside each course. How can i get it so when i click on the botton beside that particualr course it will load up another form and display some more information holding the times and dates of this course.
I've been designing a db and entering data in the process. Now I'm almost done with this project and other people are interested in this db. Is there a way to empty all table records? Is there a command to have a blank db? My db has almost 5,000 records :S and each record has another table with 5 linked records so there are like 25,000 records to delete. I know there is a way and its to create another table with the same fields and importing the rest of the objects... but I want to make there is no other way.
Another Q is how to add security to my db how to "attach" the db to a hardware of a computer so if the db is installed on another computer it asks for a serial number...I have asked this before but no one had answer me this. Thanks in advanced
