Access 2007 Tutorial 3.1. Forms and Subforms

[agapitoflores001]

i am really looking for this kind of video to help me improve my work. Great help!

[broken00heart00]

i'm having problem with creating the search button. Can anyone help me please?

[shoexy]

Excellent video !

[slathered]

I realize that one can pause and start the video at will, but why do you have to talk and click at such a fast pace??

[Josephdoan]

great tutorial ! i was able to adapt it to my project.

just a question: is there any way that by selecting the title from the drop list in the form, all relevant info (MPAA_rating, release_year ...) will appear automatically for that record ?

Or navigating record one by one at the bottom of the form (i.e. record 1 of ...) is the only way ?

Cheers,

[giorgio89789]

This tutorial helps a lot, but it seems that this method will only allow you to select from the list of already established directors, but if you wanted to write a new director directly into the form (plus all other pertinent information), you wouldn't be able to because its actually the Director id field and not the director name.

I'm asking this because I'm wanting to have a combo box that will allow me to look my through table, allow me to select an already created object or create another.

[djdates]

@giorgio89789 Great point! When you type in a director that doesn't exist, you get a message saying "The Text you entered isn't an item on the list". However, Access also triggers the NotInList event, and we can write some code that will automatically insert the director into our table. However, because we are typing in the name as "Lastname, Firstname", we will need to do some string manipulation. Google "NotInList" or check back in a week, and I'll walk through the needed code.

[bmarshall786]

Hi, this maybe a really stupid question but i am having trouble following the video. I have got to the point with my form where I have created the form and the query. But my Director ID hasn't actually changed to names, also i'm not pulling back two columns. What am I doing wrong?

[djdates]

@bmarshall786 You may have missed a step. At about 5:15, we set column count to 2 (which tells the combobox to show two columns) and column widths to 0" (which hides the first column, so only the second column, the names, are shown.) Hope this helps.

[1mustangsally]

Speaking slower would help. All I hear is blah, blah, blah. It's hard to follow.

[pedrohiramlive]

Hey your vidio have help me alot ... I just have one questions... in my access 2007 if I try to change the combo box to show data instead of the ID, when I get to the DATA tap I do not get a ROW SOURCE... can you help???

[djdates]

@pedrohiramlive You may not have a Combo Box yet. Right click on your field, click on Change To, and then select Combo Box. Hope this helps.

[alionabarbaros]

why thank you!

[farhanyun]

im just wondering the corresponding video.what is next video?

is it tutorial 4.1 or 3.2?

where is the 3.2 tutorial? 

[djdates]

@farhanyun There is not currently a 3.2 video. Next video in the series is 4.1, on Access Reports.

[pamelana25]

THAKNS!!!!!! For sharing your knowledge with everyone. Easy, Effective and Interesting.

[FlumenSanctiViti]

Thank you for this great demo, it helps a lot!

[cameronJstewart]

Good cheat at 5:50 as to how to hide a foreign key field in a form (ie column width 0), didn't know how to do this before. Repeated again at 6:30. Good demo to see the overview of the whole workflow.

[1Nauman1]

good video but how do you craete a custom subform

[ManyInfiniteComments]

Good explanation, but needs some spice

[watsonjnr81]

Excellent, thank you for this video post. I was looking all over for the web for answers and you explained everything i need to know in 10mins! Great! Looking forward for more of the same.

[amitkr]

very well explained. Thank you!