Search results

Guys, What is the best way to display all the records in the subform with the scrollbar if they don't fit in the subform. WHn I am saying records then it means Just Questions column values from the query and then Yes,No N/A radio buttons with all the Questions and Notes section too . Which...

Hi All I have a subform and I want to display all the records from a query in the subform so that the users can see all the records and make changes in that. SO the subform will display the Question names and there will be 3 radio buttons for score and the score needs to be updated. The...

Hi All I am writing the following code in the listbox double click event so that when the index is 1 then insert data in a table from another table. So I am using two recordsets but Its not saving data in a table. Private Sub lstTabPages_DblClick(Cancel As Integer) Dim i As Integer Dim rs...

Thanks , it worked great.

I want to define criteria in a sql string like Date >= StartDate and Date<=EndDate. The StartDate will always be 01/01/current year The EndDate will always be 31/12/current year How can I find StartDate and EndDate using vba? Any help will be much appreciated. Thanks

SELECT tblstaff.[Staff Name], Sum(1) AS Expr2 FROM (tblstaff INNER JOIN tblAction ON tblstaff.[Staff Number] = tblAction.Owner) INNER JOIN tblActionChange ON tblAction.ActionID = tblActionChange.ActionID GROUP BY tblstaff.[Staff Name], IIf([DateChanged]>=#4/1/2016# And [DateChanged]=#4/1/2016#...

Hi All How can I display Total on the top of each bar? Please see attached . Thanks

please see attached.

Re: Pupose of Sum(1) arnelgp, please See attached the other screenshot. What is Sum(1) doing in this? As there are 3 tables in total and in Sum(1) , table name is not mentioned so which table it refers too? Thanks

Pupose of Sum(1) Can anyone please let me know the purpose of Sum(1) in the attached screenshot? Thanks

please see the screenshot attached. Just wanted to know what is the purpose of Sum(1) in query design? Thanks

Can anyone please help me in this? Thanks

Thanks Guys for all your help. Very much appreciated.

I have Id field in the table whose data type is set to autonumber. The problem I am getting is suppose the last record added in the table has id=100 . If I delete this record then the new record will have id=101 but in actual I want Id=100 so it should be in serial order . I want the code...

The only problem I am getting is to Refresh listbox on MainForm from the Editform(which is on the top of MainForm)

JHB, because of security restrictions in the company, I am not able to send database attachment.

Also In the form "Frm_Function_T", the listbox "lstDue" has a rowsource property which is set to as follows: SELECT tbl_Mas_DocLog.DocCode, tbl_Mas_DocLog.DocName AS Name, tbl_Mas_DocLog.Date_Expired AS Review FROM tbl_Mas_DocLog WHERE (((tbl_Mas_DocLog.Date_Expired)<Date()) AND...

I changed that line to the following and not getting any error now but it doesn't refresh the listbox named "lstDue" Forms("frm_Function_T").Controls("lstDue").Requery

ANy idea anyone why I am getting error message in that line?

The following line produces error: Forms!frm_Function_T!lstDue.Requery