There are total three tables tblInternal, tblExternal, tblCourses. Table
tblInternal and tblCourses is one to many relationship by reference foreign
key InternalID from tblCourses to tblInternal. If I just use these two table
to set up Master form and subform in ACCESS, you can in subform Field Linker
window of subform property Data tab select primary and foreign key to
generate link between Master and subform. So if you select user name from
tblInternal in Master form ComboBox, you can see the detailed information the
user relates to.
Same relation between tblExternal and tblCourses.
Now I want to merger tblInternal, tblExternal to list user name in ComboBox
by Union statement. But in SubForm Field Linked window I just see one primary
key from one of these two tables instead of two primary keys from each table.
I have created a master form, which is a tab style. I have five additional forms that I want to use as sub-forms within each tab. I also want to include master navigation buttons that will work for each sub-form in unison. In other words if I navigate to record 10 on tab 1 and switch to tab 2, I want the new tab to show the information related to record 10. It would appear that I need to link them together in some fashion.
After designing the database that mean after creating all the tables and when pressed on relations buttuon it shows a diagram with relations established. Is this a kind of ERD. in this it shows relations between entities so can we call that an ERD?
Hi, Im very new to sql so please excuse my ignorance, I ve been trying to do this for a while and not getting anywhere: I have a table that has customer and product data in it. Its super market data. I have a field that has customer education level (education), this holds text, (bachelors degree, graduate degree, high school degree, partial college, partial high school)
and a field low_fat which is boolean (0 or -1), wether the product purchased was low fat or not.
Im interested in the realtionship between education level and number of low_fat products purchased.
I'd like a resultset that counts the number of low_fat products purchased for each category of degree level. Something that looks like this
EDUCATION Low_fat_Count bachelors degree 500 graduate degree 234 high school degree 124 partial college 333 partial high school 124
Is this possible?
So far I've come up with this:
SELECT education, COUNT(*) FROM AllTablesMerged WHERE low_fat=-1 GROUP BY education;
but access asks me for specify parameters for education and low_fat.
I have a form with a subform. In the subform (based on a different form) I need a button to close the master form. In the subform I need to find out what the master form is so I can close it. Since I use the same subform in multiple forms I can't really hard code the name of the master form.
Hello I have a small problem that seems weird. I have a form which displays a subform with all correspondending jobs for one individual. The problem is the sub form displays the main form information with the other jobs. Im trying to stop the subform from displaying the current mainform's job information. So it won't look like there are more then 1 of the same jobs to other individuals. Can someone help me with the correct method to stopping this. Thanking you in advance,
Can anyone give me a direction for the following problem please :
I would like to create a yearcalendar that might do the following job for me:
I have 12 firms with different amounts of people working for them. We need to see those people once a year and give every firm an amount of days that they can come see us. Every firm may send 5 people each day but we can see up to two firms per day. So we receive 10 people on a daily base but only a max of 5 belonging to one firm.
I would like to have a means of automaticaly according dates to those firms over a period of one year but I must be able to exclude or instance, week-ends, holidays and so on...
I hope you can give me a start because I realy don't know where to begin
Hello all, I need help with making a query this will check the OrdQty for all items in a specific order against the Sup1inv field, then if supplier 1 can not fill the order have it check against Sup2inv field. Here is an example of the data im working with
The part i am having trouble with is making sure the query "understands" that both items on order 555 are the same order so the end result would tell me that order 555 needs to be placed at supplier 2, not 1.
I have 2 forms, a master and a subform. In the subform form there are some required fields. In the table behind the subform I choose the property of these fields to be required. but in the master form, when I start enter the information I can go to the next record without even touching the subform.
How Can I make the subform required in the master form?
I have built a Access solution for a music school, It was installed on 3 machines.
I'd like to protect my database from installing onto another machine without my permission.
I did install database as a mde file so they cannot see my codes. However, if they copy the database to another machine (esp. another machine in different school) they can use my software without my permission. How can I prevent this? If they copy the mde file into unauthorized machine, database should work as a demo version (such as limiting the number of records in tables to 10). How can I do this? What should I check, hd id, mainboard serial or what? Is there any ready solution (at least modifiable) for that kind of problem?
(see sig for details on what I'm capable of before you toss code at me ;P )
Here's my current setup:
Table1(Assignments) Instructor <related to Instructor table, pulls data from there) Academic Year Fallcourse# (where # = 1, 2, 3, 4), (course pulled from Courses table) Fallcourse#comp Fallcourse#notes Wintercourse# Wintercourse#comp Wintercourse#notes Springcourse# Springcourse#comp Springcourse#notes
Table2(Courses) Coursename (unique) Coursetype (required, elective) Courselevel (ugrad, grad, MAS)
Table3(Instructors) lastname firstname empID rank
The purpose of the database is to assign courses to various professors and append supplementary compensation and, if necessary, notes to each course assignment. Each professor can be assigned up to 4 courses (or something to take the place of a course) per quarter.
My problem. I have created a quite a few reports with this setup including an academic year schedule, compensation reports for the year, sabatical / course release listings, etc. I am having trouble with what I am hoping to be my final report.
Requirements for the final report: List of all courses for an academic year (filter by year) group by level (easy) group by type (easy) append instructor's name to the end
Report/Relationship Problem:
I can't seem to set the relationship to allow more than one field's data into the report. I can only show courses from the [Fallcourse1] because I can't relate multiple fields from the "Assisgnments" table to one field in the "Courses" table. Effectively, that's what I want to do, but my mind's burnt and can't seem to figure it out.
Maybe you guys could help me out? Suggestions, questions - all welcomed.
My bound master form has bound subform in it and both of them has linked fields. In the master form i've placed a checkbox which if unchacked will lock and disable a textbox in the SUBFORM, and if checked will enable and unlock the textbox and fill it with a calculation result, which will then be passed on to the underlying table.
Now, suppose in the master form (named X), i have A (checkbox) and B (textbox with numeric value) and in the subform (named Y), i have C & D (both textboxes with numeric values). Hence if A is checked, I'd like D to return the result of - "B*C". Or else D will remain locked and disabled.
I have a Master form which includes tabs within the tab I have subforms. I am looking for a way to filter my master form based on data found within my sub form.
I have a check box within one of the sub-forms called "softwareInstall" if yes the box would be checked. I want to filter all customers within my main form with a check box in my main form to turn on and show all customer who has this box check within the subform SoftwareInstall=True.
Sorry to open with a question but its usually the way, i'm quite an experienced computer user but never used any office products before and just thought i should learn as i'm losing money every week by not keep track of things properly.
So then to my question..
I've made a table to cover all the orders i have had placed, this includes a date column for when that order was placed. I just wondered if it would be possible to have some kind of system where after 7 days without any acknowledgement from me it either pops up or turns red or something similiar. I'm thinking the acknowledgement could be the yes/no box and i tick that when i recieve the item back, if i dont it either pops up or turns red or something :confused:
How to structure some MS Access 2007 Forms for the following scenario.
My table structure is as follows:
Product ++++++ ID (pk) ProductName ...
Tag ++++ ID (pk) TagName
ProductTag +++++++++ ProductID (fk) TagID (fk)
I want to have a main form that allows me to search for and displays a list of all products (and the dozen or so attributes for each product) that meet that criteria (I'm thinking a continuous form view of products).
So far so good. No problems.
Now I want a "tagging" form to the right of my continuous forms product list that is linked to the product which currently has focus. The tag panel should always show a complete list of all Tags. I want a checkbox next to each tag that I can switch on and off whether that tag applies to the currently selected Product. I also want to be able to add tags on the fly (without leaving the main form).
I think I have three forms in play :
Main Form Product Form (subform to Main) my product search criteria is probably on this form header. Tag Form (also subform to Main)
But with this approach I'm have trouble linking the two sub forms to each other. Actually, I'm having huge trouble figuring out how to display the list of all tags with a check box that when checked on and off creates / deletes a record in the ProductTag table and I really want Access to do as much of the CRUD as possible. I would prefer to avoid writing screeds of SQL INSERTS/DELETES on events. Am I asking too much of Access?
I have a form, a subform and a master unique table. I need the unique table to updated in the following manner: Form has certain fields that need to be assigned to every record created in the subform[id] and [info1] Subform has a unique [caseid], and contains further [info2] but needs to be bound into [id] in the main form. Example of the master unique table:
I've managed to accomplish this with a linked table&subform structure, but the master unique table looks like crap because it collapses the subform values into sub-records in the master table when the [id] is similar. The data is in the rigth place, i just want it not to be collapsed/expanded, but every unique recors shows in the table in the regular format
I have a form and a subform in MS Access 2003. I have made some changes to database structure, so I decided to change the subform also. When I changed the Link child and link master fields, the controls of the subdatasheet dissapear- they show only in design view. If I clear the contents of Link child and link master fields they appear again, but the records are not binded. Is there a setting on the parent form that also has to be changed, to make the new binding?
Hi there. I need a way to pass data between forms, and subforms. I have "form1" which simply contains a text box requiring the user to input an ID which I will call "PID". it also has a button which has the following code:
Private Sub Command5_Click() On Error GoTo Err_Command5_Click
Dim stDocName As String Dim stLinkCriteria As String stLinkCriteria = "[PID]=" & Me.PID stDocName = "TestExam" DoCmd.OpenForm stDocName, , , stLinkCriteria
On the form testExam, I have a page control with 3 separate tabs. For each tab, I've embedded three separate subforms. All forms involved, including the container form (testExam) are bound to separate tables. All tables have one common field - PID I'd like the user to only have to input the PID on one form, and have it trickle down to all subforms.
In the FOrm_Current sub of the testExam form, I have the following code:
Private Sub Form_Current() [PID] = Forms!frmForm1.PID End Sub
Using this code, I am able to pass the data from Form1 to testExam, have the PID on testExam filled in and on tab 2. But tab 1 will not populate automatically. I have no idea why. I don't know where to start troubleshooting this. Please help.
Is this even a good way to pass data between subforms?
I have three tables that contain different columns but linked by a primary column call Name. I want to create a table where all these different columns in the three tables join to form a master table which can be updated regularly either through the master table or the smaller tables. The master table also has the primary column as Name.
If I update the master table with records, it should update the respective linked table and vice versa. I also want to link these tables to my SharePoint site.
Note: except the Name column, none of these tables have any other columns in common How do I go about this?
Please suggest me how to do it.Any code or sample like this. I don't know how to add new row of product e.t.c. Please help me as I have never done any programming in ms access before (Done most of web development,asp.net,jsp,coldfusion)
I have a Customer table in an Accounts Receivable late-payments database that has very basic fields:
CustomerNumber, Name, BillToAddress1, BillToAddress2, City, State, Zip, Phone
As we get changes from new invoicing activity, I need the table to update the contact info. So, we get a spreadsheet each day with new invoicing activity, some of which will already have customers in our database. I need to capture any new addresses or other contact information to update my current records. We append the new info to the Invoices table, then need to grab the new addresses and update the Customer table.
I don't know why I don't know how to do this, as it seems so simple. Any help is greatly appreciated.
I have a table "Project Master Code", contains: Project code, Cost Code, Description, Budget Amount, Total Purchase, Left to Complete.
For each project, we enter all above field except Total Purchase. Total Purchase to be taken from Transaction table.
What I want is that, I want to creat a query based on Project Master Code table. I will call all field from Project Master Code and in Total Purchase column I want all Purchase from Transaction table.on based of Project Code & Cost Code.
I have created a master & replicas and sorted out synchronisation across a VPN and overall l am very happy with what l have achieved (lots of thanks to to help l have received todate from this forum that has made that posssible).
I now have a couple of questions which are niggles rather than full blown problems.
THe first is my master keeps reverting to a replica version of itself, l press the reinstate master and it keeps it as the master for a period but it keeps dropping the master status. Firstly any ideas why ? and secondly how do l stop it keep changing?
Next every now and again synchronisation slows a relicants version down to the point that it VERY slow to open (almost like it is on a VPN itself not a local copy) No amount of synchronation from their end fixes it, however it would appear that a synchronisation from my end solves the problem.
I have a problem retrieving my Design Master. I regularly backup my DB onto a separate hard drive. And in doing so have lost my designing capabilities. I have tried replicating and retrieving the DM per the help section, but I receive numerous error messages telling me Error accessing file, network connection lost rollback error, etc. Any ideas would be greatly appreciated.
