Search results

My form is made up of multiple tables that have a 1-to-1 relationship. It also has a subform which is a 1-to-many relationship. Adding a record from the form by filling in fields only from the main table works fine, but, if I fill in a field from another table, it sometimes works and sometimes...

But how would the selected item fill txtAssignmentNo in the main form?

Is there a way to make a popup list open on click of a button (cmdAssign) and the user chooses/selects something from the list, then the popup closes and the textbox (txtAssignmentNo) is filled with the choice?

Thanks so much for this guys, I got what I was looking for. I'm just gonna go change all my lookup fields to form level only!

I'm sorry for my ignorance but what do you mean by directly referring to the lookup table? And how do you use a query for this? Is it also possible to conclude by getting a drop down on the form level?

I need the field to be a lookup field, unless there's a different way to limit a field to a list from another table. Is there? The query thing would be too complicated and unefficient I think because this form is a subform for another form.

Yep, thank you. It mostly works. The 2nd and 3rd fields show just fine, but the 1st box doesn't because the corresponding column in the drop-down just displays "1". This must be because the field is a lookup field (to another table). How can I workaround this?

In my form's table (tblMain), I've got a lookup field (drop-down list) that lists the primary key field from a different table (tblDiff). tblDiff includes 3 more fields. In my form for tblMain, I want to include 3 more textboxes that get filled up with these 3 fields from tblDiff when the...

Thanks a lot! It works. And yes, that's correct.

Here's further explanation. On my main form (with students details - Primary Key: StudentID), I will have a link to a popup form, where the user adds/edits student groups (tblGroups records). Now, within the main form, I'd also like a subform for tblStudentCourseRecord (that is filtered...

Okay, I've done that. Here are my tables: tblCourses CourseID (PK) CourseName ...CourseCode | one-to-many | tblGroups GroupID (PK) CourseID (FK) ...CourseStartDate ...CourseEndDate | one-to-many | tblStudentCourseRecord RecordID (PK) GroupID...

I've got a table, where each record is a group of students. So the fields include Student1, Student2, Student3, etc. I know this is bad database design, but I've done this because I want the group number (primary key) to be automatically generated. Now, I want to add more information for each...

Thanks I tried this, but it doesn't work. Private Sub txtAddress_AfterUpdate() If InStr(1, Me.txtAddress, "London") <> 0 Then Mid(Me.txtAddress, 1) = UCase("London") End If End Sub

Thanks but how would I implement that?

I've got an address box on my form. When someone enters 'London' inside the box, I want only 'london' to be changed to all-caps.

I was just looking at that, as you posted it lol. Thank you berry much.

No, the actual database hasn't got a seperate table for the contact details. And the example db does represent my db, only not in terms of design and field numbers (I don't imagine that matters a whole lot).

This isn't my actual database or anything similar to it in terms of design and table fields. It only resembles similarity in the table structures and whatnot. My actual database is a lot bigger and has much more in it. How did you do that? What's a left join?

Here it is! This example db has the same problem. The first 3 records in tblDetails show in the form because all tables linked to the form have data in them. The next 3 records in tblDetails don't show in the form because they are missing data from 1 of the other 2 tables. I want to allow an...

I can't do that; it contains confidential info, but let me quickly draw a similar database with the relevance and upload that. Thank you.