When using the help file in the vb editor i cannot get any topics on ADO or ADOX. I can see them in the index but there no related help topic appears. I have reinstalled all files from the Office CD, addded any references that look like they might have something to do with ADO but still no luck. Ideas anyone?
View RepliesI am creating a temp table using the following code:
Code:Dim cat as ADOX.Catalog Dim tbl as ADOX.Table Set cat = New ADOX.Catalog cat.ActiveConnection = CurrentProject.Connection Set tbl = New ADOX.TableWith tbl.Name = "tblContactsTemp".ParentCatalog = cat.Columns.Append "CustomerID", adInteger.Columns.Append "LastName", adWChar, 50End With cat.Tables.Append tbl
This creates the table almost exactly as I want it. The problem is that this creates all columns as required. I have read through all the Microsoft Knowledge Base items about ADOX that I can find, and I have not discovered how to set a columns properties to NOT Required. Does anyone have experience with how to change the properties for this?
I have been able to change one property, the AutoIncrement, on integer types, using:Code:.Columns("CustomerID").Properties("AutoIncrement") = Trueincluded after that column's append in the example above, but attempting something similar with
Code:.Columns("LastName").Properties("Required") = Falsedoes not work.
Any help much appreciated!!!
Thanks,
John
I have a table with some meeting topics, and I have another table with subtopics for each topic of which there can be multiple instances on no instances at all (let's say weekly updates if that makes sense).
What I would like to have on a report is all the information, all the topics, and for each topic, all the subtopics, if there are any. As an example:
Code:
-------------------------------------------------------------------------
Topic1 Description1 DueDate1 Responsible1 UpdateDate1.1 Comment1.1
UpdateDate1.2 Comment1.2
-------------------------------------------------------------------------
Topic2 Description2 DueDate2 Responsible2
-------------------------------------------------------------------------
Topic3 Description3 DueDate3 Responsible3 UpdateDate3.1 Comment3.1
UpdateDate3.2 Comment3.2
UpdateDate3.3 Comment3.3
-------------------------------------------------------------------------
What I tried so far is to make a query left joining the update table with the topics table and that seems to get all the data in one place, the only thing is that if more than one update is present for a topic, the topic will appear multiple times.
I then thought I could group the data into the report and I could ... sort of ... What I did is to add all the topic fields into the grouping header, that seemed to eliminate duplicates, but I don't like the results at all. First of all, the first (or only) update item does not appear on the same line as the topic, it appears below, and that would not even be that bad, I could live with that. The worst thing is that if a topic does not have any updates, empty fields are still present and they get shown even after grouping, as if being an actual entry. Even if updates are present, a blank line still appears along with the rest of the updates, even though it wasn't there before grouping.