Search results

Hi All I have designed a Health check form in Access and data gets saved in tables. I have designed a continuous sub form for all the questions and result gets stored in table tblTC . Its working perfectly fine. But now I need to display the result in Word template and the users might...

Thanks Guys, I have a question about naming the queries. If a query involves about 3 to 4 tables then how should we name it. My tables are starting with "tbl" prefix. Queries are starting with "qry" prefix. Any help will be much appreciated. Many Thanks.

Hi All I have a question about naming conventions. If we have suppose 10 queries linked to the form (subforms) or something like this. How should we name the objects to distinguish them from each other and the names that clearly define the purpose of the objects. I had a look online and...

Hi All I have a subform within a form that is linked to a query. It is working perfectly fine. But I forgot to add a condition in a query earlier. And when I have added a condition in a query and try to run form then the subform doesn't give me the right result . It doesn't check the condition...

Hi All I have a form named "Frmsearch" and there is a listbox so on the double click event of the listbox , another form will open with all the data relevant to item selected from the listbox. Now I want to check if Saved field is True and if yes then make all the controls disabled. The...

Hi All The textbox named "txtreference" has a value stored in it.The following code isn't working?? Private Sub txtReference_AfterUpdate() Forms!Form2!txttemp.value=txtreference.value end sub

Also I want to disable the controls when the form is opened but its not doing that : Private Sub Form_Open(Cancel As Integer) Dim ctr As Control 'MsgBox Me.chkSaved DoCmd.Maximize Me.cmdSummit.Visible = False If IsNull(Me.cboAgent) Then Me.cboAgent = Forms!frmForm!cboStaff End If...

Yes please see below: Me.lstSearch.RowSource = "SELECT tblAudit.AuditID AS Ref, tblstaff.[Staff Name], tblAudit.[Call Date], tblstaff.[Staff Number] FROM tblstaff INNER JOIN tblAudit ON tblstaff.[Staff Number] = tblAudit.[Staff Number] WHERE (((tblAudit.AuditID)=" & Me.txtReference & ") AND...

I have a form Frmsearch that has a listbox named lstSearch. When we double click on the item in the listbox then another form gets opened up with that record. Please see below the code: Private Sub lstSearch_DblClick(Cancel As Integer) Dim sForm As String Dim sSQL As String Dim rs As Object...

Hi All I am trying to open the form for a specific record. The following code works fine: sForm = "frmABC" sSQL = "[AuditID]=" & Me![lstSearch] DoCmd.OpenForm sForm DoCmd.OpenForm sForm, , , sSQL But why the following isn't working????? DoCmd.OpenForm...

It worked fine. Thanks

CJ_London, I am writing the following code but it doesn't seem to be working. I will always have 3 records in the subform so I have written the following code in the click event of the checkbox. Sometimes the value of a,b or c is right and sometimes its wrong (sometimes it gives old recordset...

it is only access. I am not able to update records. My recordset for the subform is linked to a query(which is using 3 tables).

CJ_London, Can I check individual record using do while statement? How can I use any loop within subform recordset? As I have some more calculations I need to do.

Thanks. As there will always be 3 records in the subform. I also want to check 1. if score of any record is 1 then store in another textbox "Doesn't meet expectations". 2. If score of any two records is 3 then store in the textbox "Exceeds" 3. ANy other combination store "Meets"

Hi All I have a continuous subform. It works fine and displays the records from the query. But now I want to display the total of "Score" field value in that recordset and display that in a textbox (may be on the footer). How can I do the sum of "Score" field value in all the records in...

Hi All, My subform is now working fine and its updateable. My question is how can I display all the records on the subform? can anyone pls help me in this? thanks

ok. I will check. Thanks

But my other subform is working fine and it is based on the same query :(

Hi ALl I have few subforms within a form. My other subforms are working fine except one. When I try to make some changes in the subform like adding something in the textbox or selecting optionbutton thn it doesn't do anything and a message "Recordset is not updateable" comes up in the...