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

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

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

Hi Thansk to everybodies help over the last few days I have learnt a great deal. After a rethionk I now have reduced a 3 step process to 2. The insertion of a record and the update of that record Dim dbsCollege As DAO.Database Dim rstStudentAnnualcourses As DAO.Recordset Dim intStuID...

Hi I am now trying to find the last record in a table and update a field in that table. The code I have is Dim dbsCollege As DAO.Database Dim rstStudentAnnualcourses As DAO.Recordset Dim strSQL As String Dim intLastRecord As Integer Set dbsCollege = CurrentDb Set...

I am trying to add data in a related table using the PK in the data in a form. The form is based on a query selecting all Student records. Query not table because I wanted to show descriptions not numbers so have to have linked tables. The code I have so far is: Private Sub...

Hi Everyone Here I am tearing my hair out again. I have a simple form for data entry with the owner of the document selected from a combo box based on the table Owners. Selecting an owner puts theOwnerID into the underlying PatientInformation table. I have code that allows the NotInList to...

Hi Everyone PBaldy offered me this code to use an Option Group to filter a form Private Sub Frame45_AfterUpdate() With Forms!PIInput Select Case Me.Frame45 Case 1 .RecordSource = "SELECT * FROM PatientInformation WHERE Directorate Like 'Ambulatory Care'" Case 2...

Hi Everyone I have a Command Button to Preview a report, filtered on the options selected by a combo box. If no selection is made the preview works fine but is a selection is made I get a Data Mismatch error. The code is DoCmd.OpenReport stDocName, acViewPreview, , "Directorate=" &...

Hi Everyone My coding skills are not great and I have seen many posts on creating Title Capitals. I would like to code for title caps except for words of 3 characters or less except if that word is the first word in the field. Another problem I have is Capital initial letters for Names. This...

HI Everyone I am trying to copy the above dialog form to make selections for reports. Unfortunately Access 2003 seems to have diffferent soded and will not allow the If Is Null lines with a compile "expected end of statement" error. I have tried different methods of specifiying the condition...

I am trying to create a select query on "ApprovedDate" where no approval is recorded. IsNull returns an expected type mismatch. Any ideas? Regards:confused:

Hi Everybody I want to open a form to add records using a subset of records filtered on a query. eg "department" and then display the last record when query is ordered on "DocumentCode" But don't know how? It just displays the first record in the subset. Any help would be appreciated Regards...