Recent content by reysy28

Thanks CJ, it WORKS!!!

Hello, I added several records in another table but it wont show the records until I press the Refresh button at the ribbon of Home-> Refresh. How can i view the records automatically without pressing the Refresh button? thanks

Hi, Answer is a field and Ans1 is also a field of the same table, am trying to copy the content of Ans1 to Answer.

Hello guy, Am having this error, the source field of this is a query.... Private Sub Command6_Click() Dim m_ans As String Dim cn As ADODB.Connection Set cn = CurrentProject.Connection m_ans = Ans1 cn.Edit cn!Answer = m_ans <==== this is the...

Hello guys, What seems to be the syntax error on this command.... It says Syntax error in strSql = ........ Private Sub Command6_Click() Dim cn As ADODB.Connection 'Purpose: Create a new query using ADO. Dim strSql As String Set cn = CurrentProject.Connection...

Thanks Stopher, it works great, now I can finish my questionaire system...;)

The idea is this...... we have 100 questions and I need to get 50 questions in random order...

Thanks Pr2-Eugin, I already read that but the problem is how to write the code and to check if it is unique or not and how to save it on my table....

Hello Guys, I have this small problem that I can't solve, hope that somebody will help me on this. I have a one table that has a one field call QuestionID (Integer), I would like to random an integer number from 1 to 100 and save 50 unique numbers on my table. At the end I will be...