Help Needed Linking Forms Together.
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 Replies
ADVERTISEMENT
Mar 28, 2006
Hi
I am designing a database to store volunteers and what particular function they are volunteering for. I have about 17 areas of volunteering tasks (i.e. Fundraising, Teacher) and at least 3 subcategories for those tasks (i.e. candy fundraisers, nursery school teacher). I want a form that you can enter the volunteer's info and then choose as many areas of interest and as many subcategories. I guess this would be done with checkboxes? Right now I am putting each volunteer task in seperate table (ie. Fundraising table, Teaching Table) and then trying to use combo boxes. But I want the person to be able to choose one or many activities.
Can anyone help me design this or give me a suggestion so that I can query or create a report to list the volunteer and what activities they want to volunteer for. I really appreciate any help I can get at this point. My email is ebbr820@hotmail.com or I will check back on this forum.
Thank You!
View 1 Replies
View Related
Oct 3, 2005
Hi,
I hope someone can help me, I have a database compiled from different sources which means that information in fields that need to be linked are written differently, meaning that I can't just simply make a relationship between them.
The two tables I would like to link are,
Table 1 has the fields OCCUPATION and AMOUNT and contains over 740,000 records.
Table 2 has the fields COMPANY_NAME and TICKER and has 500 records.
I need to find a way for all COMPANY_NAME fields in table 2 to be cross-referenced with the OCCUPATION field, so if COMPANY_NAME is part of the string in the OCCUPATION field then the TICKER (of that company) can be attached to the record in table 1 (specifically to AMOUNT).
The problem is that the OCCUPATION field is not written in a standard form and can include either only the occupation, only the company name, or both in either order.
I can make a seperate query for each company by using as criteria "like "*[COMPANY_NAME]*", but then I would have to do this 500 times!!! Is there a way to automate this?
The final purpose is to link the AMOUNT to TICKER so as to find the sum of all the amount associated with a company.
I really hope you can help, I have little programming knowledge and it will save me the time of making 500 seperate queries. The final use is for my thesis studying private contributions in the american elections.
Thanks in advance (I hope),
Onur
View 1 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
Oct 21, 2013
I have this declaration in a module called Global Code
Option Compare Database
Public currentCustomerId As Long
Option Explicit
There is one report that simply prints a the firstname of current customer and the amount of each of his invoices.
The current displayed customer's ID is always copied into the variable currentCustomerId.
Below is the SELECT code of the data source of the report.
But whenever I open this report it asks for currentCustomerId.
Is my decalartion not global enough?
SELECT tblCustomers.FirstName, tblInvoice.Amount, FROM tblCustomers INNER JOIN tblInvoices ON tblCustomers.CustomerID=tblInvoices.CustomerID WHERE tblInvoices.CustomerID=currentCustomerId;
Note: I chose to save the current customer's ID in a global variable because, for some reason, when I select the report the Customer form loses the current customer record and goes to the end of the table as if creating a new customer record. This would not be an issue as long as I can retrieve the value in a variable.
View 4 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 25, 2015
I have a form that I have opening in Filter by Form mode. It WAS working flawlessly, at least it was opening in that mode. It IS still requiring me to click on Toggle Fields once data is entered into controls to filter by, but that's another issue (I wrote a recent comment, but haven't gotten any response). Something different is happening suddenly that wasn't happening before. This form is a copy of a form needed to enter data.
Both forms read from a table which has several required fields. Suddenly, when I open the form to find records in ANY mode it's making me enter something into these required fields, even though I'm not searching/filtering by them. The message comes up "You must enter a value in the [Specific Required Field name here] Field." What did I do to make this start happening? How do I stop it? I DO want something to need to be entered in the required fields when new records are being entered and when things are being changed. However, I don't want it to be required during search processes.
View 12 Replies
View Related
May 17, 2013
In a simple Access 2003 database that has two table. A contacts table and a Report table.
I would like to be able to prevent the deletion of any contact that is still being used in the Reports table. The problem is that they are in a backend of a linked database. So the enforce referential integrity doesn't work. Plus I don't think I would like it anyway as it seems kind of dangerous to the reports table.
Is this possible to do what I need through the use of form coding?
View 14 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
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
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
Nov 21, 2003
My question is this:
I have a form called Family with a RecID field. When I create a new record on this form the RecID field auto assigns a #. Then the user is supposed to click the command button which brings them to another form called Child. This Child form has the RecID field and another called RecChildID.
The RecID field is linked to the same RecID field as form the previous form. But when I enter the child form and start it's linked record the RecID field is not filling in/ copying over the same # as the previous form. How can I get it to update the RecID from the first form to the second form?
Thanks!
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
Sep 29, 2005
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.
Thanks
View 10 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
Dec 1, 2005
hi all
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
anyone got any ideas
cheers
Andy ;)
View 3 Replies
View Related