Search results

Hi Guys, I'm working on a Form in Access 2007. In the vba code window I have the following: Private Sub Display_Cost_Centers(SubsectionID As String) Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim query As String Dim recordCount As Integer Debug.Print "SubsectionID: " & SubsectionID...

Hi there, I've created a form in Access that has a text field and a single button which is to search the database by matching up a Cost Center number entered into the text field, and return a number of fields in association with the number. In this case: DIVISION, BRANCH, SECTION AND...

Hi there, I've created a number of tables which represent a hierarchy. They go as follows: DIVISIONS |_ BRANCHES |_ SECTIONS |_ SUBSECTIONS Each of these is a table. Each table contains an ID referring to the parent table as follows: DIVISIONS: DIVISIONS_ID - AutoIncrement - Primary Key...

Hi there, I have a form with two subforms. I set the RecordSource property for each subform progammatically by setting it to an SQL statement. This works, however, the subforms are read only. I can't edit them for updates to the appropriate tables. I created a button for each subform on the...