Search results

I figured it out... i put also the requery command in the last part of the command button code.. Thank you all!

Thanks for the reply... There is something bothering me... the TextBox (txtHighest) does not refreshing even though i put a code Me.txtHighest.Requery... it will only change when i re-open the form...

Hello World, I have a query with four (4) columns, namely: ID, Name, Address, & RndNumber This query is for a raffle draw, that is why i included a column Random Number using an expression of RND function.. I want a VBA code to put the ID of the highest random number to the txtbox. I...

Thank you guys... @The_Doc_Man .. thank you so much for the reply, however, there is a solution... @arnelgp ... thanks, i tried your suggestion but it did not work.. @isladogs... YOUR CODE WORKS!! i only used the sub for stop playing.. and thanks for you attachment, i can use it in the future...

Hello AccessWorld, I have this Function code to play audio file in my Form: Declare Function apisndPlaySound Lib "winmm" Alias "sndPlaySoundA" (ByVal filename As String, ByVal snd_async As Long) As Long Function Playsound(sWavFile As String) If apisndPlaySound(sWavFile, 1) = 0 Then MsgBox...

Hello Everyone, I have a Report generated from a query. Below is the result: Is it possible that the result of my Report will look like this? I attach sample database file for your reference. Thank you in advance.

Hello World, I have this code that copy values to table: On Error GoTo ErrorHandler Dim db As DAO.Database Dim qdf As DAO.QueryDef Set db = CurrentDb() Set qdf = db.CreateQueryDef("", "INSERT INTO [TBL_Answer] (UserID, QAType, QuestionID, ChoiceAnswer, CorrectAnswer...

Thank you so much guys... I just put the code to enable the CommandButton1 after the code to open the form, and change the =Yes to =True. Once again thank you so much.

Hello... The situation is this: I have 2 Forms (let say frmBox1 and frmBox2). In frmBox1 i have CommandButton1 that I set the Properties>Data>Enabled = No. In frmBox2, i have CommandButton2 to open frmBox1. I want to insert a VBA code in CommandButton2 to Enabled=Yes the CommandButton1...

Hello, I have this query to get the information base on multiple Table (dB). I have one Table where the data has multiple entry, example: ID Date Amount 17-01 01/02/2017 0.00 17-01 02/02/2017 1,000.00 17-01 03/02/2017 500.00 I used "Min" in...