Help With Linking Multiple Forms
Nov 30, 2005
Hello,
I am using multiple forms to enter some data. When I enter the data in the second form and go back to the main (first) entry form it always goes back to the first record. Also when I am at a record at the first form and go to the second form it always starts at the first record. Is there a way to make the two forms match the record I am entering. I am entering data into the same table. I needed to use two forms because I could not fit all the information on one form. Thanks
View Replies
ADVERTISEMENT
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
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
Mar 4, 2015
I have what should be a really simple database to build. In table tbl1PlanHdr is the header item. Many items in tbl2MaintItem will then be allocated to each header. MaintItems items will be allocated to more than one Header.
I want to set up a form that has the tbl1PlanHdr as the main part of the form and tbl2MaintItem as the subform. Possibly as a datasheet, or continuous form.
I need the ability to update items in the subform back to the orginal table.
I have a relationship of one to many from the tbl1PlanHdr to tbl2MaintItem using the primary key in tbl1PlanHdr.
But should this be a one to many from tbl2MaintItem to tbl1PlanHdr
The end result required is to be able to get a data dump of all the tbl1PlanHdr items with the corresponding tbl2MaintItems items.
View 8 Replies
View Related
Jul 2, 2012
I work for a small manufacturing company and have been asked to set up an access database to track production. The end goal is to have a touch screen at every machine where operators will input data. This data will then dump to a different workbook for each machine. My question is: Is it possible to link one access tables with multiple xls documents so that, as data is added to any of the workbooks, it is then updated to a single access table? I also will need to find a quick way to link new files to the table as new parts are put into production.
View 4 Replies
View Related
Mar 20, 2008
Hi
I am very new to Access and have been building a database from scratch. It is for inventory management and I have a number of tables, particularly:
1. Stock List
2. Orders (stock coming in)
3. Requisitions (stock going out)
I have created Select Queries for the Orders and Requisitions tables to sum the totals in these tables (i.e. the total number of Pens coming in from all of the orders etc.). These are called StockOrderTotal and StockRequisitionTotal.
I am trying to create a query/report that will allow me list all of the Stock items and the current balance (i.e Orders minus Requisitions) for each item. However, once I add the two queries together (StockOrderTotal and StockRequisitionTotal) the final query/report only lists stock items that are found in both of the underlying tables.
Is there any way that I can tell the query to return all stock items and only list the Order and/or Requisition totals that are in the underlying tables? Sort of like an 'if' statement in Excel, where the value returned will be zero if that particular stock item is not found in the Orders or Requisition tables?
Thanks
Rich
View 3 Replies
View Related
Nov 6, 2014
I am using Access 2010 and I am fairly new to it (started using it for work).
I have a table with a bunch of a agreement numbers (134) and I need to link each one to its folder on our company's shared G drive. The agreement numbers all follow the format A12.## (Where ## is the number of the agreement going from 1-134).
So I have the path to get to the location of all the agreement files, and I know there has to be a faster way than to edit each individual hyperlink, I myself just don't know how to do it.
Also the files on the shared drive start with the A12.## but then also continue with the name of the agreement. I was thinking that somehow for each record you could apply all at once the same path to the agreements and then for each individual record get it to search for its closest matching agreement number?
View 5 Replies
View Related
Nov 8, 2012
I am working with a large database of 8,000+ entries. We have five tables in this database, but mainly use three of them. The main table is "OAKE Main Table" which is basically a list of all members our organization has had. Each member has accounting data linked to their member ID number which has been generated by ACCESS, and can be accessed or edited by clicking on a sub table next to each member. The accounting data that has been manually entered in the OAKE Main Table can be found in the Accounting table.
Here's my issue. I need to be able to extract a list of transactions from this accounting table since January 1st. I can do this no problem, but all I get is the member ID and the accounting data. How do I get ACCESS to include the member ID's first and last name? or maybe even the first, last name, address, city, state, zip, etc so that I can get a list of people who have made donations, for example?
I'm assuming this will have something to do with the relationships we have set up in our table. Here's a picture of it. I have no clue how to make this work.
View 8 Replies
View Related
Jun 9, 2005
I have this form which shows an order.... linked to this order are the client, the principal company, and the company that carries out the order. The information for these three companies are all stored in one table (since the information is very similar).
Tables look like:
tblOrder
- OrderID
- ClientID * linked to CompanyID
- PrincipalID * linked to CompanyID
- Contractor (company that carries out the order) * linked to CompanyID
- Date
- ...
tblCompany
- CompanyID
- CompanyName
- CompanyAddress
- ...
An example is for instance:
tblOrder
- 1, 1, 2, 3, 01-01-2005
tblCompany
- 1, Comp A, 200 A Lane, LA,
- 2, Comp B, 100 B Lane, NY
- 3, Comp C, 300 C Lane, SF
So, on the form it should read:
Date of contract: 01-01-2005
Client: Comp A - 200 A Lane, LA
Principal: Comp B - 100 B Lane, NY
Contractor: Comp C - 300 C Lane, SF
I understand how to make one link to a form... but how do I make three links from the same table?!?!?
Any help is appreciated!
Jazz
View 1 Replies
View Related
Sep 30, 2014
My question encompasses a front end connected to multiple back ends. It is probably a mundane point, but reading a few articles didn't seem to touch on it.
By this, let me toss out that I am thinking of the personnel where I work when I say 95% have a hard time using email and MS Word, let alone mundane functions like find a file, etc. As such, I have to make my front-ends extremely user friendly.
With that in mind, when developers have multiple back ends, what are thoughts about the best way to relink when required? Even when there are 'more sophisticated' users? Security not an issue or is an issue (inasmuch as can be handled in access)?
Ex: Large corporation with a multitude of user ability. Large database with say 3 different back ends.
I was thinking about keeping a front-end table with each table name and UNC path, hard coding paths to corresponding table names, etc.
Personally I don't have a need for multiple back-ends, but the question came up while reading.
View 7 Replies
View Related
Dec 2, 2014
I have done multiple tutorials to get the fundamentals behind me, but seem to have a few issues on the best ways of setting out what I have in mind.So the set out I have used is creating a table called tblProjects - this will be the area where all new projects are added as they come in including details such as a ProjectID ProjectNumber ProjectDescrition Client Name etc. For costing purposes we also have task numbers that need to sit under an individual Project Number EG.
ProjecNumber: 13001
[code]...
So the plan was to create another table called tblJobTasks..How then does one go about linking the project number to the job tasks... and following on I suppose where I want to get to with this is on a form having a drop down that selects the job number then another drop down that has a list of tasks specified to that particular job so when the girls are doing the data entry from a time sheet she only sees the list of tasks associated with the particular job selected in the first place..
View 1 Replies
View Related
Feb 4, 2015
I've been using a series of 5 tables to export an XML file using Access's native XML export. In order to keep the XML intact, there are relationships setup to link each sets of elements together via an ID number(link) field in each table.
Access does a great job at exporting, but then we need to rely on another program to delete these link fields that links the tables together so our XML validates. Additionally, we use this program to reorganize some of the XML, as one of our tables puts itself at the end of the XML element and not in the middle where it should be. This is not a problem when I'm dealing with a few hundred records, as the 3rd part program does the trick. The problem is when I have enough data to generate a 30+MB file that my other program chokes on when trying to manipulate the XML.
So my question is...how can I export these 5 tables to XML while omitting the linking member fields and organizing it how it should be? I have examples of code below. How Access Exports it
Code:
<MASTER-RECORDS>
<RECORD-ID-NUMBER>5648743524654</RECORD-ID-NUMBER>
<RECORD-ID-NAME>JOHN SMITH</RECORD-ID-NAME>
<link-for-pseudonyms>123456</<link-for-pseudonyms>
<PLACE>USA</PLACE>
<DAY>MONDAY</DAY>
[Code] .....
View 5 Replies
View Related
Mar 11, 2014
I have built a end user form with multiple toggle buttons with "Yes/No" properties. I am wanting to link the buttons together, so if all have been selected/pressed it will read "pass" in a text box, but if even one is not selected it will read "fail". I was successful with the programming for one but not sure how to link them.
View 2 Replies
View Related
Oct 8, 2012
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.
View 2 Replies
View Related
Nov 21, 2007
Please please please help me!!
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!!
View 2 Replies
View Related
Dec 18, 2005
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.
View 3 Replies
View Related
Mar 31, 2006
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)?
Help would be greatly appreciated.
View 3 Replies
View Related
Jul 13, 2006
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.
Regards.
View 2 Replies
View Related
Aug 31, 2006
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:
View 1 Replies
View Related
Nov 28, 2006
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?
View 1 Replies
View Related
Dec 4, 2006
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
View 14 Replies
View Related
Sep 27, 2004
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
View 2 Replies
View Related
Feb 16, 2014
I'm pretty good with setting up a very simple database such as inventory, profiles, etc.. However I'm creating a database to keep track of a football (soccer) team's players and match statistics.What I have so farsample attached)
Tables:
* Players - PlayerID, Fname, Lname, position, goals, assists, etc (all details regarding a player)
* Position - Positons (Table containing positions eg: defender. Data is selected in player's form as a combo-box)
* Competition - Competition types (Cup, League, Friendly. Data is selected in Match's form as a combo-box
* Venue - similar to Competition table
* Opponent - Similar to above two tables
* Match - MatchID, Competition, Venue, etc (form corresponding to table attached)
Forms:
* Player form
* Match form
Now as shown in the sample, I choose players using the combo-box. Then whatever stats they had during the match are entered on the fields provided. How to link the player (selected using combo box) to the stat fields (goals, assist, YC, etc).
View 1 Replies
View Related
Nov 21, 2012
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.
View 3 Replies
View Related
Sep 7, 2011
I'm trying to set up a simple query that links four tables. However, the tables are extremely large, all in excess of 1.5GB each so I had to split the tables up into four separate DBs. I've tried the following with no success:
1) Link the 4 tables in the DB which contains my primary key. This quickly inflates increases the file size above 2GB and won't let me go any further.
2) Build a remote query to connect the four tables. This looked promising until I tried to run the query and it became evident that it only knows to point to the last database source that you specified.
I'm running everything locally on my C drive. The data source are simple text files (1.6 million rows) from the FDA website.
View 3 Replies
View Related
Oct 21, 2005
Hi All, I am having a problem with linking my forms, with linking data.
I have: Main, Landscape, A,B,C,D, Q,X,Y,Z (Forms). On Main there are command buttons for Landscape, Q,X,Y,Z I have linked Q,X,Y,Z by the Code field on Main and the Code field on Q,X,Y,Z. The Landscape button will open Landscape with A,B,C,D (forms) Which all need to linked by Code there Code is ID. This is what is not working, the Code and ID is not matching up to these forms. Any Idea. *NOTE each form has a button called the same as the form, that is how the form appears. I have used SQL's for the Q,X,Y,Z forms. but that is not working for the A,B,C,D, forms. HELP!!!! :confused: Thanks
View 2 Replies
View Related
