Recent content by zan

oh wow! Max works perfectly! I just love this forum... I basically built the whole database with help and knowledge here. Thanks a lot, ajetrumpet and neileg. :)

Hey guys, I really need some help on this problem. I have a database for a tutorial center, and we have invoices recording the dates of the lessons that students pay for in this month. We have a reminder form that display query results when today is the last lesson for the student so we can...

I would like some help on this one: I have a continuous form based on a query. It only has a single text field txtStudentName. What I want to do is combine all those names into a single text field separated by a comma. Any help would be appreciated!:D

Thanks RuralGuy! In my search for calendars I found this http://fontstuff.com/access/acctut13a.htm which was exactly what I wanted!

Thanks! The dateserial() function works just fine, but I've encountered another problem. What I actually want to enter is a birthdate. Right now the text box gathers the values from the 2 cbo boxes and text box and then stores the value into the birthdate field in my table, but since the cbo...

I'm not quite sure how to insert the "msgseen" you mentioned. Btw, what I eventually did was put cmdenter.enabled=false under cmdenter_exit. It works just fine, execpt that the button will not turn gray.

I've searched for this everywhere but I haven't yet found a solution, even though I'm sure it should be pretty simple. I have 2 combo boxes: cboMonth, cboDay and a text field: txtYear cboMonth has values: Jan-Dec cboDay has values: 1-31 After selecting the combo boxes and entering the year, I...

Thanks! I solved my problem on #2. As for #3. I know how to enable the cmdButton after I enter value in the text box, but what I want to do is disable the cmbButton again after I have clicked the cmdButton. Anyone can shed light on how to open a msg box only the first time you click it??

Hi guys. I have a few problems with my message box. 1. How do I enable a message to pop up only the first time I click a save button on a new record in a form? 2. How do I run the following ONLY AFTER you click Yes on the message box? After you click yes, it can be locked forever...

Exactly! :) That was so simple. I keep getting an error message, maybe I bound the wrong column. Thanks a lot!

I know how to base the combo box on a query, and in the after update enter Me.[txtboxName]= Me.[cboName].Column(1) BUT... I want to bound the combo box to a control source. How can I achieve that? Thanks~

I've actually solved the problem, in case anyone else is interested. I set Private Sub Home_Tel_AfterUpdate() Me.Student_Name.Requery End Sub and Row source for my combo box Student_Name to be SELECT qryNameTel.StudentName FROM qryNameTel; query was same as above post.

Combo box from text box value Simple question but I've been stuck for a looong time. So what I want to do: 1. enter a value into a text box (Home_Tel) in a form (frmStudentClass) 2. which runs a query (qryNameTel) 3. and return the results to a combo box (Student_Name) on the same form. The...