Recent content by ashiers

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

Damn! You were right. I wound up changing the query by putting square braces around every table and field name in order to make it work: SELECT [DIVISIONS].[DIVISION], [BRANCHES].[BRANCH], [SECTIONS].[SECTION], [SUBSECTIONS].[SUBSECTION] FROM [DIVISIONS], [BRANCHES], [SECTIONS], [SUBSECTIONS]...

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

So, it would seem that from the literature you pointed me to, the thing that is preventing the subforms from being updatable is the fact that my query is accessing more than one table in a join?

ok...I've made sure that the properties AllowEdits, AllowAdditions, and AllowDeletions are all set to true on the main and subforms. It was also suggested that the Recordset be a type that allows updating. Following are the two versions of my RequeryForm() method. One deals with the...

OK. So how does one ensure a recordset is updatable from an SQL statement? I'm not familiar with that technique. All I used was a SELECT * FROM LANDLINES WHERE [yadda, yadda, yadda] The WHERE clause provides specific filtering. Please advise, Alan

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