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?
Hi, can anyone please help me. I've just set up a form with 2 pages which I can add data into, but for some reason, I can't view all records. I've tried using the switchboard to add buttons to both add records and view (but they both only add), and i've also set up my own button with the instruction to view all records, but it just won't work. On the first page the data source is tbl_CompanyInfo, and on the second page, the data source is a subform with the data source tbl_Contacts. The subform will link contacts to the company info via the CompanyID field. I hope that makes sense. Can anyone please tell me how I can view all of the data via the form. Thanks very much
I'm not sure if this is possible but I've been asked to devise a way of viewing past record entries from an old form on a new form. Our database contains yearly records of student details; each year has a separate form. What my manager would like is that when a student ID number is typed into this year’s form, that old data from previous years is retrieved and placed in the database OR some sort of command button that searches past records for that particular student ID.
Hope that makes sense, I'm completely confused about the whole thing, I'm not sure if it’s even possible...any kind of help will be gratefully received!
I have a split database with the back end on a sharedrive. I have the front end saved on my own drive and the same for my colleague.
When I view the front end version of my colleagues, I can see a records on there that she has input but I can't see them when I open my own copy of the front end plus when I view the back end I can't see the records there at all.
I deal with different blood test reports for same patient on different dates. Because tests are so many, so i have arranged them on different pages of the same main report. But the problem is, that access shows different records of the same tests for different dates one under the other as a set...while i want it to show in parallel columns with test label on left side and column heads as different dates.
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.
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 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
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'm wondering how can I view only those query data with value in certain fields.
For example in a record of students with check marks, view only those students with check marks and leaving those having no check mark out.
I know it has something to do with the criteria but not sure what. I've already search the MS Access Help as well as this forum and have not found anything.
I am working creating a data entry form. I am using the data entry option in the form properties to do this. However, when I do this, my subforms do not display any information.
Ideally, I would like them to display information when the field linked to the subform is entered on the main form. Is there an option for this ?
Hello Access gurus I hope I am in the right place to start this off I had D/b all set up but i need to have on my form a view of directory(s)
I have button that creates the folder (many thanks to the person whom gave me this ) but what i want to be able to do is preview this witihn my form
so on my form I want a box that will show what i have stored in this folder (which could be word or pdf or xls) my button will create C: empfiling filenumber & filename ( about 20 chars) so my form need to be able to preview all files within this folder ( I hope that I have at least half way explained what I am after Access 2000 - and reasonable expereince (not brillaint at advance VB )
I've used Access 2003 to create a database which contains a table linked directly to the "Orders" table on my mysql server. This table holds all of the customer orders placed on our website. I next created a form in access to give me a nice justified view of the orders.
My Problem? The field on the mysql server that holds the line item details for each order is a "Memo" field, and all of the text is formatted in html it appears. When viewed on the form, I see the all of the raw code, and not the nicely formatted text. If i highlight a section of the code from the form, and paste it in a Html editor (Frontpage for example), I see the line items nicely formatted as intended.
Is there a way to get this memo field to display the formatted html text instead?
My access skills are pretty limited, so detailed steps would be appreciated.
users can opening a file (either .doc, exe or .pdf) with additional data to the record they're looking at by clicking on a icon on a form. The icon has code behind it that opens the document (Application.FollowHyperlink NameDocTo Open). That opens the doc OK, no problem, but what is a problem is that the window for this document is exactly the same size as the window of the access form from which the second doc is opened.
The size of the access window is defined. I'd like to get the word or excel or pdf to be maximized. The weird thing is that I use the same code in another database and there the 'secondary doc' opens in a new window and of large enough size. How can the same code generate 2 outcomes? And how can I fix the issue described?
I was wondering if there is some setting that can be set such that certain records within a table are not visible when the table is opened, or a form is accessing its records.
It seems from time to time, some records seem to 'disappear' from view?!?
Other than a filter...
Does anyone know how this is possible, and what can be set or specified in order for this to be happening?
I have one table (tblLink) that resides on an SQL Server quite a distance from me. I have another table (tblLink_r) that resides in a local .mdb file. The tables are identical except for the data they contain and where they are located. Only one index (LinkIdx=autonumber) exists. I am making sure there are no duplicate indicies in the LinkIdx fields because I started the LinkIdx field in tblLink_r at 2100000000.
When I open tblLink (remote), I can scroll to the end of the 21,000 records relatively quickly - read: little latency. Queries performed on this table similarly show little latency.
When I open tblLink_r, I also have little latency. This table has 100 records.
I need a single object which contains the contents of tblLink and tblLink_r. I have tried a UNION ALL, but this query takes upwards of 4 minutes to complete which I can't understand since either of the constituent tables only take ~.5 seconds to call up.
I am hoping someone can provide a way to speed up the UNION ALL query or provide an alternate means to combine the contents of these tables.
I have a form with a subform on with the visible value set to false. After a value has been selected from a combo box i then want this subform to show. Tried calling the form using me!formname.visible = true in the afterupdate but it says it cant find the form.