Search results

Hi Everyone I have a query that selects 10 records from a true/false field. A report based on this query shows a count() = to 10 but only displays 9 records? Why? Any help gratefully accepted

That produced a strange result. When I select a document code a parameter query message box is opened with the document code as the text question. Typing in a code and selecting dispalys that document correctly. Resetting and trying another document code the form displays the previously selected...

Syntax error expected end of statement with cursor on the last " Any idea what has changed in 2007. My code worked perfectly in 2003

The combo box is in the header of the main form and filters the main form. There is a subform displaying the detail and dates linked to the ID of the main form.

The db is rather large and I cannot see a way to depersonalise it. The enable controls function has crept in form some other person advising me Function EnableControls(frm As Form, intSection As Integer, intState As Boolean) As Boolean ' Enable or disable controls in specified section...

Hi VbaInet That didn't work. I had to reset the form after opening it before selecting a document code. The initial state was as image 3 and the selection process did not work

Hi The reset code is Private Sub btnReset_Click() Forms!frmPatientInformation!combooptselOwner = Null Forms!frmPatientInformation!combooptDocumentCode = Null Forms!frmPatientInformation!combooptDepartment = Null Me.optSelDirectorate = Null DoCmd.Requery...

Hi Everyone I have a form that displays the results of a query. I have a combo box to select and filter information on this form. All worked well in 2003 but 2007 goes awry. Initially I have 957 results displayed from the query and after the initial selection from the combo code is Private...

HI I have two subforms on a main form. Second subform has its PK copied back to main form and then linked to FK of second subform. Works perectly on change of main form BUT if a second record is selected on the subform the the second subform doe not reflect the change and remains as was...

Code now Dim dbsCollege As DAO.Database Dim rstStudentAnnualCourses As DAO.Recordset Dim intCrsID As Integer Dim strSQL As String Dim intLastRecord As Integer intCrseID = cboSelectCourse.Column(1) Set dbsCollege = CurrentDb Set...

I realised as I posted that it was not necessary. The code cam in form a command button but with an after update is not necessary. I will rmove it and try your solution. I tried commenting it out but although there were no reproted errors it did not place intCrseID into the table.

Waiting for a selection in the Combo box ?

Waiting for a selection in the Combo?

wait for a selection in the cbo??

Wow SOS (apt name) that was quick The code now looks like this Dim dbsCollege As DAO.Database Dim rstStudentAnnualCourses As DAO.Recordset Dim intCrsID As Integer Dim strSQL As String Dim intLastRecord As Integer Me!cboSelectCourse.SetFocus Set...

Hi Thanks everyone I chose to move the UPDATE elements to the after update event and use the loop I now have other problems. Please see the last posting on my other recent query about passing parameters in Combo boxes Regards Paul :)

Hi I have had some advice to break the INSERT and UPDATE elements. The INSERT works perfectly and I now have the UPDATE elements in the after update event of the cboSelectCourse with a loop to detect if the cbo is empty. I tried your second solution, with # replaced by 1 because I have 3...

Hi I have a cmd button that, after help from members with the insert and update statements works with trial data. The on_click takes the pk from the form and creates a record in a linking table and then, after selecting a Course ID from a combo, updates the linking table on the last record and...

The second option is the one I need and I am sure it will work except the cboSelectCourse ="" and so the code runs straight through to the run SQL cmd and fails. I need an if then section to wait for a cboSelectCourse entry. How? Regards PAul

Thank everyone. I had found that changing from rst... to tbl... worked. Onto the next step. Paul :)