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 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 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
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
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! :)
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?
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?
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
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...
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
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.
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!
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..
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.
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
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
Hi! This may be an incredibly simple query. We have access users and non-users at our organisation.
Although our database is in access, the non-users would like to use excel, so I am trying to set up a link between the two.
I have managed to set up the link between the main database table and an excel spreadsheet, but I also use a form to enter info on the main database.
When I set up the link, I add something to the main database table and it changes the excel document... but when I change a name or something on the form, it doesn't change it in excel.
Any ideas how I can link all of it would be very much appreciated!
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.
I have a form with contact info, which also has a subform with other data on it. The subform is a continuous mode form. If I go to the "New" line (last line) of the continuous form, I can add information, and the records are linked via the customerID field on both the form and subform.
I want to have a button on that subform that says "New" that opens up a different form in a popup. I can do that part just fine, but when I try to enter data onto the popup form, the customerID field does not populate with the ID number of the person on the main form. It defaults to a value of "0".
So, is there a way to link the 2 forms like you can with forms and subforms? Or is there a way to have the customerID field in the popup form just populate based on the other form?
Not sure if this makes sense, but please help if you can. Thanks.
I KNOW I'm making this harder than it needs to be.... I have a union query that pulls from two sales tables. I'm setting up a report where a person can select a manager name, start date, and end date for those union'd sales. I can do all this no problem in the query, but I want to be able to have this information selected on a form, instead of through popups, to bring up the report. How do I link the form information to the query? I can't get the report to show information it "read" from the form. Does that make sense?
I cannot link a label with a control. I don't know how it happens, or rather how I do it, but on various forms the label is not linked to the proper control. I try to do it by clicking on the warning popup on the right side and indicate I want to associate the label with the control, but sometimes it just doesn't work. That is, if I set the visibility of the control to True or False depending on the value of another control, the label still appears.
I've looked in the properties of each, but there doesn't seem to be anything there to indicate the link or association. Other than laboriously copying and pasting the label back on the form with the control highlighted, is there any way else to do this?
