Search results

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...

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...

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...