Linking Forms, And Data
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 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
Oct 13, 2005
I have a database for the clients at my work place.
The main table with PK ie FRED001 has main client details (address DOB etc) then i have numerous other tables ' relationship one to many' with their investment details (lots of investments per client), appointment details, pension details, health details etc. The data base works fine in table form all the links master to child work fine but now i need to let the rest of the office loose on the system i am trying to create more user friendly form system with command buttons etc
I have created a form for each table some of which have sub forms in etc on their own they appear to work fine you can view all the records and add a new one
I am having problems linking the numerous forms together and when they are linked together (i also need the child form to auto insert the code from the master form? since it comes out blank at the moment!). At the moment i have the main form with command buttons on it to open up the child forms. this works i can see the current investments already entered on the database but it will not let me add a new investment or a new appointment etc it says that by adding a new invesment under the client code i am breaking the code no duplication rules?? but the child tables are set up with the clientcode allowed to be duplicated ??
I need to have each child table in a new form really since there is far too much information for it to all be on sub forms within the main table.
I have tried to also put the forms on tabs but i get the same result.
basically i need to be able to open up the main form at client X then using command buttons or page tabs move to both view their existing investments and add any new investments. Im sure it is something very simple that i have done wrong but i have been trying to solve this for ages now and its getting me more and more wound up ahhhhhhhhhhhhhhhhhhh!!
I have also tried inserting under tabs a small subform list for each table/formie policy number, surname etc to fill in new policies and the name with a command button to the form ( which should then have the details in?!?!) since i figured if these details were filled in then when i went to the form they should be there but tthat doesn't work either
thanks for any help or suggestions
:confused:
View 1 Replies
View Related
Jan 23, 2006
Hi Experts! I'm having a problem that I hope some of the experts can help me with. I am in the process of designing a database for a health insurance company that does health fairs.
I need to have a data entry form for the nurses to enter the Health Fair results. I created a form for them to search for the Employer group. They type first few letters of the group, click "find group" button and it brings up a subform (frmGroup_sub) with the filtered group. I then have the group number (field PARGRP) hyperlinked to bring up another entry form (frmHF_entry) when clicked. I need the user to be able to find the group, click on the group number, then bring up another form which autopopulates that PARGRP from frmGroups_sub into the new form, frmHF_entry and stores that group number in the table tblHF. Further, they will need to do more than one "employee" for the pargrp. So I was going to make a subform of frmHF_entry where they could enter multiple records for that same PARGRP.
I just confused myself and probably all of you...but the problem I am having is I cannot get PARGRP from frmGroups_sub when clicked to open and auto populate the form frm_HFEntry.
Here is a screen print, maybe it will help explain what I need.
http://img82.imageshack.us/img82/1065/frmhfentry1ed.png
thanks in advance for your help.
View 6 Replies
View Related
Jan 5, 2005
Hi everyone,
I have a quick question. And perhaps a strange setup. We have an excel spreadsheet set up with a bunch of data.
The powers that be would like me to set up a database utilizing the spreadsheet as the foundation of the database. However, they would still like to keep the spreadsheet as one of the primary ways to enter/edit data along with the database.
Therefore, I was wondering if there was anyway..that I can set up a link(?)
between the access database and the excel spreadsheet in such a way that if one is editted the other one would be editted accordingly.
I know this is a replication of data etc etc. But this is what I was asked to do. Im not sure if it can be done anyway.
I know I can link in the excel spreadsheet into the access database...but can I create a table..based on the linked information..and add more rows and column to it?
Let me know your thoughts!
Thanks I appreciate any help!
View 2 Replies
View Related
Jul 3, 2006
ok i have two tables.
the main table tblquery and the second tblreturns
i want the data from tbl query
return number
date received
date processed
to be the same in the tbl returns is this possible?
View 2 Replies
View Related
Jul 25, 2013
I have two databases that are used by different teams. There is reluctance for both teams to use the same data base because they are used for different purposes etc.
However, there is quite a bit of information that crosses over. Basically, when an order is logged it goes to Database A (DBA) then they import the customer information such as name, address etc. Then the order is passed to team B who deal with the order, who use Database B (DBB). Currently Team B have to import all of this information again into DBB.
What I want to do is link the two databases so that once something has been added to DBA it becomes available from a drop down list on DBB and team B can then import all of the other necessary information they need.
What would be the best way of linking these up? i thought about trying to create a button in DBB so that when it is selected it asks for an order number which would then search DBA for that number and provide a new record in DBB with the first few fields already completed.
View 1 Replies
View Related
Jul 10, 2006
hi, i have a table database created and i would like the information in it to be able to be linked to a form. but only certain information in the table, not all.
View 1 Replies
View Related
Jun 28, 2005
Right guys heres problem.
I link to an excel spreadsheet. all the data is except where Ive had to format a "column" of cells as text. This is done because in the spreadsheet the initial user enters data as text, numeric or a mixture of both (hope thats clear).
My problem is the data that was originally numeric and now formatted to text comes out at #num! ( Yes ive posted similar before) However, when ive imported the same data in to a pre-made table to try a different way of achieving the final job the numeric data (now formated to text) comes out like ---- e.g. instad of 1000344 it comes out 100034+007
And now Ive absolutly NO idea what to try next. Its one Ive never seen before. If i go in to either the linked spreadsheet or the premade table and over type the errors with the correct data - no problem!
So it seems like a conversion issue
Any ideas at all - Id be so greatful if you have1
regards
gareth
View 2 Replies
View Related
Sep 5, 2014
I then have various support queries that group customers based on reason for visit, type of visit etc. I need to be able to link this to my main table so that each customer has a category against them. The issue I have is that some customers will have more than one visit ref, which can also mean they have multiple reason for visits. I need to make sure that when I link my queries back to the main table that the right category appears against the customer and their correct visit ref.
View 1 Replies
View Related
Jun 14, 2005
Hi Guys,
Haven't done anything with Access since I finished uni and I can't remember much. I'm trying to set up a simple database with customer recording and order taking functionality. Just in the very early stages trying to get basic things working.
I have a form where you enter customer details..at the bottom there is a command button named "Place Order", which will be clicked to go to the order form for that customer. Attachement shows very simplified version of the order form. I need to enter a Product ID, and have the Product Name automatically extracted from the Products table.
How can I do this? I would have done a search...but not even sure what this process is called in Access.
Thanks for any help.
View 1 Replies
View Related
Dec 12, 2012
I have two tables that I'm struggling with how to relate to each other. One is tblHardware which contains all the items that we sell. There are no duplicates in this table. The only columns are a part #, description, long description, and cost.
Then I have another table with is tblPackages. These are the packages we sell which pull from tblHardware. This one just has an autonumber, description, and image (image I'll add later and not worried about now).
What I'm struggling with is how to tie these two together because one Package will contain multiple items from Hardware however there are multiple Packages that have the same Hardware items (17" monitor for example).
View 3 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
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
Apr 29, 2005
I currently have on form with many subforms on it. The main form is linked to the subforms using a field "LocID". Since not all subforms need to be used, what I want to do is to add buttons to pop up a form if the user wants to add data. (This will not make the main form so large and ugly)
I seem to be able to code the button to open the proper form, and can add data, but the link field (LodID) is not carrying over to the form just opened. This form will only be for adding new data.
How can I get the LocID from the main form and into the new form that opens?
Also, is there a way to keep the main form maximized while opening the new form? Both forms go into 'restore' when I click on the button?
Thanks
View 3 Replies
View Related
Jun 20, 2005
I have 3 forms bound to 3 tables . I am having trouble linking them. The first first form is a client info form which records info on a new client. I have a clientid autonumber as PK. The second is a CaseInfo form with the clientid and a CaseID as a combined PK. The third is a case details form which has an autonumber field but the clientid and CaseID are a combined PK.
I have the caseinfo table linked to the client table in a 1 to many relationship and the case details table linked to the case info table in a 1 to many. When a new client comes in We should be able to fill in the new client info, open a linked case info form and fill that in and then open a linked details form and fill that in. I can't seem to get my forms to do this with my test data. What am I doing wrong?
View 1 Replies
View Related
Sep 16, 2005
I have two forms, a main form frmProperty and a secondary form "Training Details" you access the training details via a button on the frmProperty form. This is the code for the button.
Private Sub Trainingbtn_Click()
On Error GoTo Err_Trainingbtn_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Training Details"
stLinkCriteria = "[Property Code]=" & Me![PropertyCode]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Trainingbtn_Click:
Exit Sub
Err_Trainingbtn_Click:
MsgBox Err.Description
Resume Exit_Trainingbtn_Click
End Sub
I noticed however that whenever the user enters data no matter what the "PropertCode" of the main form it was assigning it to PropertyCode = 0 :(
So as a temp fix i have inserted the following code into the GotFocus of a text box that is filled in. This code did not help in the Form_Load section...
[Form_Training Details].[Property Code] = Form_Property.[PropertyCode]
This works, but obviously is very messy. Where am i going wrong???
View 2 Replies
View Related
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 2 Replies
View Related
Feb 17, 2006
Extreme novice small business trying to use Access, need some help.
I want to setup a simple payroll system in Access - we have a database of 13 employees already in Access as well as a form we created with fields to enter hours and calculate total due. This may end up being very easy or very hard, but I'd like to know how to, first, set up the form so that it performs the calculations (hourly rate x hours) and then enter this information into another database that will keep track of the weekly payroll...is this far more complicated than I think? Any help/suggestions/points in the right direction are much appreciated.
View 1 Replies
View Related
