Recent content by ChoonHong

Hi All, I have a question on sending Email alert msg. I have this form whereby user would enter all the fields required, and when press the "Add" button, it would insert all these fields to the database as well as sending out alert msg to the email. I have no problem inserting the fields to...

Thanks alot for pointing out my mistake Pwise!

Hi, not sure if this is the correct forum to post at. Recently I have tried to used Visual Web developer 2008 to code my stuff but I have a problem on the following inserting command code. During debugging, its free from errors, but when I press the button, nothing goes into the database. Can...

Hi, as i do not have my "VB" help installed i can't use this function. Now i have created a function bound to a textbox and "Calculate" button to update my table. But it always prompt me to enter a value on the textbox and say that there is no value in the table. I have created a table for my...

Hi, i have a problem on the SQL Query. Now i have a unbound textbox which i had created on "Forms". The question is this, am i able to update the integer in the unbound textbox using VB commands? I know that there is a command called DoCmd.RunSql, how do i use it? I tried to look at the help...

Hi, i have a problem on the SQL Query. Now i have a unbound textbox which i had created on "Forms". The question is this, am i able to update the integer in the unbound textbox using VB commands? I know that there is a command called DoCmd.RunSql, how do i use it? I tried to look at the help...

Hi all, I have a question to ask, when i refer to your thread (thread702-446213) I tried to use the method that Chrissie had suggest. But it prompt me a "compile error: Method or data member not found". I have already create a data called "File" in my table but why was there still an error in...

the default value - when i put 1 as the default value the checkbox is check. but is there a possible way where i can assign a digit/value to the checkbox so that when the checkbox is checked it would add up the total checked box value to perfrom a calculation?

There is a question on checkbox. Is there a way that i can assign a value to my checkbox so that when the checkboxes are check, the values will be added up and perform simple calculations. Is that possible? If there is could some kind ppl show me a example or 2 to make the program work~ thanks~

Thanks for yr help! I do it the way as u mention but it does not return the desired result i wanted~ The combo box does not filter out the results i want~ do i need to change anything to the subform (qryBE:i create a subform using qryBE)?

Can anyone help me with this issue: I have a query form which runs like this: Field: Division Diploma Modules Name Modules Number Level Table: Module Module Module Module Module Sort: Show: „Ï „Ï „Ï „Ï „Ï Criteria:Like ¡§BE¡¨ I have also create a subform query...

There it goes~~ thanks!!

This is the code on my add button: Private Sub btnAdd_Click() On Error GoTo Err_btnAdd_Click Dim stFirst As String Dim stLast As String Dim stPhone As String Dim stHp As String Dim stFax As String Dim stMail As String Dim stLocation As String Dim stDivision As String Dim stTitles As String...

OMG looks like my file been courruptted... now even if i cancel the previous codings i can't save my records...

Yah i have link my form to my Particulars table. I have also done what u have ask, creating a label to do the counts. Now i have a coding which act in this way: Private Sub Form_Load() 'Maximize the form window on startup. DoCmd.Maximize DoCmd.GoToRecord , , acNewRec...