473,958 Members | 1,228 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Help needed with ms access forms!!! ASAP

1 New Member
Hello Everyone,

I am in a need of some one who can help me with the database iam building. I have student enrollment to distance program database with the first form having the general info of the student like stid, last name, first name, and a subform in the same form with the courses that the student enrolled. I have a click button in the student info form(first form) that on click directs to another form which has the dvd's info that the student had purchased for perticular course. My problem is that i need to have the student name, id repeated in the secong form for the perticular student i have in first form. I cannot do this. I will be greatfull if anyone plzzzz help me in this.

Thank you
Apr 11 '06 #1
3 2010
Accessgoddess
3 New Member
I'm not sure what you mean. Are you saying you need the id so that you can filter the second form or that you just want to display it?

To filter it you can add a reference to the underlying record source query that uses the student id from the first form. If you just want to display it you can add a text box control use that to reference the id.

Either way its Forms!formnameo ffirstfirm!name ofIdControl

Does that help?

Jo
Apr 13 '06 #2
mddrains
12 New Member
Instead of displaying the student name on the subsequent forms, you might try to put the secondary forms on tabs that display just below the data you want repeated. When the user clicks a tab, the primary data would continue to be displayed, however the entry would be for the secondary fields.

D
Nov 12 '06 #3
PEB
1,418 Recognized Expert Top Contributor
In the respective table with multiple ID student records have you setted this ID for the student?

I mean the table with the DVD's?

Create ID student that have the same structure as The ID in the Students table..

If it is Autonumber set it to Longint Indexed with Dublicates...

Than create the relationship between The table students and table getted DVD's

Choos the type One to maney enforced... when you delete an entry from Students it deletes the respective records in DVD s


Hello Everyone,

I am in a need of some one who can help me with the database iam building. I have student enrollment to distance program database with the first form having the general info of the student like stid, last name, first name, and a subform in the same form with the courses that the student enrolled. I have a click button in the student info form(first form) that on click directs to another form which has the dvd's info that the student had purchased for perticular course. My problem is that i need to have the student name, id repeated in the secong form for the perticular student i have in first form. I cannot do this. I will be greatfull if anyone plzzzz help me in this.

Thank you
Nov 12 '06 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

7
2092
by: James Fortune | last post by:
In response to different users or situations (data context) I transform the appearance and characteristics of Access Forms through code. This seems to fit in with the idea of polymorphism. Do people consider Access Forms to be Polymorphic? James A. Fortune
4
1354
by: Law.Win | last post by:
I have been looking for a way to figure out how to pass specific record information from a continuous form onto another form. What I have done was created a button in the detail section to open another form. This form has text boxes and I linked their properties to the first form, but it pulls the first record's information instead of the one the button is next to. How can I accomplish this? I have been looking for information for a...
1
1068
by: nomaam | last post by:
Here is an example in VB, could someone show me how this can be done in VB.NET in a windows form? ============================================================ I'll use this page in Experts Exchange as an example. Click Ctrl+T and choose "Microsoft Internet Controls", then add the control to your form. Change the name property to wb.
3
1597
by: cappelquist | last post by:
I have a small Task List / Project Management / Time Management app I'm building for my own use. Any "Getting Things Done" (GTD) users out there? I want a main form that has a large List Box on the right side of the main form that will list Projects by name. In the top right section of the main form, I want a sub-form that will be a Datasheet format that will list Tasks for a given Project. So, I want to be able to Highlight a...
5
3631
by: Anns via AccessMonster.com | last post by:
My establishment has about 20 ms access db's that will be converted over (see subject). When we pull all the BE's over to SQL and the FE's on Sharepoint (.net) surely we don't have to change every user face, we should be able to use the same FE in as before as now on Sharepoint? ANSWER:
3
4596
by: mumbaimacro | last post by:
hi i am a newbie to access programming,, i need help to 1. view PDF inside Ms-access forms whether the PDF Location from the Folder or the Path in table. 2. view ms- photoeditor inside ms-access forms.
1
1426
by: jgill | last post by:
Have problems with the recordset…if the value of tempPremium is more than > 10,000 than I get no results after this statement executes: set rsDownPayment = applyFilterAndReloadRecordset(rsDownPayment,"min_premium <=" & tempPremium & " and b80_userline = '" & objLogic.userline & "' and profile = '" & objLogic.profile & "'") I was trying to debug the application using response.write statement but get no results if the values of tempPremium...
19
25865
by: jalmar | last post by:
My question is related to Access forms. I have set up an Access form using 4 different tables~I am pulling 2 different numbers and the name of Trusts out of one table, I am pulling custodian name and acct number from 2nd table, 2 different numbers from Investment manager table and then 3 empty fields (at this time-needs to be populated by form) out of the 4th table. Can you tell me why I am not able to enter data into the 3 empty fields while...
2
1355
by: =?Utf-8?B?UGV0ZQ==?= | last post by:
Happy New Year everyone. Quick question: does anyone know a good tool for converting Access forms into VB.Net form? Pete
0
10255
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10066
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11697
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
11314
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
11464
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7521
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
6296
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
5049
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4630
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.